Custom Quantity Pricing (custom quantity price breaks per product) with Customer Groups

For an average e-commerce site, managing product quantity prices for different customer groups can be a daunting task. If you look at it closely, for 10 different prices and three different customer groups, that translate to 30 different values to update. Now multiply that by 200 Quantity Price Breaks with Customer Groupsdifferent products, that is 6000 different values to update.  Even with the aid of easy populate, it does not in any way reduce the volume of work that needs to be done.

In the spirit of continuous improvement, there is a solution that eliminates this problem. What the solution does is provide the capability to set the base price and end price for each product. By using a linear relationship, graphical illustration of price point calculationthe individual prices for each price points can be calculated on the fly there by eliminating manual intervention.

Another advantage of this method is the ability to use it with easy populate effectively. There is no need to replicate rows to accommodate the different customer groups.