Group pricing

[Lilia]

Is there someway possible uppgrade all prices inside product group ? I need make prices up 12% to some groups where total about 1000 products so very hard make one by one those. Many thanks if anyone could advice amateur girl

[mc12345678]

What is common between all of the items in the "group"?

It is possible to use a sql statement to update the price of all items that can be retrieved using some common criteria (all items that are displayed in a category, all items that have a master_category_id of x, all items that have the word blue in the product name or description, etc...)

Then there are bulk import/export product programs that can be used to export a series of product, modify something about it and upload the change(s). This is really only suggested if you plan to do such changes more than once (as in daily, weekly, or even monthly). While powerful, they too require a learning curve that may not be worth dealing with if it's a one time only change.

As always, the more info/description provided on how something is desired to work and what it is doing in relation to that helps identify a solution. In this case, more detail about what "group" is to be affected.

[Lilia]

Thank you mc12345678
I have program Apsona Shopadmin in ZenCart, maybe using it its possible import/export like you say, I need learn little and try then. Have a nice day

[VDecalS]

Check out Ajeh's solutions: https://www.zen-cart.com/showthread....767#post679767
I also use thread reply #58 for rounding.
Good Luck!

[Lilia]

Ok, thank you VDecalS

[Lilia]

Hello everyone

So if I use:
UPDATE products SET products_price = products_price * 12.00 where master_categories_id = 3617;
It should be change price up 12% inside that group ?