Post by srain » Fri Feb 01, 2019 8:28 pm

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?

New member

Posts

Joined
Thu Apr 02, 2015 2:04 am

Post by MarketInSG » 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.


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by srain » Wed Feb 06, 2019 6:07 pm

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.

New member

Posts

Joined
Thu Apr 02, 2015 2:04 am

Post by MarketInSG » 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


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by webmedialdh » 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

Webx IT Solutions
Tel: +91 99154 09292, Skype: webmedialdh, Email: support@webxitsolutions.com
Image


User avatar
New member
Online

Posts

Joined
Fri Apr 22, 2016 5:52 pm
Location - Ludhiana, Punjab
Who is online

Users browsing this forum: fegdeed and 33 guests