Zen Cart Logo

Mark Down Attributes

Views: 524

Results 1 to 2 of 2
22 Aug 2013, 3:36 PM
#1
nick1973 avatar

nick1973

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;

22 Aug 2013, 4:15 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Mark Down Attributes

Let's see ...

A Product that is 100.00

UPDATE products_attributes SET options_values_price = options_values_price * 1.20;
will change the Product to 120.00

A Product that is 100.00

UPDATE products_attributes SET options_values_price = options_values_price * 1.00;
will change the Product to 100.00 (same price)

A Product that is 100.00

UPDATE products_attributes SET options_values_price = options_values_price * 0.80;
will change the Product to 80.00

A Product that is 120.00

UPDATE products_attributes SET options_values_price = options_values_price * 0.80;
will change the Product to 96.00

A Product that is 100.00

UPDATE products_attributes SET options_values_price = options_values_price * 0.20;
will change the Product to 20.00