Case of 12, Sold as Singles: Getting True Per-Unit Cost Into Shopify

The Two Ways Case Packs Go Wrong

There are only two mistakes available here, and stores make both — often on the same invoice.

Mistake one: the quantity is short by a factor of 12. You received 2 cases, so you type 2. Shopify now thinks you have 2 bottles when 24 are on the shelf. This one is loud — you notice within a week, when the site shows sold out and the stockroom clearly isn't.

Mistake two: the cost is high by a factor of 12. The invoice line reads $54.00, so $54.00 goes into Shopify's Cost per item field. The real per-bottle cost is $4.50. This one is silent. Shopify's cost-per-item field doesn't validate anything, doesn't compare against your retail price, and doesn't warn you. It just accepts $54.00 and reports negative margin on every sale of that bottle from then on.

Mistake two is the expensive one. Every profit report, every "which products actually make money" analysis, and every margin-based pricing decision downstream inherits the error. If you use those reports to decide what to reorder or what to discount, you're making real decisions on invented numbers.

Why "Just Divide by 12" Doesn't Solve It

Everyone's first instinct is that this is a one-line calculation, and for one line it is. The problem is that a real invoice isn't one line.

Which is how you end up with the spreadsheet: a helper column, a pack-size column, a divide formula, and a copy of the invoice open beside it. It works, and it costs you an hour a week per supplier, and it introduces its own errors.

Setting Units Per Pack Once, at the Line Level

The approach that holds up is to tell the software the pack size and let it do both halves of the math — quantity and cost — from the same number. In Smart Restock , every invoice line has a Units per pack field. Set it to 12 on the merlot line and the app reads the invoice cost as the price of one case, splits it across the twelve bottles inside, and posts twelve units of stock per case received. Leave it at 1 and nothing changes — the cost you see is the cost that posts.

Two details matter more than they sound like they do:

From there the per-unit cost flows into whichever costing method you've set — weighted average by default, or last cost if that's what your accountant prefers — and posts to Shopify's cost-per-item field along with the inventory update.

When One Invoice Line Is Actually Several Products

The harder cousin of the case-pack problem is the mixed case: one invoice line, one price, several different products inside. A variety pack of dog treats. A mixed twelve of wine. A hardware assortment box.

Dividing by twelve is wrong here, because the twelve items aren't the same item and don't carry the same cost. What you need is to split the line across the actual products it contains, with the line's total cost distributed across them, so each child product gets its own quantity and its own share of the money. Smart Restock handles this as a line split, and the constraint it enforces is the one that matters: the pieces have to add up to what the supplier actually billed. You can't invent cost the invoice never charged.

A related case: invoices that bill an add-on as its own line — an embroidered emblem, a bottle deposit, a service charge tied to specific items — where the add-on will never be a product in your store. Skipping that line throws away real cost you paid. Allocating it onto the lines it belongs to keeps your per-unit cost honest.

What this is not: it isn't landed-cost proration. Smart Restock reads the shipping, freight, and tax totals printed on the invoice, and it handles per-unit duty or excise that's baked into a line total — but it does not spread a separate freight charge across your receipt lines. If your true landed cost depends on prorating a $340 freight line over 47 SKUs, that's still a manual step.

Where This Bites Hardest

Liquor and wine. Case-and-bottle is the default unit of trade, margins are thin and regulated, and three or four distributor invoices a week means the error repeats constantly.

Grocery and convenience. Everything arrives in a shipper, pack counts differ by brand, and single-digit margins mean a per-unit cost that's off by a few cents changes which products look profitable.

Pet supplies. Treats and toys ship in inner packs inside master cases, and 50-page distributor invoices mean hundreds of divisions per delivery.

Hardware and auto parts. Fasteners, fittings, filters and fluids come in boxes of 50 or 100 that get sold individually, and multiple locations multiply the reconciliation work.

How to Check Whether You Already Have This Problem

Ten minutes, and you'll know. Export your products with cost and price columns, then sort by cost descending and look at the top of the list. Any item where cost per item is greater than or close to your retail price is almost certainly a pack price sitting in a unit-price field. Then sort by the ratio of cost to price and look for anything under about 10% — that's the opposite error, a unit price entered where a pack was received, or a pack cost that got divided twice.

Both patterns cluster by supplier, which is the tell: if every mis-costed SKU came from the same distributor, it's a systematic pack-size issue, not scattered typos. Fix the process for that supplier and the whole cluster stops recurring.

Try it on a real case-pack invoice

Upload the next distributor invoice with mixed pack sizes, set units per pack once per line, and see the per-unit cost before anything posts. Plans start at $9.99/month with a 14-day free trial.

Stop dividing case prices by hand

Get per-unit cost right on every receipt, so your Shopify margin reports reflect what you actually paid.