10% Off Prices

[CnTGifts]

Is there an sql code i can run to make al lthe products price 10% lower

[kobra]

Is this to change the actual price or to offer 10% off all items?

[CnTGifts]

change the actual price

[paulm]

quick updates can do that for you (depends on the amount of products if it really will be a quick update though).

But if I remember well you already use quick updates?

edit: sorry that is not an answer to your question I realize now :-)

[paulm]

Like this:

UPDATE `products` SET `products_price` = `products_price` * 0.9;

?

Backup first!

[paulm]

Forgot to tell: you need to update the sprice sorter too, after the above.