What Is the Inventory on Hand Report?
The Inventory on Hand report lists every product and variant you currently stock, alongside its SKU, vendor, holding location, unit quantity, and the cost value of that stock. It answers one question directly: how many units do I physically have right now, where are they, and what are they worth at cost?
One distinction matters before you read it. "On hand" is the total number of units physically at a location, which includes units committed to open orders and units marked unavailable. It is not the same as "available," the count you can still sell. A product can show a comfortable on-hand figure while very little is actually sellable, so treat this report as your stock-position snapshot rather than a sellable-units view. The Inventory Quantity you see is live, reflecting stock at the moment the report runs rather than a midnight figure.
Merchants reach for this report when they need a single, exportable picture of stock across every warehouse, store, and vendor, usually to drive reorder timing, fulfillment routing, and the cost value of inventory at month-end.
Which Fields Are Included in the Inventory on Hand Report?
These fields let you identify each stocked item, see where it sits, and read how much stock you hold and what it costs.
You can customize the pre-made report by adding, removing, or rearranging columns, or by filtering to a single location or vendor, so the view matches how you review stock.
Important Insights You Can Find in This Report
Which items and vendors hold the most tied-up cash?
Read Inventory Quantity against Inventory Cost, not either one alone. A variant with a modest unit count but a high cost per item can lock up more capital than a bin full of cheap stock. Sort by Inventory Cost to see where your money is sitting, then group by Vendor to check whether a single supplier accounts for an outsized share of that value. If it does, that is both a cash-flow question and a supply-chain concentration risk worth raising with procurement.
Is the same SKU split unevenly across your locations?
Filter to one SKU and compare Inventory Quantity across the Location rows. When most of a fast mover sits in one location but orders tend to ship from another, you pay for it in slower fulfillment or avoidable transfers. This is the read that tells you to rebalance stock before a busy period rather than after customers start waiting.
Which active products are sitting at zero or negative on hand?
Scan Inventory Quantity for zeros and negatives. A negative figure usually means stock was committed or sold before it was received, which points to a receiving or oversell issue to fix in Shopify. Pair each flagged row with its Vendor value and you have the start of a reorder contact list, sorted by who you need to call first.
THE ANALYST'S READ: The Signal Most Merchants Miss
The report's own name is the trap. "On hand" counts every unit physically at a location, which means it includes stock already committed to open orders and stock marked unavailable. So a variant can show a comfortable Inventory Quantity on this report and still keep selling out, because most of those units are already spoken for.
The pattern to watch is a product with a solid on-hand count that keeps hitting stockouts or backorders. When you see it, the gap is almost always committed stock. On this page, read Inventory Quantity as what you physically hold. When you need the sellable figure to size a reorder, add an available-quantity column beside it, or work through the full on-hand vs available decision breakdown in our current inventory guide. On hand tells you what you own. It does not tell you what you can sell.
How Can You Automate the Inventory on Hand Report?
Open the pre-made Inventory on Hand report in Report Pundit. The columns are already set, so you can save it as is, or open Custom Reports and add the fields yourself if you want a different starting point. Apply any filter you need, such as a single location or vendor, then save.
From there, schedule it to run on its own, daily, weekly, or monthly, and have it emailed straight to you, your team, your VA, or your accountant on that schedule. You can export it as Excel, CSV, or PDF, or push it to Google Sheets or Google Drive so the numbers arrive already prepared.
Frequently Asked Questions
What is the Inventory on Hand report in Shopify?
It lists the current unit count of every product and variant you stock, broken out by SKU, vendor, and location, with the cost value of that stock. Merchants use it to decide what to reorder, route fulfillment, and value inventory.
Does the Inventory Quantity in this report show on-hand or available stock?
It shows on-hand: the total physical units at a location, including units committed to orders and units set aside as unavailable. Available, the sellable count, is a separate field you can add as its own column. If you are deciding reorder quantities, base them on available rather than on hand, since committed units are already promised to customers.
How is Inventory Cost calculated in this report?
It is the unit cost multiplied by the quantity on hand, giving the cost value of the stock in each row. The figure depends on a cost per item being set for the product in Shopify. Rows without a cost set will not show a meaningful value.
Can this report show stock across multiple locations?
Yes. The Location column shows where each variant's units are held, so you can compare the same SKU across warehouses, stores, and 3PLs, or filter to a single location.
How is Inventory on Hand different from the Inventory by Location report?
Inventory on Hand is a consolidated snapshot of everything you hold, with location as one column among several. Inventory by Location is built around the location dimension, showing each variant as a separate row per location with inventory value included. Use on Hand for the overall picture, and by Location when the location split is the main thing you are analyzing.
Can I add columns like inventory value, available quantity, or product status?
Yes. The pre-made report ships with the core fields, and you can add or remove columns to fit how you review stock. Add what you need and save the layout so it holds each time the report runs.
Can I schedule the Inventory on Hand report to run automatically?
Yes. Set it to send daily, weekly, or monthly to your inbox or your team, and export or push it to Excel, CSV, PDF, Google Sheets, or Google Drive.