Please see the attached Excel file for reference.
The first 4 sheets are updated prices and quantity discounts for my products.
For each product, I need two things:
1: Update the base price of the product on the "Products" sheet, if needed.
2: Create the corresponding quantity discounts on the "Discounts" sheet, which is done by subtracting the discount price from the base price and entering the difference, along with the other necessary fields.
As an example, I've updated the price and created the discounts for the first two products (111-0014 and 111-0015) from the first sheet ("TUF Caps").
Ignore/skip all products with the price listed as “Call”
Rows 13600 to 14972 on the "Discounts" sheet contain values (discountautoid numbers 12599 to 14217) that cannot be changed.
"discountautoid" and "syncid" are sequential
"discounttype" is always "Per Unit"
"taxable_discountaftertax" is always "0"
"couponusage" is always "Unlimited"
There are around 3500 products, with up to 6 discounts each, so I understand this will take awhile.
Please ask any questions you may have, or let me know if something needs clarification.