Price List and Discount Management for Wholesalers
Price list and discount management has a more direct effect on a wholesaler's profit than almost anything else, yet it is often the most scattered process in the business. List prices sit in one spreadsheet, customer discounts in another, reps keep their own 'special prices', and the sales manager has made a few promises by phone. The result is that the same product is sold to the same customer at different prices on different days, and nobody can say where the margin went. This guide shows how to structure pricing and keep it under control.
The Layers of a Pricing Structure
A healthy pricing structure is built in layers, each with a clear owner:
- List price: the base selling price for each item. Usually owned by product management or the sales director.
- Customer group price or discount: different prices or rates for dealers, wholesalers, key accounts and trade customers.
- Customer-specific terms: fixed prices or extra discounts on selected items for contract customers.
- Promotions: time-limited discounts by item or category.
- Order-level discount: an extra discount a rep can give within their authority.
Write down the order in which these layers apply. Does a promotion stack on top of the customer discount, or does the customer simply get whichever is better? If the rule is unclear, everyone applies their own interpretation.
Tiered Discounts and Volume Pricing
Lower prices for larger quantities are normal in wholesale. When setting up tiered pricing:
- Define tiers clearly in units, cartons, pallets or order value
- Decide whether a tier applies to the order line or the order total
- Calculate the real effect of stacked discounts; 10 percent plus 5 percent is 14.5 percent, not 15
- Align tier thresholds with logistic units; if you do not want to break cartons, set tiers per carton
The formula for stacked discounts is net price = list price × (1 - d1) × (1 - d2). For a list price of 100 with 10 percent and 5 percent discounts, the net price is 100 × 0.90 × 0.95 = 85.50.
Pricing in Foreign Currency
Businesses that import or export often price in a foreign currency. You then need to decide which exchange rate to use, on which date the rate is fixed (order, dispatch or invoice date), how long quotes and price lists remain valid, and which open orders are repriced when rates move. Sharing these rules with customers in writing reduces disputes later. Ask your accountant how this should be treated in your books.
Managing Promotions
Well-designed promotions clear stock, launch new products or capture seasonal demand; uncontrolled ones turn into permanent price cuts. Define every promotion in writing: which items or categories, which customer groups, start and end dates, discount type (percentage, amount or free goods), whether it stacks with other discounts, and the target outcome. Prices should revert automatically when the promotion ends, and results should be compared against the target. For free-goods offers such as 'buy 10, get 1 free', include the cost of the free units in your margin calculation.
Approval Authority and Margin Protection
When discount authority is unlimited, margin erodes quietly. Set up a simple authority matrix:
- Sales rep: extra discount up to a set level
- Area or sales manager: up to a higher level
- Managing director or finance: anything above that
- Selling below cost: always a separate approval
Defining authority in terms of gross margin rather than discount percentage is more robust, because the same discount can be harmless on a high-margin item and loss-making on a low-margin one.
Metrics for Price List and Discount Management
- Average realised discount by item, customer and rep
- The 'price waterfall' from list price to realised price, broken down by layer
- Number of discount requests going to approval, and how long approvals take
- Volume and gross margin during promotions compared with normal periods
- Prices that have not been updated despite cost increases
Common Mistakes
- Publishing a new price list while old versions stay in circulation
- Giving customer-specific prices with no end date
- Not reviewing prices when costs change
- Tracking promotion end dates by hand
- Not recording why a discount was given
When Is It Time for Software?
With a small range and a few customer groups, a well-organised pricing spreadsheet may be enough. Once you have thousands of items, many customer-specific prices, reps ordering in the field and dealers ordering through a B2B portal, prices must be calculated from a single source. Otherwise the ERP, the sales app, the web shop and quote files each show a different price.
Most ERPs support price lists and discount rules. When your rules become complex, when approvals are needed, or when the same price must appear correctly across several channels at once, a pricing and approval module running alongside the ERP gives you more flexibility.
Codefacture builds pricing, discount approval and B2B ordering solutions for wholesale, distribution, automotive parts and packaging businesses, integrated with the ERP you already run. Get in touch to review your pricing structure with us.
Price List and Discount Management FAQ
What is the first step in price list and discount management?
Bring every price list, customer discount and special price into one place, then write down a clear rule for which layer applies in which order.
How are stacked discounts calculated?
Discounts multiply rather than add. 10 percent followed by 5 percent means multiplying the list price by 0.90 and then 0.95, a total reduction of 14.5 percent.
Should discount authority be based on percentage or margin?
Margin is more robust. The same discount percentage leads to very different profit outcomes on items with different margins.
When should the exchange rate be fixed for foreign currency prices?
It is a commercial decision; order, dispatch or invoice date are all used. What matters is that the rule is clear and shared with customers in writing. Ask your accountant about the accounting treatment.
Should customer-specific prices have an end date?
Yes. Special prices with no end date can quietly turn into losses when costs change. An end date forces a review.
How do I keep prices consistent across the ERP, B2B portal and sales app?
Calculate prices from one source and feed every channel from it. Separate price tables in each channel make inconsistencies inevitable.