10% Off Prices

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

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

change the actual price

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 :-)

Like this:

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

Backup first!

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

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

Are you serious? :shocking:

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

Ryk:

Are you serious? :shocking:

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.

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.

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.

The "add 10%" question was unclear since it followed the "10% off" question. As I said before, they'll work independently, but not in tandem.

If it's a temporary price reduction, I'd elect to go the 10% discount route available in ZC. That way, if you want to go back, you just remove it and no data has actually been touched.