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.

UnitsCost eachValue
On hand before10$4.00$40.00
Received12$5.00$60.00
After receiving22$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:

OptionWhat it doesWhen 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 costEvery 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 itemOnly 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.
Receiving in Shopify's own purchase orders adds the stock but leaves cost per item as it was, so you'd have to work out and type the new cost yourself.

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.

All guides