How Liquor Stores Update Shopify Inventory from Distributor Invoices

Why Liquor Retail Is a Harder Receiving Problem Than It Looks

You buy from licensed distributors, not open-market suppliers. Under the three-tier system used across most of the US (and comparable control-board or licensee structures in Canada), retailers can only purchase from licensed wholesale distributors — not directly from producers. That means most stores are juggling invoices from a handful of distributors (often regional wine/spirits wholesalers, a separate beer distributor, and sometimes a specialty importer), each running its own order cycle and its own invoice format, rather than one central supplier feed.

The same label is multiple SKUs. A single product from a producer can show up on your shelf — and your invoice — as a 750ml bottle, a 1.75L handle, a 4-pack, and a case, each with its own UPC. Map a 750ml sale against the 1.75L SKU once and your online stock count is wrong for both sizes until someone catches it.

Case breaks complicate the math. Distributors sell and invoice by the case, but you sell by the bottle. A case of 12 landing at $186 needs to become 12 units at roughly $15.50 each in your system — and if three bottles from that case were already opened for a tasting or damaged in transit, your true received count isn't 12. Get the case-to-unit math wrong across a few dozen invoices a year and your cost-per-bottle — and your margin reporting — drifts steadily away from reality.

Compliance means the paper trail matters. Most jurisdictions require licensed retailers to keep documented invoices and delivery receipts for regulatory audit, and to be able to show exactly what was purchased from which licensed distributor. That's a good reason to actually keep clean, matched invoice records in the first place, not just a spreadsheet of end totals.

Option 1: Manual Entry in Shopify Admin

Open the invoice, open Products in Shopify admin, find each bottle size and count, adjust the quantity, repeat for every line — then do it again for the next distributor's invoice that landed the same week.

Where it works: a small store with one or two distributor deliveries a week and a short SKU list.

Where it breaks: once you're carrying a real wine and spirits selection — a few hundred SKUs across sizes — case-break math done by hand is where mistakes creep in. It's easy to update the case count and forget to convert it to bottles, or to update the 750ml row while the 1.75L row of the same label sits untouched. Cost-per-item almost never gets updated by hand, so your Shopify profit reports quietly stop reflecting what you actually paid.

Option 2: CSV Import

Some distributors offer a portal export or EDI feed you can reformat into Shopify's bulk inventory CSV template. Where that exists, it's a real step up from typing line by line.

Where it works: distributors with a genuine self-serve export, and stores comfortable mapping spreadsheet columns.

Option 3: Parse the Invoice Itself

The other approach: skip reformatting entirely and have software read the actual distributor invoice — PDF, scan, CSV, or Excel — and turn it directly into a Shopify update. This is what Smart Restock does, and it's built for exactly the mess a liquor invoice usually is:

Every processed invoice from a given distributor also builds a per-supplier template, so the next invoice from that same wholesaler parses on the spot — useful when you're seeing the same three or four distributors' invoice layouts week after week.

Where it breaks: a genuinely illegible delivery-ticket scan still needs a human to confirm quantities, and the first invoice from a brand-new distributor takes a few minutes of setup. And this is invoice-to-inventory automation, not a compliance or age-verification tool — it doesn't touch licensing, purchase limits, or who you're allowed to buy from.

Watch It in Action

Here's a two-minute look at uploading a supplier invoice and letting Smart Restock extract the line items automatically:

A Realistic Weekly Workflow for a Liquor Store

Here's what receiving looks like with invoice parsing in place, for a store ordering from three distributors weekly:

Total time: 10–15 minutes per invoice, versus the better part of an afternoon spent reconciling case counts to bottle counts by hand across three deliveries — with a clean, matched invoice record kept for every purchase, which is exactly what a compliance audit asks for.

What This Means for Your Margins

Liquor margins are already thin and size-dependent — a 1.75L doesn't carry the same margin as a 750ml of the same label, and distributor pricing shifts more often than most retailers track by hand. When every invoice updates weighted-average cost per size variant, your Shopify profit reports actually mean something: you can see which sizes and which distributors are earning their shelf space, and catch a quiet price increase from a wholesaler the same week it happens instead of a quarter later. For more on getting weighted-average cost right in the first place, see our practical guide to Shopify weighted-average cost .

Try it on your next delivery

Run your next real distributor invoice — case breaks, mixed sizes, and all — through it during the 14-day free trial.

Built for case breaks and mixed bottle sizes

Stop reconciling case counts by hand

Join liquor and wine retailers who turn a stack of distributor invoices into a ten-minute review.