Inventory control in a beverage distribution business is harder than it looks. The product is heavy, often regulated, frequently sold in mixed units, and almost always tracked at batch level. This guide covers the building blocks of a working inventory model: how to think about products, the relationship between bottles and cases, where warehouses and bins fit in, why batches matter, and how to design stock movements that you can actually trust.
Products, units of measure, and case structure
Every product needs a stable SKU, a bottle size, a number of bottles per case, and a default unit of sale. Most distributors transact in cases but report tasting samples, ullage, and breakages in bottles. The system has to handle both, and the conversion between them has to be unambiguous. A 12-bottle case of 750 ml wine is not the same SKU as the same wine in a 6-bottle case, even if the liquid is identical.
Warehouses and bins
A warehouse is a physical location with its own stock balance. Distributors typically have one bonded warehouse, possibly a duty-paid warehouse, and sometimes a third-party logistics location. Each warehouse holds its own stock and its own movements. Within a warehouse, bins (or zones) are an optional but powerful refinement — they let pickers find the right pallet without walking the floor twice.
Designate a primary warehouse for each tenant. New purchase orders, sales orders, and goods receipts should default to that location so the team is not picking it from a dropdown twenty times a day.
Batches and expiry dates
Wine has vintages. Spirits have bottling runs. Beer has best-before-end dates. RTD products have very short shelf lives. Every receipt of stock should be tied to a batch, with a production or vintage reference and, where applicable, an expiry date. Without this, FIFO rotation is impossible and traceability — for recalls, for compliance, and for ageing reports — becomes guesswork.
- Goods received without a batch reference is a future write-off.
- Allocate stock to sales orders at batch level, not just SKU level.
- Surface oldest-batch-first in the picking workflow by default.
Stock movements
Every change in stock should be a typed, auditable movement: goods receipt, sales shipment, internal transfer, stock adjustment, return, write-off, or stocktake correction. Each movement records who did it, when, against which document, and at what unit cost. If a balance ever looks wrong, you should be able to reconstruct how it got that way without a phone call.
Reorder visibility
The point of inventory control is not just to know what you have — it is to know what to buy next. A reorder view should combine current stock, allocated stock, in-transit stock from open purchase orders, recent run-rate, and supplier lead time. For imported wine and spirits, where lead times are measured in weeks or months and freight is booked in containers, the cost of running out is high and the cost of carrying is also high. Visibility is what lets buyers make that trade-off well.