Totally Zenned
- Join Date:
- Sep 2008
- Location:
- Cleethorpes
- Posts:
- 1,230
- Plugin Contributions:
- 3
Mark Down Attributes
Hi I have this which I use to mark up products in the zen database.
UPDATE products_attributes SET options_values_price = options_values_price * 1.20;
Can somebody tell what I would do to mark prices down 20%
Would it be
UPDATE products_attributes SET options_values_price = options_values_price * 1.00;
UPDATE products_attributes SET options_values_price = options_values_price * 0.80;
UPDATE products_attributes SET options_values_price = options_values_price * 0.20;