Blog

How to update Shopify prices when supplier costs rise

13 November 2026 · 9 min read · Wren Commerce

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

  1. Put every invoice line into the same terms as your cost in Shopify: per unit, without VAT.
  2. Compare it with the cost per item you have now, and only look at lines that moved.
  3. For those, work out the margin at the new cost, using your price without VAT.
  4. Raise the price only where the margin falls below your minimum, and round it to a normal price ending.
  5. Update cost and price in Shopify in one pass, then check sale prices and other markets.
  6. 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:

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.

ItemInvoiceNew cost per unit (no VAT)Cost in Shopify nowChange
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.800%
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:

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.

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:

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

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