Is there an sql code i can run to make al lthe products price 10% lower
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?
Zen-Venom Get Bitten
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:
?Code: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?
Alter the calculation part (`products_price` * 0.9) of paulm's query above to `products_price` * 1.1
Development Manager @ JSWeb Ltd
Over 15 years with Zencart
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.
Mary Ellen
I came; I saw; I Zenned
Taking over the world... one website at a time
Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.
Holzheimer
Fan Odyssey
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.
Development Manager @ JSWeb Ltd
Over 15 years with Zencart
Bookmarks