Product Specials/Sales Turn all of at once?

[DannyVarley]

Hi Guys,

I was reading on the 'How to speed up your site' post and the following:

"4 (b). In your individual attribute assignments, set "Apply Discounts Used by Product Special/Sale: No" (assuming that the options don't have cost associated with them); this will heavily reduce your parse times."

All my attributes have this turned on, I was wondering if anyone knows a fast way to turn this off for all attributes at once as I have thousands of attributes. Any help would be greatly appreciated.

Thanks,
Daniel

[DannyVarley]

Hi Guys,

I found the answer to my own question after doing a little bit of googling

If you want ALL Attributes to have the discount turned OFF you could run this command, after backing up your database:

UPDATE products_attributes SET attributes_discounted = 0;

Via Ajeh, (Many thanks)

[mc12345678]

Thanks for answering your question publicly!