We often set up price groups where multiple discounts apply to the same item, and we want those discounts to always calculate against the base price instead of a cascading calculation of discount percentages. For example, a 10% discount on an individual item, plus a 10% volume discount for the whole basket being over $2000. We would want that to be 20% off that individual sale item and 10% off everything else. Currently, it's 10% off the individual item, which is rolled up into the basket subtotal, then the basket discount is 10% off that discounted subtotal, which gives less than a 20% discount to the customer for that sale item.
There are more complicated scenarios as well, where we have discount price tiers for specific customers in the mix, who then might also qualify for a volume discount, then maybe also a sale on a specific item. We'd want something like a 10% + 15% + 5% for a 30% discount, but it's impossible to do that accurately when we have multiple price groups, volume discount tiers, and sale items, where we want to set a total cap of 30% for the combined savings across them. We end up setting these things up knowing the website will be wrong and just let our ERP correct it for the final invoice.
Also, I recognize that I'm saying the website is "wrong" when I just mean it's not the behavior we want, but it doesn't match our master invoice on the ERP side. I also mean "wrong" in the sense that we're marketing a sale as being "up to 30% off" some items when the various discounts stack, but it can't really do that because it's a discount off a discount off a discount.
The fix would be a checkbox on the price group setup to calculate that price group's discount against the original base price instead of always using the price remaining after the previous discount calculation.
There are more complicated scenarios as well, where we have discount price tiers for specific customers in the mix, who then might also qualify for a volume discount, then maybe also a sale on a specific item. We'd want something like a 10% + 15% + 5% for a 30% discount, but it's impossible to do that accurately when we have multiple price groups, volume discount tiers, and sale items, where we want to set a total cap of 30% for the combined savings across them. We end up setting these things up knowing the website will be wrong and just let our ERP correct it for the final invoice.
Also, I recognize that I'm saying the website is "wrong" when I just mean it's not the behavior we want, but it doesn't match our master invoice on the ERP side. I also mean "wrong" in the sense that we're marketing a sale as being "up to 30% off" some items when the various discounts stack, but it can't really do that because it's a discount off a discount off a discount.
The fix would be a checkbox on the price group setup to calculate that price group's discount against the original base price instead of always using the price remaining after the previous discount calculation.