Bulk update all Prestashop product prices with one click
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
Or your PhpMyadmin
Then click on SQL tab to excecute SQL
Final, we need to update the price. This is the most important step
If you want to increase all product prices by 12% :
Do you see that? The current price plus 12% means [ price x ( 1 + 12% )].
UPDATE ps_product_shop SET price = price*1.12
UPDATE ps_product SET price = price*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
( Decrease all product prices by 23 cents, "id_category_default" is the id of 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
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!
The founder of the Owaci, a fast-growing ecommerce company, main developer of PrestaSOO team. Subscribe to receive his articles to show you how to manage, develop your Prestashop website.