Massive price change using PHPmyadmin 1.6.24

[Juan Rios1]

I have about 500 products, and am going to be changing around 300 prices. 

I want to use PHPmyadmin to do so.

I went into the table "ps_products" and see the column 'price' which represents the price before taxes. I tried to change it, but no change is reflected on teh actual store. 

I tried to change the same products price using the backoffice and it does update the 'price' column on the database.

 

Is there a column I'm missing? 

I'm using prestashop version 1.6.24

Any help is appreciated! Thanks!

[Juan Rios1]

Anyone?, please

[Juan Rios1]

I'm going to be changing around 300 product prices on my prestashop and realized it will be much easier to do it via phpmyadmin,

This is an example of the command I used to one product.

UPDATE `ps_product` SET `price` = '866.379000' WHERE `ps_product`.`id_product` = 498;

It was succesfull, but the price on the actual product didn't change. I have to use the backoffice for it to change.

Am I missing a table which I must update or something?

I'm using prestashop 1.6.24

Thanks!

[Juan Rios1]

I'm going to be changing around 300 product prices on my prestashop and realized it will be much easier to do it via phpmyadmin,

This is an example of the command I used to one product.

UPDATE `ps_product` SET `price` = '866.379000' WHERE `ps_product`.`id_product` = 498;

It was succesfull, but the price on the actual product didn't change. I have to use the backoffice for it to change.

Am I missing a table which I must update or something?

I'm using prestashop 1.6.24

Thanks!

[idnovate.com]

Check ps_product_shop table.

[Juan Rios1]

4 minutes ago, idnovate.com said:

Check ps_product_shop table.

Ok, thanks! 

I tried to change an individual one and it worked! THank you so muhc!

But should I also change the value on the table ps_product?

[Guest]

SQL:

UPDATE ps_product t1, ps_product_shop t2 SET 
t1.price = '866.379000',
t2.price = t1.price

WHERE t2.id_product = t1.id_product and t1.id_product = '498'

Edited May 14, 2020 by Guest (see edit history)

[Guest]

PHP:

$product = new Product(498);
$product->price = '866.379000';
$product->update();

 

[musicmaster]

You need to change the ps_product_shop table too.

Most likely it will easier to use Prestools for this. It is free.

[Guest]

Rather than taking a cannon on a fly, it is better to write a script and import a csv file.
Just two columns, one with the product id and the other with the price.