The short answer
Growth strains items, suppliers, locations, channels and delivery promises. A system that scales has:
- One version of item and stock data across purchasing, sales, warehouse and finance.
- Stock movements as transactions, not hand adjustments.
- Purchasing by rules (reorder levels, lead times, demand), not memory.
- Traceability by batch or serial where required.
- Integration with online stores, marketplaces, logistics providers, carriers and suppliers.
ERP, warehouse system or both: the foundations matter more.
Warning signs your current setup will not scale
- Stock counts disagree with the system, and the fix is a manual adjustment
- Salespeople check with the warehouse before promising a delivery date
- Reordering depends on one or two people who "just know"
- The same item has different codes or descriptions in different systems
- Landed costs (freight, duties, clearing agent charges, exchange-rate differences) are estimated at year-end, not applied to stock
- A new location means copying a spreadsheet
- Tracing a supplier quality problem or recall to customers would take days
If several apply, more volume will amplify the problems.
The foundations
Item master data
Codes, units, suppliers, lead times, reorder levels, tax classes, tracking; one owner, approval for new items.
Inventory control
Every receipt, transfer, pick, shipment, return and write-off as a transaction; regular cycle counts.
Replenishment
Reorder levels per item and location, reviewed on schedule; the system drafts requests or orders.
Traceability
Batch tracking set up before go-live for batch or expiry products: food, pharmaceuticals, chemicals, consumables.
Landed cost
Freight, duties, levies, clearing and port charges applied to the cost of stock received.
Integration
Decide which system owns stock availability and orders; connect the others to it.
Duplicate and inconsistent items are the most common reason supply chain systems disappoint; manual re-keying between channels is where overselling and missed shipments start. Stock in a Lagos or Port Harcourt depot, or on a truck between them, is still stock the system should know about.
More on each foundation
- Item data also covers units of measure and conversions, supplier part numbers, weights and dimensions, and whether an item is tracked by batch or serial.
- Inventory: cycle counts mean counting a portion of stock regularly instead of one annual count; investigate differences rather than simply correcting them. Set up multiple warehouses or bins as locations, with transfers recorded when stock moves.
- Purchasing: track supplier lead times and on-time delivery so planning numbers reflect reality.
- Traceability: in ERPNext, for example, a batch can carry an expiry date and shows as expired once that date passes (ERPNext documentation).
- Channels typically added with growth: an online store, a marketplace, a third-party warehouse, electronic data interchange (EDI) with large customers.
Measures worth tracking
A few measures, defined consistently, show whether the supply chain is keeping up:
| Measure | What it tells you |
|---|---|
| Stock accuracy (count vs system) | Whether transactions are being recorded properly |
| Fill rate | How often you ship what the customer ordered, when promised |
| Supplier on-time delivery | Whether planning lead times are realistic |
| Inventory turns or days on hand | Whether stock levels match demand |
| Short-dated or obsolete stock value | How much is at risk of write-off |
Agree definitions before building reports, and track the trend rather than a single month.
A worked example
Hypothetical example. A regional distributor of cleaning and hygiene supplies has grown from one warehouse to three and has added an online store. Stock is held in accounting software with a separate spreadsheet per warehouse, and the online store's stock levels are updated by hand each morning.
A practical plan: clean and de-duplicate the item list; set up the three warehouses as locations in one ERP; record transfers between them; add reorder levels for the fastest-moving items first; turn on batch tracking for products with expiry dates; and connect the online store so that orders flow in and stock levels flow out automatically. Each step can go live separately.
Readiness checklist
Data
- Is there one item list, with an owner and an approval step for new items?
- Are units of measure and conversions consistent across purchasing and sales?
- Which items need batch, expiry or serial tracking?
Process
- Is every stock movement recorded as a transaction?
- Do we cycle count, and do we investigate differences?
- Are reorder levels and lead times set, and reviewed on a schedule?
Cost
- Are freight, duties and clearing charges applied to stock when it is received?
Channels and partners
- Which system owns stock availability?
- Which channels, warehouses or partners need automatic integration?
Growth
- What happens in the system when we add a warehouse, supplier or channel?
Limitations
Software cannot fix a process nobody follows: if receipts are not recorded when goods arrive, or anyone can create items, a new system produces the same inaccurate results faster. Very high-volume or highly automated warehouses may also need a dedicated warehouse management system alongside the ERP.
Next step
Prometheus ERP, our ERP built on ERPNext, includes inventory control across multiple warehouses, batch management, landed cost vouchers, multi-currency accounting and automated replenishment. See also our work with distribution and retail and transportation and logistics organisations, and our guide to preparing data for an ERP migration.
Sources and further reading
Product capabilities and guidance change. These are the primary sources this article relies on, checked on the review date above.
- Batch, ERPNext documentation (Frappe)
- Nigeria Customs Service, Nigeria Customs Service
- NAFDAC, National Agency for Food and Drug Administration and Control
This article is general information, not legal, accounting or security advice for your specific situation. Examples are hypothetical unless stated otherwise.