Hello
If you have a subcategory
And you want to move all ads from the subcategory to the main category
It is very difficult to manually edit each ad and add it to the main category
Is there a way to move all ads from the subcategory to the main category?
Thanks

@rooman
You can go to database and run update statement:
UPDATE oc_t_item SET fk_i_category_id = 123 WHERE fk_i_category_id = 987
123 - new category ID
987 - old category ID

@rooman
You can go to database and run update statement:

Code: [Select]

UPDATE oc_t_item SET fk_i_category_id = 123 WHERE fk_i_category_id = 987
123 - new category ID
987 - old category ID

Very cool
It works perfectly
Thank you

@rooman
Welcome