Inventory management for Shopify wine and spirits shops

The inventory problems wine and spirits shops run into

• Vintage variation. Each new vintage of a wine is a distinct SKU even if the label looks the same, so sales history from last year's vintage doesn't carry over cleanly.
• Allocated products. Rare bourbons, limited-release Scotch, and cult wines often come in small, unpredictable allocations from distributors, so normal reorder math doesn't apply to them.
• Three-tier distribution rules. In the US, you often can't order direct from a producer. You go through a state-licensed distributor, and each distributor has its own ordering schedule and minimums.
• Bottle size and case pack variants. The same product line can come in 375ml, 750ml, 1L, and 1.75L, each its own variant with its own case pack and velocity.
• Breakage and shelf wear. Glass breaks, labels fade, and capsules get damaged, so physical counts drift from system counts faster than in many other verticals.

Seasonality and demand

Demand peaks hard around the winter holidays, from late November through New Year's Eve, with a smaller bump around Mother's Day, graduation season, and summer rosé/beer-adjacent months. Thanksgiving week alone can rival a slow month elsewhere. Plan your holiday gift sets and premium spirits orders in late summer or early fall, since distributors also get slammed and allocations tighten as the holidays approach. Build in extra safety days for anything you can't reorder quickly once December hits.

Suppliers, lead times and minimums

Most shops order through state or regional distributors who carry multiple brands and typically ship within a week or two for in-stock items, though allocated or specialty items can take much longer with no firm date. Some shops also work directly with wineries or small craft distilleries, where lead times stretch longer and minimum orders are often a set number of cases rather than bottles. Import-heavy shops dealing with overseas producers should expect overseas suppliers often take several weeks longer than domestic ones, especially around holiday shipping congestion.

Worked example

Say you sell a mid-range Cabernet at an average of 3 bottles a day. Your distributor's lead time is 7 days, and you keep 3 safety days for delays, so your reorder point is 3 x (7 + 3) = 30 bottles. You want 14 days of cover on top of the lead time, you currently have 20 bottles on hand and 12 on order, so your order quantity is 3 x (7 + 14) - (20 + 12) = 63 - 32 = 31 bottles. Since this wine ships in a case pack of 12, SteadyShelf rounds that up to 36 bottles, or 3 cases.

Try it with your own numbers in the reorder point calculator, or size your buffer with the safety stock calculator.

A simple system to start this week

1. List every variant separately in Shopify, including bottle size and vintage, so each gets its own forecast.
2. Enter each distributor's typical lead time and case pack size into SteadyShelf.
3. Flag allocated or limited-release items and manage those manually rather than relying on automated reorder dates.
4. Set longer safety days for imported products and for the pre-holiday ordering window.
5. Review the weekly reorder email before the holiday season starts to catch anything that needs a head start.
6. Do a manual shelf check periodically since broken or shrinkage-prone stock won't show up in system counts.

How SteadyShelf fits wine and spirits shops

SteadyShelf handles the forecasting and reorder timing for your regular, repeatable SKUs, drafting POs sized to your distributors' case packs and minimums. It does not track vintage-specific expiry, lot numbers, or shelf condition, so for aging wine or anything with a cork and cellar concern, keep a separate note of what needs to move before it turns. It also won't manage allocation requests or multi-location transfers if you run more than one store location.

$29/month flat, unlimited products and suppliers, 30-day free trial.

SteadyShelf is launching on the Shopify App Store. Join early access to get the install link first.

More: inventory management by store type · inventory glossary · Stocky alternatives

FAQ