fbpx

Bulk update all Prestashop product prices with one click

1 1 1 1 1 Rating 0%

If you only have some products on your boutique, it's not a problem of prices control. But if you have hundreds of products ? I will show you how to change all your product prices in second! ( or you might want to use our new Prestashop Module : Bulk Pricing Updater

First, browse your Prestashop Database on your PhpMyadmin or any MySQl Manager Scripts.

On our Prestashop Database

Prestashop Database - Bulk Pricing Updater

Or your PhpMyadmin

Prestashop Database | PhpMyadmin

Then click on SQL tab to excecute SQL

Execute SQL Prestashop Database

Final, we need to update the price. This is the most important step
If you want to increase all product prices by 12% :
UPDATE ps_product_shop SET price = price*1.12
UPDATE ps_product SET price = price*1.12
Do you see that? The current price plus 12% means [ price x ( 1 + 12% )].

In case you want to update the price and the whole price - for example, increase all product prices by 12% and all wholesale prices by 30%, just run this code

UPDATE ps_product_shop SET price = price*1.12 , wholesale_price = wholesale_price*1.3;
UPDATE ps_product SET price = price*1.12, wholesale_price = wholesale_price*1.3;

If you run above code, it will updates all Prestashop product price on your store. Actually, sometime you only want to update all product prices in a specific category.
Don't worry. I will show you how to bulk update all prestashop product prices in a specific category

UPDATE ps_product_shop SET price = price-.23 WHERE id_category_default=5 
UPDATE ps_product SET price = price-.23 WHERE id_category_default=5
( Decrease all product prices by 23 cents, "id_category_default" is the id of category )

Oh, hang on !!! You should backup your database before do it! This Prestashop tutorial is very dangerous and only for professional programmers. To safely and easily with many options, we recommend using Bulk Pricing Updater to update all product prices just with one click!

PrestaSOO website uses cookies. By continuing to use this website, you are giving consent to cookies being used. More details… X