[solved] Mass wholesale_price SQL update

[Piotr Kaczor]

Hello

 

I do import as .csv 2000 product's list to my shop with Pre-tax retail price set for each product.

Because in that file was not specified Pre-tax wholesale price Prestashop set it to 0.00 (as predicted).

Now I want to set Pre-tax wholesale price to 90% of Pre-tax retail price so I run simple MySQL statement:

UPDATE `product` SET `wholesale_price` = ROUND(`price` * 0.9, 2);

In database everything run and looks OK, but in Back Office of my shop Pre-tax wholesale price still is 0.00.

Do You know any other method to do this? Or maybe I should Update some more tables in MySQL?

 

Thanks for any help or advice.

 

Hello

 

I do import as .csv 2000 product's list to my shop with Pre-tax retail price set for each product.

Because in that file was not specified Pre-tax wholesale price Prestashop set it to 0.00 (as predicted).

Now I want to set Pre-tax wholesale price to 90% of Pre-tax retail price so I run simple MySQL statement:

UPDATE `product` SET `wholesale_price` = ROUND(`price` * 0.9, 2);

In database everything run and looks OK, but in Back Office of my shop Pre-tax wholesale price still is 0.00.

Do You know any other method to do this? Or maybe I should Update some more tables in MySQL?

 

Thanks for any help or advice.

[Dh42]

Are you using 1.5? If you are and only have one shop (not running multi shop) try you query on the ps_product_shop table.

[Piotr Kaczor]

Yes I run Prestashop 1.5.4 and got Mulitshop option On. Thanks for the advice, I update product_shop table, and now everything work perfect and save a lot of manual work.

Thanks for Your help.

[Dh42]

No problem, happy selling.

[vekia]

i marked this topic as solved :-)

[elektrojo]

HI, I need to decrease prices by a percent, 
how could I use sql for prestashop 1.6

Edited March 4, 2017 by elektrojo (see edit history)