Shopify cost per item: what it means and how to update it
When a supplier puts a price up by a few percent, nothing in Shopify changes by itself. Your products keep the old cost, your reports keep showing the old margin, and you find out months later. Here's how cost per item works in Shopify, and how to keep it right with a few simple calculations.
What cost per item does in Shopify
- It's set on each product and variant. When a product has a cost, Shopify shows its projected profit and margin next to the price on the product page.
- Margin is calculated as (price − cost) ÷ price × 100. A $50 price with a $30 cost is a 40% margin.
- Profit reports only include products and variants that had a cost recorded at the time they were sold.
- The field is static: Shopify notes that cost per item "contains static data", so reports reflect costs as they were recorded. Nobody updates it for you when a supplier changes price.
So the habit that matters is simple: when you receive a delivery at a new price, update the cost.
Latest cost or average cost?
Say you have 20 candles in stock at a cost of $4.40, and a delivery of 12 arrives at $5.00 each. Which cost should the product have now?
- Latest cost: $5.00. Simple, and it shows what replacing the stock will cost you from now on. It's the safer number for pricing decisions.
- Weighted average: $4.63. (20 × $4.40 + 12 × $5.00) ÷ 32 = $148 ÷ 32 = $4.625. It reflects what the stock on your shelf actually cost, so profit on the next few sales is more accurate.
Either is fine. Pick one and use it consistently. Note that Shopify's own Stocky transition guide says weighted-average costing needs a third-party app, so with the admin alone you'd work out the average yourself. Our comparison of Stocky replacement apps lists apps that do it for you.
Landed cost: put the freight into the cost
If the supplier charges freight, your real cost per unit is higher than the price on the invoice line. A common way to share freight across the lines is by value. For example, one invoice:
| Line | Units | Line total | Share of $10.50 freight | Landed cost per unit |
|---|---|---|---|---|
| Candles at $5.00 | 12 | $60.00 | $6.00 (60 ÷ 105) | $5.50 |
| Mugs at $4.50 | 10 | $45.00 | $4.50 (45 ÷ 105) | $4.95 |
Each line gets a share of the freight in proportion to its value: $60 of $105 is 57%, so candles carry $6.00 of the $10.50, or $0.50 per candle. Shopify's Stocky guide also lists automatic landed-cost allocation as something that needs an app.
To do this for a whole invoice, with duty, insurance or a discount as well, use our free landed cost calculator. It shares each charge by value or by units, gives every line's landed cost per unit, and can turn the result into a Shopify import file that updates only Cost per item.
The price that keeps your margin
Candles sell for $12.00. At a cost of $4.40, the margin is (12 − 4.40) ÷ 12 = 63.3%. The new cost is $5.00. If you keep the price, the margin drops to (12 − 5) ÷ 12 = 58.3%.
To keep the same margin, scale the price by the cost increase: new price = old price × new cost ÷ old cost. Here that's $12.00 × 5.00 ÷ 4.40 = $13.64, and (13.64 − 5) ÷ 13.64 = 63.3% again.
You don't have to pass every increase on. But you should decide, rather than find out from next quarter's report. Price rises are easiest to catch when the delivery arrives: our 10-minute invoice check shows how. For the full routine with VAT-inclusive prices, minimum margins, bulk updates and shelf labels, see how to update Shopify prices when supplier costs rise.
Quick checklist
- Every product and variant you sell has a cost per item.
- Costs are updated when a delivery arrives at a new price.
- You've chosen latest cost or weighted average, and you stick to it.
- Freight and other charges are included where they're significant.
- Prices are reviewed whenever a supplier cost rises.