Wholesale Inventory Management: A Guide for Sri Lankan Distributors
Wholesale is not retail with bigger quantities. Trade pricing, credit control and warehouse stock need a different setup — here is what that looks like.
Related product page: /wholesale-management-system
Why retail software breaks in a wholesale business
Most POS systems assume one price per product, one customer per sale, payment at the time of sale and stock in one place. A distributor breaks all four assumptions before lunchtime.
Your price depends on who is buying. Your customer is another shop, not a walk-in. Payment arrives in 30 days if you are lucky. And your stock sits in a godown that is not the room you are standing in.
Trying to run that on retail software produces the classic wholesale mess: prices overridden manually on every invoice, credit tracked in a book, and a stock figure nobody quite believes.
Get trade pricing out of people's heads
The most common failure in Sri Lankan wholesale is that the correct price for each dealer lives in the owner's memory. It works until the owner is away, and then it costs money in both directions — undercharging a big dealer, overcharging a small one who then buys elsewhere.
Structure it instead:
- Define price tiers — say Dealer A, Dealer B, Retail — and assign every customer to one.
- Set quantity break pricing where it applies: one rate for 10 units, another for 100.
- Allow line-level overrides, but log who made them. An override you can see is a negotiation; an override you cannot see is a leak.
- Review the override report monthly. It will tell you which prices are wrong and which staff need a conversation.
Credit control is inventory management
Wholesalers rarely fail because of stock. They fail because of receivables — goods gone out, money not come back, and no cash left to buy the next consignment.
Three controls prevent most of it. A credit limit per customer, enforced at the point of invoicing rather than discovered later. Settlements recorded against specific invoices rather than as a running balance, so ageing stays real. And an ageing report the owner actually reads weekly, not a total that hides a six-month-old balance inside a healthy-looking number.
The uncomfortable rule: if a dealer is over their limit, the goods do not leave. Every wholesaler who has been burned learned that rule the expensive way.
Separate the warehouse from the counter
If you also sell retail — and most Sri Lankan distributors do — the stock in your shop and the stock in your godown must be tracked as different locations, not as one pooled number.
Otherwise a rep quotes 200 units to a dealer based on a total that includes 80 units sitting on the shop floor, already half-promised to walk-in customers.
Location-level stock with transfers between them costs a little discipline and removes an entire category of embarrassing phone calls.
The order-to-cash cycle, written down
Wholesale businesses that run well have a cycle everyone follows. It usually looks like this:
- Order taken — dealer selected, trade price loads automatically.
- Credit checked — limit and outstanding balance validated before confirmation.
- Stock allocated — from a specific warehouse, not a global total.
- Invoice issued — with the correct price, terms and due date.
- Dispatch — own vehicle or courier, with the reference linked to the invoice.
- Settlement — recorded against that invoice, not the customer's general balance.
- Follow-up — driven by an ageing report, not by memory.
Numbers a distributor should see every week
Most wholesalers track sales and stock. The ones that grow track four more:
- Receivables ageing — how much is 0–30, 30–60, 60–90 and over 90 days.
- Margin by product line — volume hides thin margins remarkably well.
- Dead stock — items with no movement in 90 days, valued at cost.
- Customer concentration — what share of sales comes from your top three dealers.
What to fix first
If you are starting from books and spreadsheets, do not try to fix everything in one month. Fix pricing first — it is the quickest win and it removes daily friction. Then credit limits, because that is where the cash risk is. Then warehouse separation. Reporting last, because reports on bad data are worse than no reports.
SellMate's wholesale management system covers dealer price tiers, credit limits with ageing, multi-warehouse stock and bulk order entry, and runs alongside a retail counter on the same stock pool if you sell both ways.
