Group pricing

[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.

[Lilia]

So last question before trying
UPDATE products SET products_price = products_price * 1.12 where master_categories_id = 3617;
should change those 14 parts price 12% higher in that group ?
http://www.jmtech.fi/kauppa/index.ph...cPath=860_3617

[Lilia]

Working well thank you both boys who help me and 100 kisses wow