How to change multiple products' category?

I've 86 products, I want to change 25 products' category to "Fun", 41 products to "Stories", 7 products to "General Knowledge", etc.,

There is any solution to select more than one products and change their "category"?

Or, can I do it by mysql queries?

are the products grouped by their categories, or do you have the range of product IDs? If you have, you can mass update using SQL query.

MarketInSG wrote: ↑

Mon Feb 04, 2019 8:48 am

are the products grouped by their categories, or do you have the range of product IDs? If you have, you can mass update using SQL query.

Thanks bro!

They are not in categories nor in ID ranges! thats my biggest problem! (

If any solution to select manually and apply a specific group?

Or can I change categories by SQL query? if so, any query sample pls?

AFAIK, i checked many extensions, could not find one.

if there's no pattern, it isn't possible to mass update. but here's a query to add it to a specific category

INSERT INTO oc_product_to_category SET product_id = '123', category_id = '456'

123 = your product id
456 = your category id

you can use the extension which helps you to update the mass products in one click. free and paid both extensions available for that
https://www.opencart.com/index.php?rout ... n_id=25297

MarketInSG wrote: ↑

Tue Feb 12, 2019 1:09 pm

if there's no pattern, it isn't possible to mass update. but here's a query to add it to a specific category

INSERT INTO oc_product_to_category SET product_id = '123', category_id = '456'

123 = your product id
456 = your category id

Thank a lot! I'll try

webmedialdh wrote: ↑

Fri Feb 15, 2019 2:30 pm

you can use the extension which helps you to update the mass products in one click. free and paid both extensions available for that
https://www.opencart.com/index.php?rout ... n_id=25297

Thanks! looks great! but no free/trial version, I'll try!