We have around 40 Parts that are all in a single Product Group. We want to be able to offer “Mix and Match” quantity breaks.
Part A is $103.00 each
If they buy 10, price is $98 each
If they buy 20, price is $95 eah
If they buy 30, price is $93 each
Part B is $106.00 each
If they buy 10, price is $101 each
If they buy 20, price is $98 each
If they buy 30, price is $96 each
This all works fine using Customer Price Lists.
Here’s where my question is. If they buy 5 of Part A and 5 of Part B, they hit a total quantity of 10, so we want the price for Part A to be $98 and the price for Part B to be $101. I’ve seen where you can add discounts on a Product Group, but since the prices are not the same for each part at each quantity break, it doesn’t seem to be our solution. Has anyone else run into this, and how do you handle?