How to update cost per item when you receive stock in Shopify
Shopify uses each product's cost per item for profit and margin reports. If a supplier raises the price and that field isn't updated, every report after that overstates your margin. The right moment to update it is when the delivery is received.
Why the average, not the latest price
The units already on your shelf were bought at the old price. Replacing the cost with the new price makes them look more expensive than they were; keeping the old cost makes the new units look cheaper. A weighted average values every unit at what you actually paid.
| Units | Cost each | Value | |
|---|---|---|---|
| On hand before | 10 | $4.00 | $40.00 |
| Received | 12 | $5.00 | $60.00 |
| After receiving | 22 | $4.55 | $100.00 |
$100.00 ÷ 22 units = $4.545…, rounded to $4.55.
Choose how cost per item changes
When you receive a purchase order in Backroom, Cost per item in Shopify has three options:
| Option | What it does | When to use it |
|---|---|---|
| Average with stock on hand (recommended) | Weighted average of the units you had and the units you just received. | Almost always. |
| Replace with this order's cost | Every unit takes the cost from this purchase order. | When you had no stock, or the old cost was wrong anyway. |
| Don't change cost per item | Only quantities change. | When you manage costs somewhere else. |
- If you had no stock, or less than zero, the new cost is simply this order's cost.
- Units received without a unit cost don't move the average.
- Each purchase order shows every product's cost before and after each delivery, so you can check what changed.
Try it without touching your store
On Backroom's home page, Try a sample delivery runs this exact example with a made-up product. Nothing changes in your store.