Price mass increase

[Ayojewel]

Hi,

 

I need an sql query code to mass increase or decrease my product prices by a specific price. For example, by $200 or 200 naira(my currency is naira). I know how to increase by percentage. I use prestashop 1.6.

 

Thanks for your help.

Edited October 4, 2016 by Ayojewel (see edit history)

[shokinro]

If it is price decrease, then you do that at store back office - Prices Rules - Catalogue Price Rules that applies to whole catalogue.

For price increase, you may have to use SQL statement to change product original price.

 

you may need to update following tables

 

ps_product

ps_product_shop

Edited October 5, 2016 by shokinro (see edit history)

[Ayojewel]

Please give me these sql statements.

 

Thanks so much.

[shokinro]

it will be something like this to update all products increase price with 100.

 

UPDATE ps_product set price = price + 100;

UPDATE ps_product_shop price = price + 100;

 

Please make a backup of your database before make any changes, in case you want to go back to previous state.

[Ayojewel]

Please i offer discounts on all product prices. Will this affect both base and final prices?

 

Thank you.

[shokinro]

It will change base price so of course it will also affect final discounted price.

[Ayojewel]

Thanks so much for your help. I have tried, and it worked. However, i noticed that final prices are calculated by raising the base prices by 10% and subtracting the discount amount from the new base price. This is a problem for me as the final prices are what i use. Is there a way to increase ONLY the final prices by 10%?

[shokinro]

the final price is based on based and other discount you set for the products.

it is impossible to do so without knowing the existing discount setting and even you know existing discount, it might also be difficult.

 

if you just want to increase 10%, you can use following

 

UPDATE ps_product set price = price * 1.1;

UPDATE ps_product_shop price = price * 1.1;