Globally decrease price by 5%

[coucho]

Will this SQL code work if I change the 1.35 to 0.95 to decrease price by 5%?

UPDATE products SET products_price = products_price * 1.35;

[kuroi]

Provided you are not using a database prefix, yes, that should work. Remember to back up your database first, just in case.

[Steven300]

Personally, I can't see anything wrong with it. I think it's quite a clever little statement. Make sure to do a full db backup beforehand, and pls let me know the results.. I might use this someday.

[coucho]

Credit has to be given to Ajeh for the Sql.

[DrByte]

That will only handle "products", not any pricing factors related to attributes.