What Is the Inventory on Hand Report?
The Inventory on Hand report in Data Export brings your Shopify products, variants, and stock details into one view. Review product titles, SKUs, vendors, locations, inventory quantities, and inventory costs without checking each item separately.
Use the product, variant, and location details together to understand where stock is held. This is a current inventory view when generated; a saved export is a snapshot for that check, rather than a record of sales over a chosen period.
The report helps your team prepare replenishment reviews, compare stock across locations, and share inventory details with purchasing or accounting. Review quantities alongside your sales and supplier information before deciding how much to reorder.
Report Overview
- Reporting basis
- Current inventory details when the report is generated; retain exports for later comparison.
- Data included
- Product Title, Variant Title, SKU, Vendor, Location, Inventory Quantity, and Inventory Cost.
- Best for
- Stock checks, location reviews, and supplier purchasing preparation.
- Export formats
- Excel, CSV, TXT, and PDF.
- Automation
- Schedule delivery by email daily, weekly, or monthly.
What Can You Learn from Your Inventory on Hand?
1. Which variants need a stock review
Review inventory quantity by SKU and variant to find items with little or no stock. A low quantity identifies a row to investigate; reorder needs also depend on demand and supplier lead times.
Example: Hypothetically, a medium blue shirt has two units at one location.
What you can do: Check recent demand and incoming stock before placing an order.
2. Where stock is uneven across locations
Compare the same SKU across locations to find differences in stock levels. This gives your operations team a starting point for a transfer review.
Example: Hypothetically, one store has no units of a mug while another holds 30.
What you can do: Check each location’s needs and transfer stock where appropriate.
3. Which vendor stock to review together
Use Vendor alongside SKU and inventory quantity to organize a purchasing discussion. Reviewing one supplier’s items together helps your buyer prepare a focused list.
Example: Hypothetically, several items from one vendor have low quantities.
What you can do: Review those SKUs with the supplier before combining replenishment requests.
What Should You Check First in This Report?
Start with the entries that affect your next stock decision.
- Inventory Quantity: Review zero, negative, or unexpectedly low quantities and investigate discrepancies.
- SKU and Variant Title: Confirm that the quantity belongs to the exact size, color, or option you intend to check.
- Location: Review stock where it is needed before treating a store-wide total as sufficient.
- Inventory Cost: Review missing or unexpected values and confirm the cost basis before calculating totals.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Running a regular on-hand stock check | Review current stock quantities and identify entries that need attention. |
| Reviewing vendor stock before purchasing | Group stock checks around the vendor and SKUs before preparing a purchase request. |
| Comparing variant stock across locations | Compare the same variant at different locations before considering transfers. |
| Checking costs before an inventory valuation | Review reported inventory costs and flag missing values before preparing a valuation. |
| Preparing a physical stock count | Export a SKU and location list to support a physical stock check. |
How to Create This Report in Data Export
Start with the premade Inventory on Hand report so the core fields are already selected.
- Open Data Export in your Shopify admin and find the premade Inventory on Hand report.
- Open the report and review its product, variant, SKU, vendor, location, quantity, and cost columns.
- Adjust columns or apply available filters for the stock entries you need. Check the location details before saving.
- Save and generate the report, then download it in Excel, CSV, TXT, or PDF as needed.
- For repeat checks, set up daily, weekly, or monthly email delivery to yourself or the relevant team members.
Make the Most of This Report
Use these checks to keep recurring stock exports useful.
01 / SNAPSHOT
Keep dated exports so your team can compare stock checks made at different times.
02 / LOCATION
Keep Location visible when reviewing the same SKU across several stores or warehouses.
03 / COST BASIS
Confirm whether Inventory Cost is per unit or an extended amount before summing it or multiplying it by quantity.
04 / TEAM DELIVERY
Send purchasing staff the relevant vendor or item view so each recurring export supports a specific stock review.
Frequently Asked Questions
Can I review inventory by location?
Yes. The Location field lets you review where each stock entry is held. Compare the same SKU and variant across locations when checking distribution.
Does this report show stock for a past date?
The report is intended for current stock checks. Keep dated exports if you need to compare snapshots; selecting a date range should not be treated as reconstructing a historical stock balance.
Can this report tell me which products are slow sellers?
Inventory quantities alone do not show selling speed. Compare the stock export with a sales report over a relevant period before identifying slow-moving items.
How should I use the Inventory Cost field?
Confirm the field’s calculation before using it for inventory valuation. A unit cost and a total row value require different treatment, and missing costs need review.
Can I schedule and export this report?
Yes. Download it as Excel, CSV, TXT, or PDF, and schedule daily, weekly, or monthly email delivery for regular stock reviews.
