Page 1 of 1

Bulk move subcategories

Posted: Mon Apr 23, 2018 4:08 pm
by alarsdes
I have a lot of categories and sub categories..
At this time oo many subcats for a category. The pages are growing to heavy.
so I am thinking about making a extra menu step. this means I have to re-locate the subcategories.
Is there a way to easily move sub-categories from one cat, to another cat.
Does one have a solution for this. Is there an addon for bulk relocate subcats.
Thank you

Re: Bulk move subcategories

Posted: Mon Apr 23, 2018 5:15 pm
by thekrotek
Open PHPMyAdmin and use this command:

UPDATE category SET parent_id = X WHERE category_id = Y

Command syntax says for itself, nothing complex here.

Re: Bulk move subcategories

Posted: Mon May 07, 2018 3:47 pm
by alarsdes
Thanks but that is not it.
I want to move only selected categories. This way I move all the subcats.
Do you have another idea on how to handle this.

Re: Bulk move subcategories

Posted: Mon May 07, 2018 5:38 pm
by thekrotek
I gave you an example query, you can expand it any way you like and update only the desired categories. This ia the easiest and fastest way providing you can usd MySQL or at least read its documentation.

Re: Bulk move subcategories

Posted: Tue May 08, 2018 2:48 am
by katherinerogers
Thanks for your response with this command. It has helped me a lot!