What Is Case-Break Inventory?
Most liquor stores stock products by the case — a full case of 12 bottles, a six-pack, or a single bottle sitting alone on the shelf. The problem: the case and the single bottle are the same product, but when you sell one, your inventory count has to change at two levels at once.
That's case-break inventory tracking. Sell one bottle out of a 12-bottle case? The case count drops to 11, and your single-bottle count updates automatically — all in the same system.
Without it, you have two separate counts that don't talk to each other. That's where mistakes start.
The Problem With Manual Tracking
Many independent wine shops still use spreadsheets to track both case-level and single-bottle stock. Here's what goes wrong:
- A bottle sells at the register, but the spreadsheet is only updated at the end of the day — or not at all.
- A case is counted as 12 bottles, but three bottles from that case have already been sold individually.
- Stock reports show you have 7 cases, which looks like enough inventory — but 9 of those bottles have been sold out of one case, leaving the shelf half-empty.
Over time, these gaps add up. Not just wrong numbers — actual lost revenue from overstock you don't realize you have, or stockouts you don't see coming.
How Case-Break Tracking Works
A good system links case-level and bottle-level inventory in real time:
- Every case is tracked as a container with a set number of units.
- When a single bottle sells, the case count automatically updates.
- When a case is received from a supplier, the bottle count increases accordingly.
- Low-stock alerts fire at both the case and bottle level — so you don't miss a reorder because one case looks fine but is half-empty.
It's not an extra feature. It's how retail inventory should work for beverage stores.
Why It Matters for Shrinkage
Shrinkage — the gap between what you bought and what you can account for — is a bigger problem for liquor stores than most people realize. Some of it is theft. More of it is unrecorded breakage, expired product, or simple count errors.
When your case-level and bottle-level counts don't agree, shrinkage hides inside the gap. You think everything is fine because your case count looks right. But the bottles inside the case tell a different story.
Case-break tracking closes that gap. You see exactly what's left — in real time — and you notice when a bottle disappears before it becomes a pattern.
Quick Implementation Tip
Don't try to implement this for your entire catalog at once. Start with your top 5 best-selling SKUs — the wines or spirits that move fastest and represent the most of your revenue. Once those are tracking correctly, expand to your next tier.
That approach keeps the process manageable and lets you see results quickly without overwhelming your staff.
How CellarPoint Handles This
CellarPoint's inventory module was built for beverage retail specifically. Case-level and bottle-level tracking are linked out of the box — not added on as an upgrade.
- Goods received updates both case and bottle counts automatically.
- A single bottle sale adjusts the parent case in real time.
- Low-stock alerts work at both levels.
- The full movement log shows exactly where any discrepancy happened — so audit trails stay clean.
No separate module to buy. No integration to configure. Just how inventory works when the system understands your business from the start.
Need to see it in action? Explore how CellarPoint fits small wine stores.