Change all products prices at once by SQL command

[kamrava]

HI,

 

I'm using Prestashop 1.6.0.14

 

I tried to change all products prices by these SQL commands  :

UPDATE ps_product_shop SET price = price*0.1;
UPDATE ps_product SET price = price*0.1;

My goal is to change prices like :

 

1,000,000

 

To :

 

100,000

 

The SQL command ran successfully! But I don't see any changes!

 

Prices is not changed 

 

Any helps would be appreciated.

Edited May 5, 2016 by kamrava (see edit history)

[tuk66]

Do you use any specific prices? What about cache?

[kamrava]

What about cache?

 

I cleared cache in Advanced Parameters > Performance and then Clear Cache. But nothing changed! ( I also cleared browser caches by Ctrl + F5)

 

Do you use any specific prices? 

 

The default Irans currency is Rial (IRR) in PS.

 

I need to change Rial to Toman. ( Toman is also an Iran unofficial currency)

 

10 Rials = 1 Toman

 

So I need to change all prices to Toman. ( Rial price * 0.1 = Toman price) 

Edited May 5, 2016 by kamrava (see edit history)

[tuk66]

I see, but your approach looks good, so I'm trying to find the reason why the prices don't change.

[kamrava]

Any ideas?

[kamrava]

There is no way to do a such thing? Really? 

[musicmaster]

As Tuk66 said, what you did was the right thing. And if it didn't work for you the problem is somewhere in the details - that only you know.

 

The logical thing to do after such a command would be to look with phpmyadmin to see whether the database fields were really changed.

 

If you want you can also try Prestools. It is a free and easy way to mass update prices, a few hundred at a time.

[Prestashopconector]

Any attributes on your products ?? 

 

check ps_product_attribute and ps_product_attribute_shop tables and as tuk66 ps_specifc_price. 

 

if you are not using neither attributes and specific prices, truncate all listed tables above, including ps_product_attribute_combination 

 

or update price column in this table to 0.

 

Hope it works.