Managing Multiple Price Lists for Customers SA

Why One Price List Is Never Enough

The moment a South African distribution business grows beyond a handful of customers, pricing complexity multiplies. You have the national chain that negotiated a volume discount. You have the cash-and-carry wholesaler on different terms. You have independent retailers paying standard trade prices. You have new customers you're incentivising with an introductory rate for their first three orders.

Managing multiple price lists for customers in South Africa isn't optional for most distributors — it's a commercial reality. The question is whether you're managing that complexity efficiently, or drowning in spreadsheet chaos.

Pricing complexity shouldn't slow your reps down. Start your 14-day free trial and see how customer-specific pricing works in practice — no credit card required.

The Common Price List Tiers in SA Distribution

Most FMCG and general distribution businesses in South Africa operate with some variation of these pricing tiers:

National Account / Key Account Pricing

Your top customers — the ones that account for a disproportionate share of revenue — typically have individually negotiated rates. This might be pricing on specific product lines, volume-based rebates, or agreed quarterly reviews. These rates are contractual and need to be managed carefully, as deviations in either direction create liability.

Companies supplying into retailers like Shoprite/Checkers, Pick n Pay, or SPAR group at a wholesale level will typically have formalised key account pricing documented in trading terms.

Wholesale Distributor Pricing

If you supply to other distributors who then sell on to the trade, their pricing reflects the additional margin layer they need to operate. This tier typically sits well below trade pricing.

Standard Trade Pricing

The default rate for independent retailers, corner shops, petrol forecourt convenience stores, and hospitality customers. This is your most broadly applied price list — the one the majority of reps work with for most of their customer base.

Cash Customer Pricing

Some distributors offer a small discount for customers who pay on collection (effectively cash-and-carry terms), since there's no credit risk or collection cost. This may or may not be a formal separate price list depending on business size.

New Customer Acquisition Pricing

A promotional rate applied to a new customer's first two or three orders as an incentive to switch from a competitor. This needs tight time controls — it should expire automatically after the qualifying orders, not persist indefinitely.

How This Gets Messy in Practice

If you're managing these tiers in Excel, the typical reality looks like this:

• Five (or more) separate spreadsheet files, each named with a date or version number
• Different people in the business maintaining different files
• No reliable way to ensure reps are using the correct file for the correct customer type
• Price updates cascading slowly across files, with some updated and some not
• No audit trail of what price was active when a dispute arises three months later

For a sales team operating across Johannesburg, Pretoria, Durban, and Cape Town simultaneously, the version control problem becomes unmanageable. A rep in Gqeberha has no reliable way to know whether the spreadsheet they downloaded last Tuesday is still current today.

Price List Assignment: Linking the Right List to the Right Customer

The fundamental shift that a proper system enables is price list assignment at the customer account level. Instead of the rep deciding which price list applies to each customer visit, the system knows.

When a customer account is created or updated, it is assigned a price list — Key Account, Trade, Wholesale, or whichever tier applies. From that point on:

• Every order for that customer uses that price list automatically
• The rep sees the correct price without needing to know which tier the customer is on
• If the customer's tier changes (say, they achieve volume thresholds for a better rate), the assignment is updated once and all future orders reflect it

This is the difference between a rep needing to remember "this customer is on key account pricing, that one is on trade" versus the system handling that knowledge invisibly.

Handling Exceptions: The Approval Workflow

Real-world B2B sales involves negotiation. A rep's best customer asks for a rate that isn't on their assigned price list. A manager approves a one-off concession for a large order. These exceptions are normal — the question is whether they're managed or uncontrolled.

A proper price list management system allows:

• Discount requests — rep requests a price below the customer's assigned list, with a percentage threshold requiring manager approval
• One-order exceptions — a special rate applied to a single order without changing the customer's permanent price list assignment
• Approval audit trail — every exception is recorded with who approved it, when, and for how much

This prevents both unauthorised discounting (reps giving away margin without permission) and the chaos of verbal agreements that don't get captured anywhere.

Keep margins intact with built-in approval workflows. Order management lets reps request discounts within limits you define — every exception is tracked. Start your free trial and configure your price tiers today.

Price List Versioning: The Dispute Resolution Safety Net

When a customer disputes an invoice six weeks after the order was placed, you need to be able to answer: what price was active on that date for that customer?

In a spreadsheet environment, this question is often unanswerable. The file has been updated since, old versions may not have been retained, and no one remembers exactly when the change was made.

Version history in a centralised system solves this cleanly. Every price list update is timestamped. Every order records the price that was active at the time it was placed. Dispute resolution becomes a lookup rather than a reconstruction exercise.

Promotional Price Lists: The Time-Bounded Challenge

Supplier-funded promotions, seasonal promotions, and volume-push campaigns all introduce time-limited pricing that applies to specific products, specific customer types, or both. Managing this in spreadsheets typically means:

1. Creating a new "promo" version of the relevant price list
2. Distributing it to reps with the start and end dates noted
3. Hoping reps switch back at the right time
4. Dealing with the aftermath when they don't

A system with time-bounded promotional pricing removes steps 2-4 entirely. The promo rate is active between the configured start and end dates. On day one of the promotion, every eligible customer automatically gets the promo rate. On the day it ends, they revert to their standard rate. No rep intervention required.

Syncing Across the Team in Real Time

The core operational advantage of centralised price list management is that a price change made at head office reaches every rep's device immediately — not when they next check email, not when they print an updated list.

For a business operating in multiple cities across South Africa, this matters enormously. A price change triggered by a supplier increase needs to flow to the rep in Durban and the rep in Polokwane simultaneously. With spreadsheets and email, you're always managing a lag. With a centralised system, there is no lag.

Starting Point: Consolidating Before You Migrate

If you're considering moving from spreadsheets to a centralised pricing system, the first step is consolidation — not migration. Before importing anything:

1. Identify how many distinct price lists you actually operate (you may have more than you think)
2. Reconcile them into a clean, agreed set
3. Audit your customer base and assign each customer to a price list tier
4. Identify any customers on one-off negotiated rates that need individual handling

Only once this groundwork is done does the migration become straightforward. Tools that support spreadsheet import allow you to bring existing price list data in without rebuilding from scratch — but the data needs to be clean first.

The Business Case for Getting This Right

The ROI of proper price list management in South African distribution is measurable in several ways:

• Reduced credit notes — pricing disputes resolved before they become invoice errors
• Faster rep onboarding — new reps don't need to learn which price list to use; the system handles it
• Margin protection — discount approvals prevent unauthorised rate concessions
• Time saved — no more distributing, tracking, and reconciling multiple spreadsheet versions

For a business with 20+ reps and 500+ customers, the operational burden of manual price list management is significant. A centralised system converts that ongoing administrative overhead into a one-time setup effort — and keeps it clean thereafter.

Start your 14-day free trial and see how price list assignment works across your entire customer base.