No. Shopify keeps one cost per item on each variant and uses the value recorded at the time of sale for its profit reports. It doesn't keep cost layers, so it can't do first in, first out (FIFO), where the oldest stock's cost goes out first. When costs change, Shopify's cost is whatever was last typed in, applied to every unit sold from then on. For a business whose costs rarely move, that's fine. For a maker whose ingredient prices change batch to batch, margins drift away from reality.
The short version
- Shopify: one cost per item per variant, typed in, used at the time of sale.
- FIFO: each batch keeps its own cost; the oldest units are costed out first.
- Weighted average: a running average cost across everything on hand.
- Shopify's month-end inventory value is cost per item × on hand, not FIFO.
- Your accountant may use FIFO for the books even if Shopify doesn't.
Three methods, one example
A made-up jam maker, Punaluʻu Preserves, makes guava jam in two batches:
| Batch | Jars | Cost per jar |
|---|---|---|
| September | 100 | $2.60 |
| October (guava price up) | 100 | $3.20 |
In October it sells 120 jars at $9.
| Method | Cost of the 120 sold | Profit |
|---|---|---|
| FIFO (100 at $2.60, 20 at $3.20) | $324.00 | $756.00 |
| Weighted average ($2.90 each) | $348.00 | $732.00 |
| Shopify, cost updated to $3.20 on Oct 1 | $384.00 | $696.00 |
| Shopify, cost never updated ($2.60) | $312.00 | $768.00 |
The 80 jars left are worth $256 under FIFO (all October jars) and $208 in Shopify if the cost was never updated.
Why it matters
- Pricing. If Shopify still says $2.60, the margin looks healthier than the next batch will be.
- Year-end. Closing stock valued at an old cost understates or overstates the year's profit.
- Comparing batches. Without batch costs, you can't see that October's jam cost 23% more.
FIFO on the shelf, not just in the books
FIFO is also a packing habit: ship the oldest jars first. Costing and shelving are separate questions, but they go together well, because if September's jars leave first, FIFO costing describes what really happened. Put new batches behind old ones, label shelves by batch date, and check at each count that nothing from two batches ago is still at the back.
What you can do in Shopify
- Update cost per item when a new batch costs noticeably more or less.
- Use the average of what's on hand if batches overlap for a long time.
- Keep a sheet of batch costs for your accountant, who can value stock by FIFO at year end.
Shopify cost per item and Shopify inventory value report cover where Shopify uses the number.
Where this stops working
Updating one number by hand can't represent two batches on the shelf at different costs, and it's the step most people forget. For a maker, the cost of each batch also depends on which lot of each ingredient it used, which Shopify never sees. FEFO vs FIFO covers the related question of which stock to sell first, and Shopify production cost covers working out a batch's cost.
How TaroStack does it
TaroStack for Shopify runs inside your Shopify admin and keeps FIFO cost layers (or moving average, if you prefer), including freight and other landed costs. Each batch is costed from the ingredient lots it actually used, so September's and October's jam carry their own costs, and stock value by site and month follows them. Free for 14 days.
