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.
Thanks bro!MarketInSG wrote: ↑Mon Feb 04, 2019 8:48 amare 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.
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
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
https://www.opencart.com/index.php?rout ... n_id=25297
Webx IT Solutions
Tel: +91 99154 09292, Skype: webmedialdh, Email: support@webxitsolutions.com
Thank a lot! I'll tryMarketInSG wrote: ↑Tue Feb 12, 2019 1:09 pmif 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
Thanks! looks great! but no free/trial version, I'll try!webmedialdh wrote: ↑Fri Feb 15, 2019 2:30 pmyou 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
Hello.
My module Product Manipulator can mass change product categories - you can filter products by a category and then set needed categories to them (or mass delete unwanted category and add a required one)
My module Product Manipulator can mass change product categories - you can filter products by a category and then set needed categories to them (or mass delete unwanted category and add a required one)
Who is online
Users browsing this forum: No registered users and 18 guests
