How to update Shopify prices when supplier costs rise
A supplier's invoice arrives and three lines cost more than last time. Nothing in Shopify changes by itself: the old cost stays on the product, the shelf price stays the same, and the margin quietly shrinks until someone notices at the end of the quarter. This guide is the routine that catches those rises when the delivery arrives, works out the right new price, and gets it into Shopify and onto the shelf without redoing the whole catalogue.
It works with a spreadsheet. There's a free repricing sheet further down that does the maths for you.
The short version
- Put every invoice line into the same terms as your cost in Shopify: per unit, without VAT.
- Compare it with the cost per item you have now, and only look at lines that moved.
- For those, work out the margin at the new cost, using your price without VAT.
- Raise the price only where the margin falls below your minimum, and round it to a normal price ending.
- Update cost and price in Shopify in one pass, then check sale prices and other markets.
- Print new labels only for the items you changed.
Step 1: Put every invoice line in the same terms as Shopify
Most "price rises" that turn out to be nothing, and most real ones that slip through, come from comparing numbers that aren't in the same terms. Fix three things before you compare anything:
- Cases vs units. If the supplier prices a case of 6 dog leads at £54.00 and your cost in Shopify is per lead, the number to compare is £54.00 ÷ 6 = £9.00. Write each item's pack size down once, so nobody works it out from scratch every delivery.
- VAT. Some invoices show prices with VAT, some without, and some show both. If you're VAT-registered, you reclaim the VAT you pay, so keep your cost per item without VAT and compare without VAT. A rope toy invoiced at £3.60 including 20% VAT costs you £3.60 ÷ 1.2 = £3.00. If you're not VAT-registered, the VAT is part of what the item really costs you, so use the full amount.
- Supplier codes. Many invoices use the supplier's own product code, not your SKU. Keep their code against each variant, for example in a metafield, so lines match without guesswork, and don't make it the first barcode if your tills scan that. Our guide to matching supplier codes to your Shopify SKUs shows how to set it up.
Shopify's own help describes cost per item for resold products as the price you paid the manufacturer, excluding taxes, shipping, or other costs. If you add a share of freight to your costs (landed cost), do the same here; our cost per item guide shows how.
Step 2: Look only at what moved
With a lot of suppliers you can't think hard about every line of every invoice, and you don't need to. Most lines on a delivery cost the same as last time. Compare each line's new unit cost with the cost per item in Shopify now, and only look closer when it moved by more than a small threshold. Around 2% works: it ignores a penny of rounding but catches real rises.
| Item | Invoice | New cost per unit (no VAT) | Cost in Shopify now | Change |
|---|---|---|---|---|
| Dog lead, red, M | £54.00 per case of 6 | £9.00 | £8.40 | +7.1% |
| Steel bowl, large | £4.80 each | £4.80 | £4.80 | 0% |
| Rope toy | £3.60 each incl. VAT | £3.00 | £2.85 | +5.3% |
Two lines moved, so two lines need a decision. The bowl needs nothing.
Do this when the delivery arrives, before the stock goes out. It sits naturally next to checking the quantities on the invoice; our 10-minute invoice check covers that part.
Step 3: Work out the margin at the new cost, without VAT
Margin is (price − cost) ÷ price, which is how Shopify calculates it. The trap is the price you put in. If your shelf prices include VAT, as UK and EU customers expect, the VAT part of the price isn't yours, so take it off first:
- The dog lead sells for £17.99 including 20% VAT. Without VAT that's £17.99 ÷ 1.2 = £14.99.
- Margin at the new cost: (14.99 − 9.00) ÷ 14.99 = 40.0%.
- If you forget the VAT and use £17.99, you get (17.99 − 9.00) ÷ 17.99 = 50.0%, and the lead looks fine when it isn't.
Shopify won't do this one for you: when a product is taxed and your store's prices include tax, the product page doesn't show profit and margin at all, because the profit depends on the tax rate of where you sell. So in a VAT-inclusive store, the sheet is where you see the margin.
Margin isn't markup. A 45% markup on a £9.00 cost gives £13.05, which is only a 31% margin. If your rule of thumb is "cost plus 45%", you're working to a markup; the formulas here are for margin. Pick one and use it everywhere.
Step 4: Raise prices to a minimum margin, not every penny
Repricing every item every time a cost moves means constant shelf-label changes. A calmer rule: set a minimum margin for each kind of product, and only raise a price when the new cost pushes the item below it. Food and fast-moving basics usually run thinner margins than accessories, so the minimum differs by category.
When an item does fall below its minimum, the price that gets you back to it is:
new price = new cost ÷ (1 − minimum margin), then add VAT back if your prices include it.
- Dog lead, minimum 45%: £9.00 ÷ 0.55 = £16.36 without VAT, × 1.2 = £19.64. Round up to your usual ending: £19.99, which is a 46.0% margin.
- Rope toy: at £7.99 (£6.66 without VAT) the margin is (6.66 − 3.00) ÷ 6.66 = about 55%, still above 45%. Keep the price, but still update the cost to £3.00, so your reports and the next comparison use the right number.
Always round up to the price ending you use (.49 and .99, say): rounding down can put you back under the minimum. If you'd rather keep each item's margin exactly where it was, scale the price instead: old price × new cost ÷ old cost, as in our cost per item guide.
When a cost falls, update the cost per item, but treat the price as a separate decision. Many shops keep the price and enjoy the margin back.
Free repricing sheet
Download the free repricing sheet (Excel). Type the invoice price, what it covers (each or a case of 12), whether it includes VAT, your current cost and selling price, and your minimum margin. It works out the cost per unit, flags what moved, shows the margin without VAT, says RAISE or keep, and gives a rounded new price. The three examples above are in it. It opens in Excel, Google Sheets and Numbers.
Step 5: Update cost and price in Shopify in one pass
Update the cost per item on every line that moved, and the price on the ones you decided to raise, at the same time, so the two never drift apart.
For a handful of items, use the bulk editor. In Products, tick the products and click Bulk edit. Use Columns to add Price, Compare-at price and Cost per item, so you can see and change all three on one screen. Each row is a variant, so a lead in three sizes shows as three rows.
For a long list, use a CSV import. Export the products, change only the price and cost cells, and import the file with Overwrite products with matching handles ticked. Three rules from Shopify's import guide matter here:
- A blank cell overwrites a value with blank. If a column is in your file, every cell in it is applied, empty or not. Delete whole columns you're not changing instead of leaving them empty; columns that aren't in the file are left as they are.
- Variant columns need the option columns. Shopify gives the example that if your file has SKUs but not Option1 name and Option1 value, the variant option is deleted. Keep the URL handle, Title and option columns exactly as exported.
- Headers must match exactly, including capital letters. Don't retype them; keep the exported header row.
Shopify's help doesn't spell out what happens to variants of a product that you leave out of an overwrite import, so keep every row of any product you change, and only edit the cells you mean to. Try the file on one product first and check it in the admin before importing the rest.
If the new costs arrive as a supplier price list, our free supplier price list tool builds this file for you: it matches each line to your variants by SKU or barcode, shows what went up, can keep each product's margin, and writes only Cost per item and Price, following the rules above.
Step 6: Check sale prices and other markets
- Items on sale. The compare-at price is the "was" price, and Shopify only shows a sale when the compare-at price is higher than the price. If you raise the price of something on sale, check the compare-at price too, or the sale can stop showing, or show a "was" price that's now wrong. Running a Black Friday sale? See how to put your prices back afterwards.
- Other markets. If you sell abroad with Markets, prices set by a percentage adjustment follow your base price, but a fixed price for a market is its own number and needs changing too. In Markets › Catalogs you can export a catalog as CSV; the export only includes products with fixed prices, which makes it a handy list of what to check.
Step 7: Print labels only for what changed
The repricing list is also your label list. With Shopify's Retail Barcode Labels app you select the products, pick a label template that shows the price, and enter how many labels to print for each variant: enough for the units on the shelf. Two things to know from Shopify's help: the app has no CSV upload, so you pick each variant and quantity by hand, and you can't print from Shopify POS, only from the admin on a computer or the Shopify app.
If you have more than one shop and they sell at the same Shopify price, one price change reaches every till at once. Send the same short list to each shop as the note of which shelf labels to swap, so nobody has to remember.
The weekly routine
- As each delivery arrives: convert lines to cost per unit without VAT, and note anything that moved by 2% or more.
- Once a week: put the moved lines in the sheet, check them against your minimum margins, and decide.
- Update cost per item for every moved line, and price for the ones you raise, in one bulk edit or import.
- Check compare-at prices and any fixed market prices on the items you changed.
- Print labels for that list only, and send it to each shop.