Forums / Setting Up Specials and SaleMaker / I don't want discounted attributes

I don't want discounted attributes

Locked

Started by besheer on 26 May 2006, 12:55 PM · Views: 3,041

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
26 May 2006, 12:55 PM
#1
besheer avatar

besheer

New Zenner

Join Date:
Nov 2004
Posts:
69
Plugin Contributions:
0

I don't want discounted attributes

I have about 600 products and I use shipping as an attribute. I just realized that when I put a product on special, it discounts its attributes (including shipping). I obviously don't want that. I noticed that for every product/attribute combination, I can turn off the attribute being discounted. But how can I turn this off for all of them without having to go through several thousand attributes manually?

26 May 2006, 1:06 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: I don't want discounted attributes

You could just change the field attributes_discounted in the products_attributes if you know that you want to change all attributes ... set this to

If you only want to change some attributes then you need to find the options_id and options_values_id associated with the attribute as well ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

26 May 2006, 1:25 PM
#3
besheer avatar

besheer

New Zenner

Join Date:
Nov 2004
Posts:
69
Plugin Contributions:
0

Re: I don't want discounted attributes

Yes, I would like to change them all so that attributes are never discounted. I would really appreciate if you could give me the whole command. I'm not good at any programming/code.

27 May 2006, 4:15 PM
#4
ajeh avatar

ajeh

Oba-san

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

Re: I don't want discounted attributes

To set the discount to OFF on ALL Attributes you can use the following command:

UPDATE products_attributes SET attributes_discounted=0;

NOTE: BACKUP before attempting this change ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!