How to Track Supplier Price Creep on Shopify Before It Eats Your Margin

Why Shopify's Cost Field Hides This From You

Shopify stores exactly one number per variant: Cost per item. Every time you post a new receiving at a new cost, that field overwrites whatever was there before. Shopify doesn't keep the number it's replacing. Ask "what did we pay for this in March" and the honest answer is "check your email," assuming the invoice is still findable and you're willing to dig for it.

A spreadsheet tracker is the usual fallback, and it works for about a month. Someone adds a column per invoice, then a busy week hits, three invoices get posted straight to Shopify with no time to update the sheet, and the record quietly stops being trustworthy. Matching an invoice line back to the right spreadsheet row is manual work on top of manual work — the exact kind of task that gets skipped first when things get busy.

Weighted-average cost makes this worse in a specific way, even though it's the right number for margin reporting. WAC blends your new cost with what you already had on the shelf, so it moves slower than the supplier's actual invoice price. By the time your blended average visibly rises, the supplier has already been charging the higher price for several deliveries. The smoothing that makes WAC correct for accounting is exactly what makes it a poor early-warning signal.

What Creep Actually Costs, in Real Numbers

Take a pet supply SKU — a bag of food from one distributor, ordered roughly monthly. Across five invoices from February to August, the printed unit cost moves like this: $18.40, $18.55, $18.70, $18.85, $19.10. Every single increase is under 1.5%. None of them, on their own, is worth a phone call.

Retail price sat at $27.99 the entire time, because nothing told anyone to touch it. At $18.40, that's 34.3% margin. At $19.10, it's 31.7% — not a catastrophe, but on a SKU moving 400 units a month, that gap is roughly $280 of margin per month absorbed with nobody deciding to give it up. Spread that pattern across the 30–40 SKUs you buy regularly from the same distributor over two quarters, and it stops being a rounding error.

What It Actually Takes to Catch It

Not a forecast, not a market-price feed — just a record you don't have to build by hand:

How This Looks in Smart Restock

Every invoice you post through Smart Restock already records the unit cost on that line. Cost Trends is the view built on top of that history: search a SKU or product name, and you get a chart of its unit cost at every invoice you've posted for it, plotted over time, with the invoice number on hover so a jump always has a source. You can narrow the date range, or filter down to a single supplier when more than one vendor ships the same barcode-matched item.

Below the chart, the same data sits as a table — old cost, new cost, and the weighted-average that resulted — so you can see the raw price your supplier is actually charging separately from the blended number that drives your margin reports. That distinction matters: the chart line is what showed up on the invoice; the weighted-average column is what's quietly absorbing it into your books.

To be precise about what this is and isn't: it's a record of invoices you've already posted, not a prediction of where a supplier's price is headed next. It won't tell you a price increase is coming, and it doesn't watch the market for you. What it does is remove the one obstacle that usually stops merchants from checking — you don't need a spreadsheet, and you don't need to remember to update one.

What It Isn't

Worth being direct about the boundaries, because it's easy to assume more than what's actually there. Cost Trends is a page you check, not a notification that finds you — nothing pings you when a SKU's cost moves, the way a low-stock digest does when a threshold is crossed. It only knows about costs from invoices you've posted through Smart Restock, so a SKU you've never received through the app has no history yet, and it starts building from your very first invoice, not retroactively from years ago. And it looks backward: it's a ledger of what you were charged, not a forecast of what you'll be charged next quarter. If your business needs demand forecasting or reorder planning on top of that, that's a different tool's job — Smart Restock's role here is making sure the receiving-side data actually exists to look at, accurately, without extra work.

Turning the Chart Into a Decision

Seeing the trend is the easy part. Three things merchants actually do with it:

Where This Bites Hardest

Price creep isn't unique to any one vertical, but it's sharpest wherever invoices arrive often and margins are already thin: auto parts and hardware distributors that fold quantity-break and core-charge pricing into the unit cost quietly; liquor, grocery, and convenience suppliers whose price lists update monthly while retail shelf tags don't; pet supply distributors running promo pricing that reverts to a slightly higher baseline without anyone announcing it. In all three, the invoices keep arriving on schedule — the only thing missing is a place to compare them.

It also matters more the more suppliers you juggle. A store buying from one distributor can usually keep the recent price movement in their head. A store receiving from four or five distributors a week, across hundreds of overlapping SKUs, cannot — and that's precisely the merchant this is built for: someone who is already parsing every invoice through Smart Restock for the SKU matching and cost posting, and gets the cost history as a side effect of work they were doing anyway.

See your own cost history, not a demo file

Run your next few supplier invoices through Smart Restock and Cost Trends builds itself from your actual receiving history — no spreadsheet to set up first.

Stop finding out about price increases by accident

Every invoice you post builds the cost history behind it — no spreadsheet, nothing to remember to update.