We have a quantity based pricing system. The prices for products are based on quantity and are not a specific % discount, the price varies for each product. How can I create a quantity based pricing guidleine so that when my salespeople select a certain quantity of a product, the system will provide the correct price?
Ex. Quantity pricing structure Product x
1-5 : 1000
6-10 : 800
10-20 : 650