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 ?

[VDecalS]

I believe you want * 1.12 (1=current price, .12=12% increase)

[VDecalS]

*12 will multiply you price by twelve.
You might try changing just one product to verify desired results, then you can change the entire group/category.

[mc12345678]

Also understand that if a price is "blindly" updated by 12% (or almost any percentage not ending in a 0) that the per unit price could become squirrely, ie. if you have something priced at 11.99 and increase it by 12%, the price becomes 13.4288 (in most currencies this will display as 13.43 for one unit). Buy 5 of them and the total price is displayed as 67.14 which is a one cent reduction in total price as compared to 3.43 having been entered because of rounding.

Also that next time a change is identified to be made that the next "percentage" may also result in some unusual rounding issues as well...

[Lilia]

Thank you very much VDecalS and mc12345678
Good I didnt try yet, anyway need wait friend take copy before make it.