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.

[CnTGifts]

ok thanks, how can i ad 10% on to the price

[Ryk]

Are you serious?

Alter the calculation part (`products_price` * 0.9) of paulm's query above to `products_price` * 1.1

[afo]

Are you serious?

Alter the calculation part (`products_price` * 0.9) of paulm's query above to `products_price` * 1.1

Actually, no. It'll work if the prices haven't been discounted that way first, but it won't put them back where they were originally.

If the product was originally $100 and was discounted 10%, the result (100 * 0.9) is $90. If the $90 is multiplied by 1.1, it'll be $99, not $100.

[Ryk]

That wasn't the question afo - it was "how can I add 10% to the price" with no mention of prior discount.

Regardless - the principle is the same; CnTGifts needs to work out the formula to apply for whatever s/he requires to do.