Inventory Sale Value Report for Shopify
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.
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 Sale Value Report matters
Two stores with the same number of units in stock can be worth wildly different amounts at retail. A merchant with 10,000 units of low-priced accessories sits in a very different financial position than one with 10,000 units of premium outerwear. The Sale Value Report - sometimes called "Inventory at Retail" - answers a question Shopify's native reports don't: "If everything in my warehouse sold today at current prices, how much revenue would I capture?"
That number matters in three places: financial planning (forecasting potential revenue), merchandising (identifying overstocks tying up high-dollar inventory), and pricing (deciding what to promote, discount, or pull from active rotation).
Combined with the Inventory Cost Report, Sale Value also gives you the cleanest view of unrealized margin. The gap between cost and sale value is the gross profit waiting in your warehouse.
What's included in the report
Identification - Product Title · Variant Title · SKU
Product Price - Current selling price (not compare-at price).
Inventory Value - Inventory Quantity × Product Price. The headline number for this report.
Inventory Cost - Product Cost × Inventory Quantity. Useful for margin context.
Location - Where the inventory sits.
Collections - The product's collection memberships.
Product Status - Active, Draft, or Archived.
Vendor · Product Type · Inventory Quantity · Margin per unit · Total potential gross profit (Inventory Value − Inventory Cost) · Sales velocity · Days of inventory remaining
Who uses this report - 4 scenarios
1. Finance teams forecasting potential revenue
2. Merchandisers spotting high-value overstocks
3. Planners evaluating slow-moving stock
4. Insurance, audit, and valuation prep
How to read the Inventory Sale Value Report
• Pareto check. If 20% of your SKUs hold 80% of the Inventory Value, your capital is concentrated. That's fine if those SKUs sell - risky if they don't.
• Sale Value vs. last 90-day revenue. A ratio above 3-4× often signals overstock; below 1× signals understock risk.
• Status filter. Are Draft or Archived products holding inventory? That's stock you're not even selling.
• Collection imbalance. A collection with high Inventory Value but low sales velocity is your next discount candidate.
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 Sale Value Report 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 collection - see seasonal value, e.g., "Spring 2026" total
• Filter by location - value held at each warehouse
• Filter by status - exclude Draft / Archived from operational views
• Add Sales Velocity + Days of Inventory Remaining - convert valuation into action
• Add Total Potential Gross Profit - Inventory Value − Inventory Cost
• Group by Product Type or Vendor for category-level views
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 Shopify report that shows the retail-price value of your current inventory. Calculated as Inventory Quantity × Product Price, it tells you how much revenue is sitting in your warehouse if every unit sold at full price.
Sale Value uses selling price; Cost uses unit cost. Sale Value answers "what could this be worth?" Cost answers "what did this cost us?" Run both for a complete margin picture.
It uses the current Product Price as set in Shopify. If a product is on sale, the report reflects the sale price, not the compare-at.
Benefits
Inventory Value Breakdown
Complete Inventory View
Analyze Inventory Value
Related Reports
Inventory Status
A comprehensive overview of product inventory, detailing the quantity available for products that are live, in draft, or have been archived.
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.
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 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 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 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 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.
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.
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 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.
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 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 on Hand
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.
ABC Analysis
Every product graded A, B, or C by its share of revenue — so you can pour stock investment into the items that earn it, and stop over-buying the ones that don’t.
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.