Winery Inventory Management: From Crush to Case
Winery inventory management for bulk wine, barrels and cased goods. Track vintage and lot, blend by batch, transfer between cellar and tasting room, count offline.
On this page
- Why winery inventory is different: bulk liquid, not boxes on a shelf
- Tracking wine through crush, tank and barrel by vintage and lot
- Bottling as a production run: turning bulk wine and dry goods into cased wine
- Blending lots and keeping batch traceability intact
- Multi-location transfers: cellar, barrel room, warehouse and tasting room
- Counting barrels offline when the cellar has no signal
- Managing angel's share, racking loss and bottling shrinkage
- Reorder points for corks, capsules, labels and cartons
Winery inventory management looks nothing like counting boxes on a shelf, and any system that treats it that way falls apart by the second racking. Your core asset is a volume of bulk liquid that changes state, location, and even its legal tax class over 18 to 24 months before it ever becomes a countable case. A ton of fruit becomes must, then wine in tank, then wine in barrel, then bottles in a carton — and through all of it you have to know exactly how much of which vintage-lot is where. This guide walks the whole crush-to-case flow and shows where good inventory practice keeps your cellar records and your compliance records as one and the same.
Why winery inventory is different: bulk liquid, not boxes on a shelf
Retail inventory is discrete: you have 40 units, you sell one, you have 39. A winery's inventory is a continuous volume that shrinks and moves constantly. Grapes arrive weighed in tons and measured for sugar in Brix. Reds are crushed with their skins, whites are pressed, and the juice becomes must fermenting in stainless tanks. From there the same wine lives in gallons and liters for a year or two of barrel aging before it finally converts into cases and bottles.
The practical consequence is that your unit of measure changes at every stage, and a real system has to convert cleanly without ever dropping the lot identity. The rough conversions every cellar hand knows by heart:
| Stage / unit | Approx. yield |
|---|---|
| 1 ton of grapes | ~150 gal / ~2 barrels |
| 1 standard barrel (barrique) | ~59-60 gal / 225 L |
| 1 barrel in cases | ~25 cases (~300 bottles) |
| 1 case (12 × 750 mL) | 9 L / 2.42 gal |
| 1 ton in finished goods | ~50-60 cases |
Inventory that starts in tons, passes through gallons, and lands in cases needs to hold those conversions and, critically, keep the vintage-lot attached the entire way.
Tracking wine through crush, tank and barrel by vintage and lot
Every wine you make carries an identity: vintage (harvest year), varietal, vineyard or appellation, and a lot number. That identity is the spine of the whole operation, because a single lot rarely stays in one place. It gets split across several tanks and dozens of barrels, then later recombined. If your records can't follow a lot as it fragments and merges, you lose traceability precisely when you need it most.
Through aging you are also constantly moving wine. Racking siphons clear wine off the lees into a clean vessel, leaving sediment behind. Monthly topping refills the ullage — the headspace evaporation opens up in each barrel. Every one of those movements changes a volume in a specific vessel, and the TTB expects you to have recorded it.
Bonded wineries file the TTB Form 5120.17 Report of Wine Premises Operations, which accounts for every liquid movement, gain, and loss. Your inventory records and your compliance records are the same records — so recording volumes and transfers precisely as they happen is not busywork, it is the filing.
Treating each vintage-lot as its own tracked batch is what makes this survivable. The batch travels with the wine from tank to barrel to bottle, so the question "how much of the 2024 Estate Cabernet, lot 12, is in the barrel room?" always has an answer.
Bottling as a production run: turning bulk wine and dry goods into cased wine
Here is the moment where winery inventory clicks into place. A bottling run is a textbook bill of materials: a finished, labeled case is assembled from bulk wine measured in gallons plus a stack of dry goods. If you've never mapped it out formally, a bill of materials is simply the recipe of components that go into one finished unit. For a case of wine that recipe is:
- Bulk wine — ~2.42 gallons (9 L) drawn from a specific tank or barrel lot
- 12 glass bottles
- 12 corks or screwcaps
- 12 foil capsules
- 12 front + 12 back labels
- 1 shipping carton with dividers
The trouble with doing this on a spreadsheet is that a bottling run touches a dozen inventory lines at once. Draw down the wrong barrel's gallons, forget to decrement the capsule count, miscount finished cases — and your numbers drift the same day you made them. This is exactly the failure a production step is built to prevent. When the winemaker records a bottling run in Shelvr, it deducts the bulk gallons and every packaging component and creates the finished cased-goods SKU in one step, so bulk wine, dry goods, and case inventory all move together.
The bottling line is where a winery's inventory finally becomes countable — and where a single recorded run should update the bulk tank, the dry-goods shelf, and the case warehouse all at once.
Blending lots and keeping batch traceability intact
Blending is the other great test of a tracking system. Combining lot A and lot B into a cuvée is itself a production event — you consume two batches and create a new one. If traceability breaks here, it breaks everywhere, because a finished blend must still trace back to its component lots for recall readiness.
Recording a blend as a production run keeps that chain intact: the new lot is created as its own batch, and its parentage points back to the lots that went in. Handled this way, batch identity survives the very operation that would otherwise erase it.
Wine tax class is set by ABV thresholds, and a wine at 15.8% versus 16.2% can land in different classes. Because blending shifts ABV, a blend can change a lot's tax class. Record the resulting lot's ABV and volume precisely — the blend that improves the wine can also move it across a tax line.
Multi-location transfers: cellar, barrel room, warehouse and tasting room
A working winery is a cluster of distinct premises: crush pad, tank hall, barrel room, case-goods warehouse, a separate tasting room, DTC and e-commerce fulfillment, and often offsite bonded storage. Wine and cased goods move between them all day. Barrels transfer from cellar to bottling line; finished cases go from warehouse to tasting room and to shipping.
Without multi-location tracking, a case that left the warehouse for the tasting room simply vanishes from your counts. Treating each premises as its own stock location — and logging transfers between them — keeps every location's numbers honest and, again, feeds the movement records the TTB expects. If you sell online, Shopify sync keeps DTC case counts aligned with what's actually on the warehouse floor.
Counting barrels offline when the cellar has no signal
Barrel rooms and underground cellars are thick-walled, and almost none of them have wifi or cell service. That makes offline counting a genuine operational requirement, not a nice-to-have. A tool that needs a connection to record a count is useless exactly where your most valuable inventory sits.
Shelvr is offline-first: you can scan a barrel's barcode with your phone camera, count, and adjust stock with no signal at all, and everything syncs across devices once you're back above ground. A cellar count done at 6 a.m. in a dead zone isn't lost or delayed — it's simply there when you reconnect.
Barcode-label each barrel and tank. Scanning a vessel to log its lot, volume, and a topping or racking event is far faster and less error-prone than writing on a clipboard and keying it in later — and it works in the cellar whether or not you have a signal.
Managing angel's share, racking loss and bottling shrinkage
Wine disappears, legally and inevitably, and you must account for all of it. The angel's share — evaporation through porous oak — typically runs 2 to 4% of volume per year, and up to roughly 10% in a hot, dry cellar, which can mean around 14% lost over three years of aging. On top of that:
- Lees / racking loss — volume left behind with the sediment every time you rack.
- Bottling-line loss — spillage, foaming, and rejected fills at the filler.
- Tasting-room shrink — open bottles for pours, breakage, samples, and staff comps.
The discipline is to reconcile expected volume against actual and log the difference as waste. Tracking those losses matters beyond good bookkeeping: under 27 CFR 24.266, inventory losses that exceed allowable limits require a claim to the TTB. Waste tracking against each lot's expected volume gives you both the reconciliation and the paper trail.
Reorder points for corks, capsules, labels and cartons
You can nail the wine and still miss the bottling window because the capsules didn't arrive. Dry goods — bottles, corks, capsules, labels, cartons — have real lead times, and running short of any one of them stalls a scheduled run. Front and back labels are especially risky because they're often print-to-order and SKU-specific, so you can't borrow from another wine.
Set a reorder point on every dry-goods line so low-stock alerts fire before you hit zero: reorder point = (avg daily usage × lead time) + safety stock. Because a bottling run deducts these components automatically through the BOM, your on-hand counts stay accurate enough for those alerts and for demand planning against your bottling calendar to actually be trustworthy.
From crush to case, the pattern is the same: record each real event — a racking, a blend, a transfer, a bottling run — once, precisely, and let the finished counts fall out of it. That's the whole job. You can start free and move to Pro when you're ready to run your full crush-to-case flow on it.
Run your inventory in one app
Track stock, orders, and production across web, iOS, and Android — free to start.