My company used to use the quantity discount table to give customers a 'case quantity discount'. The problem is that it is impossible to update this pricing information for a group of items at once. Each time prices change, each item must be updated manually. Therefore, I have decided to do away with the case discounts entirely. So now I am faced with the daunting task of going through item by item and selecting 'There is no discount theme for this item' for each and every one.
I am fairly certain it is possible to set this option for all items at once using a query but I have no idea how to do this. Can anyone tell me how or point me in the right direction?