Skip to content

Does Shopify Use FIFO for Inventory Cost?

Shopify uses one cost per item, not FIFO. What that means for your margins when costs change, how FIFO works, and how makers get batch-accurate costs.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed October 27, 2026 · 3 min read

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.

Questions people also ask

What inventory valuation method does Shopify use?

A single cost per item per variant, recorded at the time of sale. It isn't FIFO, LIFO or weighted average.

Can I use FIFO with Shopify?

Not inside Shopify's reports. An inventory app or your accounting system can keep FIFO costs beside it.

Does Shopify update cost per item automatically?

No. Purchase orders remember supplier costs for the next order, but cost per item changes only when you edit it.

Is FIFO required for taxes?

Not necessarily. Several methods are allowed. Ask your accountant which one your business uses.

Sources

  1. Shopify Help Center: Profit reports · read October 27, 2026
  2. Shopify Help Center: Inventory reports · read October 27, 2026

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

TaroStack for Shopify

Free for 14 days.