The idea is, if the field:
products_discount_type
are all the same, non-zero value, switching the field:
products_discount_type
to 0 will turn OFF the Discount Quanties, without deleting the existing Discount Quantity settings ...
Then, if they were all the same value for:
products_discount_type
such as 1 ... you could then set them all back to 1 when you want them all back on ...
To turn them OFF use:
Code:
UPDATE products SET products_discount_type = 0;
To turn them ON use, if the original value was 1:
Code:
UPDATE products SET products_discount_type = 1;
NOTE: Be sure to make a backup first of your database and this ONLY works if ALL Products use Quantity Discounts of the same kind ... meaning if you see a mixture of 0, 1, 2 or 3 this will NOT work for you ...
NOTE: The update can be run in the Tools ... Install SQL Patches ...
Bookmarks