Inventory on Hand Report for Shopify
A real-time snapshot of every product, variant, and SKU in stock - across every warehouse, retail location, and 3PL - with vendor, cost, and inventory value in a single view.
5 from 1,800+ merchants
2,000+ data fields
Trusted by 40,000+ Shopify stores
Updated June 2026
.png)
.png)
.svg)
.svg)
.svg)
Why the Inventory on Hand Report matters
Stock visibility sounds obvious until it's wrong. A merchant who thinks 60% of inventory sits in the warehouse and 40% in the storefront makes very different staffing, shipping, and reorder decisions than one whose split is actually 80/20. Shopify's native "Inventory on hand" report updates once daily at midnight and stops short of giving you a unified, filterable, exportable view across every location.
That gap matters because every other decision in your store flows from it. Replenishment timing, fulfillment routing, capital tied up in inventory, and even your marketing calendar all depend on knowing - right now - what you actually have to sell.
The Inventory on Hand Report in Report Pundit gives you that view in seconds. It pulls live data on every product and variant, lets you filter by location, vendor, tag, or collection, and adds the financial columns (cost, value, days remaining) that Shopify's native report doesn't expose. It's the single inventory report most merchants check first thing every morning.
What's included in the report
Product Title - Name of the product.
Variant Title - Color, size, age, or any other variant attribute.
SKU - Unique identifier used across catalog, fulfillment, and accounting.
Vendor - Supplier of the product. Critical when grouping reorder lists by supplier.
Location - Name of the warehouse, retail location, or 3PL holding the inventory.
Inventory Quantity - Live units in stock at that location for that variant. - Inventory Cost - Product Cost × Inventory Quantity. The financial value of stock at cost. Requires unit cost set in Shopify.
Product Price · Inventory Value (selling-price basis) · Product Status (Active / Draft / Archived) · Collections · Product Tags · Days of Inventory Remaining · Sales Velocity (last 7 / 30 / 90 days)
Who uses this report - 4 scenarios
1. Multi-location retailers reconciling warehouse vs. storefront stock
Operations teams running daily restocking
CFOs valuing inventory for monthly close
Wholesale and B2B merchants preparing for buyer requests
How to read the Inventory on Hand Report
- Zero or negative inventory on active products. Negative numbers indicate over-committed stock - orders accepted before inventory was received. Fix in Shopify before the next batch of orders arrives.
- Vendor concentration. If one vendor accounts for 40%+ of total Inventory Cost, you're carrying supply-chain risk. Surface this for procurement.
- Location imbalance on the same SKU. If 95% of a fast-mover sits in your East warehouse but most orders ship from the West, you have a transfer to plan.
- nventory Cost vs. revenue. Divide total Inventory Cost by last month's revenue. Healthy DTC stores typically sit in 1-3× monthly revenue; way above means capital is tied up.
How to build the report in Report Pundit
- Install Report Pundit from the Shopify App Store. 14-day free trial. No card required.
- Open Report Pundit from your Shopify admin and click Pre-built Reports.
- Select Inventory on Hand from the Inventory category.
- Apply filters (location, vendor, collection, product tag, product type, status - whatever fits).
- Customize columns - add COGS, inventory days remaining, sales velocity, sell-through, or any of 2,000+ fields.
- Run the report. Results load in seconds for most stores.
- Export or schedule - Google Sheets, Excel, CSV, PDF, or scheduled email delivery to your team.
Sample report
Customization & filters
• Filter by location - see only warehouse, only POS, or any specific location
• Filter by vendor - build vendor-specific reorder lists in seconds
• Filter by product tag, collection, or product type - focus on seasonal, bestseller, or specific categories
• Filter by status - exclude Draft or Archived products from operational views
• Add Sales Velocity - couple stock with how fast it's moving
• Add Inventory Days Remaining - turns the snapshot into a forecast
• Multi-store rollup - combine inventory across Shopify Plus stores
Automate & export
- Schedules — hourly, daily, weekly, monthly, or custom cron
- Delivery formats — Excel, CSV, PDF, or push to Google Sheets in real time
- Group by month or week — trends instead of a static snapshot
- Destinations — email (multiple recipients), Google Sheets, Google Drive, FTP/SFTP, Looker Studio, BigQuery
- Conditional alerts — get notified only if a channel's net sales drop more than X% week-over-week
Report Pundit vs Shopify's native Sales by Channel report
Frequently Asked Questions
It's a report that shows the live, unit-by-unit stock level of every product and variant in your store, broken down by SKU, vendor, and inventory location. Used daily for replenishment, fulfillment, and inventory valuation.
Shopify's native report updates once daily at midnight, limits filtering, and doesn't expose cost or value columns. Report Pundit refreshes near-real-time, lets you filter and group by any field, adds financial columns, supports multi-store rollup, and can be scheduled to email or push to Google Sheets.
Yes. Group or filter by location to see warehouse vs. retail vs. 3PL stock side-by-side. Shopify Plus merchants can also combine inventory across multiple Shopify stores.
Benefits
Up-to-date Inventory
Inventory Value
Effective Demand Planning
Related Reports
Inventory level Indicator
The report provides Shopify merchants with a real-time analysis of stock levels, highlighting products that are overstocked, optimally stocked, or understocked. This report is essential for monitoring stock health and ensuring that inventory levels align with demand.
Inventory On Specific Day
A point-in-time snapshot of exactly what you had in stock on any past date — by product, variant, SKU, and location — for month-end accounting, audits, and cross-date comparison.
Inventory Sell-Through
The percentage of stock that actually sold for every product and variant so you can separate the fast-movers worth reordering from the dead stock eating your shelf space and cash.
Inventory Sale Value
A report outlining the sale value of your inventory, including details on product quantities, variants, collections, and total value based on current sale prices for analysis.
Inventory by Location
A report organized by inventory locations, detailing products and variants on hand, with a breakdown of the value for each product.
Inventory Cost
The Inventory Cost Report provides a comprehensive analysis of the costs associated with your inventory, giving you a clear view of the financial investment tied up in stock. This report calculates the cost of inventory on hand and can include both current and historical cost data
Inventory by Product Type
This is grouped inventory data organized by custom product types, alongside product and variant details, providing a comprehensive view to analyze overall inventory status.
Out of Stock Product
A report listing products that are out of stock, including essential details such as product inventory and the location where the stock was depleted.
Inventory Shipments
Every inbound shipment tracked end to end — shipped, received, accepted, and rejected quantities with acceptance rate — so you can catch discrepancies, plan around arrivals, and benchmark supplier reliability.
Inventory Reorder Point
This report helps identify the exact point at which inventory should be restocked to prevent any interruptions in product availability, ensuring a smooth supply chain from both your inventory and your vendor's end. It informs the merchant about the sales velocity, lead time, and safety stock.
Inventory Replenishment
A ready-to-action list of exactly which products need reordering now — driven by real sell-through velocity, adjusted for stock already on its way, and broken down by location.
Inventory Transfers
Every stock movement between your locations in one view — origin, destination, status, and received-vs-rejected quantities — so you can balance stock, reconcile transfers, and measure internal lead times.
Low Stock Product
The Low Stock Product Report highlights products that are approaching or have reached a low stock threshold, helping Shopify merchants proactively manage restocking needs. This report is crucial for preventing stockouts on popular items and ensuring seamless sales without interruption
Inventory by Collections
This report provides a detailed view of inventory levels, organized by product collections, allowing businesses to track stock availability and manage inventory efficiently.
Build and automate your
Shopify Reporting
Unlock the full potential of your Shopify store with Report Pundit.
Gain access to over 2000 data fields, automate reports, and make
data-backed decisions to grow your business.