Shopify inventory reports explained: the nine default reports, and which one shows stock value at cost
Shopify has nine default inventory reports in Analytics > Reports (Category: Inventory): Month-end inventory snapshot, Month-end inventory value, Inventory sold daily by product, Products by percentage sold, ABC product analysis, Products by sell-through rate, Inventory remaining per product, Inventory adjustment changes and Inventory adjustments by count. Only Month-end inventory value gives stock value at cost, and it multiplies each variant's on-hand units by today's single Cost per item. Since 1 October 2026 the reports count On hand units, not Available.
How to open Shopify's inventory reports
- From your Shopify admin, go to Analytics > Reports.
- Click the Category filter and choose Inventory.
- Open a report and set the date range. For a month-end figure, end the range on the last day of the month.
The nine default inventory reports
| Report | What it answers | How it's worked out | Uses cost? |
|---|---|---|---|
| Month-end inventory snapshot | How many units of each variant at month end | On hand quantity at the end of the last day | No |
| Month-end inventory value | What the stock is worth at month end | Cost per item × ending On hand quantity, totalled | Yes: Cost per item |
| Inventory sold daily by product | Average units sold per day | Quantity sold ÷ days in the period | No |
| Products by percentage sold | Share of the starting stock that sold | Quantity sold ÷ starting quantity | No |
| ABC product analysis | Which variants earn 80%, 15% and 5% of revenue | Revenue over the last 28 days, fixed | Shows a Total value (cost) column |
| Products by sell-through rate | How much of the stock sold | Sold ÷ (sold + still in stock); about two days behind | No |
| Inventory remaining per product | How many days of stock are left | Ending quantity ÷ average sold per day over 28 days | No |
| Inventory adjustment changes | Every change to stock in the period | Manual, app, transfer and fulfillment adjustments | No |
| Inventory adjustments by count | How many adjustments, by staff, location, app or reason | Counts adjustments, not units | No |
Rules behind the numbers
- On hand since 1 October 2026. Reports now count On hand units (Available, Committed and Unavailable), not Available. Incoming units on a transfer are left out. Data before 1 October 2026 keeps the Available count.
- History from 1 October 2023. Inventory metrics have no data before that date.
- Three years of variants. The month-end snapshot and value reports include variants adjusted or ordered in the last three years.
- Deleted things. Deleted locations don't show. A product deleted after 14 January 2026 shows no inventory data past its deletion date.
- 1,000 rows on screen. Totals cover every row; export the report to see them all (Shopify Help: Reports).
- Negative quantities come from overselling a tracked variant, or from untracked variants that were fulfilled.
Which report shows stock value at cost, and its limit
Month-end inventory value is the only default report that values stock: Cost per item × ending On hand quantity. Cost per item is one number per variant, so every unit is valued at today's cost, whatever you paid for it. Take 100 units in stock: 40 bought at $6.00 and 60 bought later at $7.50.
| Cost per item in Shopify | Unit cost used | Month-end inventory value | Difference |
|---|---|---|---|
| Left at the first price | $6.00 | $600.00 | −$90.00 |
| Changed to the last price | $7.50 | $750.00 | +$60.00 |
| Weighted average of what you paid | $6.90 | $690.00 | 0 |
(40 × $6.00 + 60 × $7.50) ÷ 100 = $6.90. The report is right only when Cost per item holds the average of what you paid for the units still in stock. Because Cost per item is static, Shopify's own suggestions for figures that change are another business system such as an accounting system, a reporting app, or working it out by hand (Shopify Help: Profit reports).
Custom inventory reports
Beyond the nine, Shopify lets you build your own from Analytics > Reports. One worth having after a delivery is Shopify's reconciliation of ordered against received quantities:
- Go to Analytics > Reports and click Create custom report.
- Choose the Inventory transfers data source.
- Add the dimensions transfer_name, inventory_origin_name, destination_name, transfer_status and product_variant_sku.
- Add the metrics ordered_quantity and received_quantity.
To check a supplier invoice, export it to CSV and multiply received quantities by the invoice prices (Shopify Help).
How True COGS fits
- Records the price paid on every received purchase order or transfer, and keeps each price with its date.
- Writes the weighted average, or FIFO cost on paid plans, to Cost per item, so Month-end inventory value uses what you paid.
- Its inventory value page shows Shopify's figure for the same stock next to the True COGS figure, and the difference.
Related guides
Questions merchants ask
What inventory reports are available in Shopify?
Nine default reports: Month-end inventory snapshot, Month-end inventory value, Inventory sold daily by product, Products by percentage sold, ABC product analysis, Products by sell-through rate, Inventory remaining per product, Inventory adjustment changes and Inventory adjustments by count. You can also build custom reports.
How do I get an inventory report in Shopify?
Go to Analytics > Reports, click the Category filter and choose Inventory. Open a report and set the date range.
Which Shopify report shows the value of my inventory?
Month-end inventory value. It multiplies each variant's Cost per item by its On hand quantity at the end of the period and totals the rows.
Why is my Shopify inventory value higher since October 2026?
From October 1, 2026, inventory reports measure On hand quantity instead of Available. On hand includes Committed and Unavailable units, so values can be higher. Data before that date still uses Available.
How far back do Shopify inventory reports go?
Inventory-based metrics go back to October 1, 2023. The month-end reports include variants adjusted or ordered in the last three years.
Why does a report show only 1,000 rows?
Shopify reports display at most 1,000 rows so they load quickly. Totals still cover all rows. Export the report to see every row.
Why do I see negative inventory in a Shopify report?
Ending quantity can be negative when you oversell a tracked variant, or when inventory tracking is off and orders are fulfilled.
Try True COGS free. True COGS is an inventory costing app for Shopify by Nexus Logic Systems. It records the price you paid on every delivery (a received purchase order or a transfer), with its share of freight and duty on paid plans, keeps every price with its date, and writes your moving weighted average cost, or FIFO cost on a paid plan, to Shopify's Cost per item. It is free for up to 25 variants with a cost on record; paid plans start at $29 a month or $290 a year.
Install from the App Store