Sale up discount


I’m looking to enable seller to provide discount rates based on the volume of product a buyer is looking to purchase. Ideally they can select the quantity thresholds and the price at each threshold. Any idea how I can make this work?

Check out the links in this post and search through the many examples of database structures to find the ones related to promotions and discounts.