I don't want discounted attributes

[besheer]

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?

[Ajeh]

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 ...

[besheer]

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.

[Ajeh]

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 ...