What Is the Inventory Sale Value Report?
The Inventory Sale Value Report values the stock you currently hold at its selling price. For every product and variant in stock, it multiplies the inventory quantity by the product price to show the retail value sitting on your shelves. In short, it answers one question the native Shopify reports do not: if everything in stock sold today at current prices, how much revenue would that represent?
This values stock that has not sold yet, so it is a ceiling on potential revenue, not a record of realized sales. It also differs from Shopify's native [Month-end Inventory Value](link: /post/get-accurate-shopify-inventory-value-across-all-your-stores), which values stock at cost rather than at its selling price.
It also differs from the [Inventory Cost Report](link: /shopify-report/inventory-cost-report). Sale value looks at what your stock could earn at retail. Cost value looks at what that stock cost you to acquire. Same units, two different figures, and the gap between them is your unrealized margin.
Which Fields Are Included in the Inventory Sale Value Report?
These fields let you read each stock line, group it, and value it at retail in one place.
You can customize the pre-made report by adding, removing, or rearranging fields. Merchants often add Inventory Quantity, Vendor, or Product Type to see the units and grouping behind each value.
Important Insights You Can Find in This Report
How much potential revenue is sitting in stock, and where is it concentrated?
Total the Inventory Value column to see the retail value of everything you hold, then break it down by collection or location. If a small share of SKUs holds most of the value, your capital is concentrated in a few products. That is fine when those products sell quickly and a real risk when they do not. This total also gives finance and planning teams a starting ceiling for revenue that is already in stock versus what still needs sourcing.
Is your highest-priced stock also your slowest to sell?
Sort by Inventory Value, highest first, then look at which of those top rows are actually moving. A high price multiplied by a large quantity produces an impressive value figure, but if those units are not selling, that value is trapped rather than earned. High retail value paired with low movement is the clearest signal of expensive stock to promote, mark down, or reroute to another channel.
Is retail value building up in Draft or Archived products?
Filter by Product Status. Any inventory value attached to Draft or Archived products is value locked in items that are not even live on your storefront. This is easy to miss because the units still count toward your holdings, yet no customer can buy them. Catching it tells you where to relist, retire, or clear stock before it ages further.
THE ANALYST'S READ: The Signal Most Merchants Miss
A large sale value total feels reassuring, but sale value is a ceiling, not a promise. The number only converts to revenue if the stock actually sells, so the more useful read is in the composition of that value, not the headline.
Take two collections with the same Inventory Value. One reaches that figure through many low-priced units that turn over quickly. The other reaches it through a handful of expensive units that rarely sell. The totals look identical, but the risk is completely different. Value built from slow, high-price stock is far more fragile, because a single markdown or a season change can wipe out a big slice of it at once.
Read the report by pairing Inventory Value with Product Price and quantity, and compare it against how the stock is moving. Look for value that is concentrated in few, expensive, slow variants. That is where potential revenue is most likely to quietly turn into stranded capital, and it is worth checking before you plan the next purchase order.
How Can You Automate the Inventory Sale Value Report?
Open Report Pundit, select the pre-made Inventory Sale Value Report, and press Save. The columns are already set. To build it yourself, go to Custom Reports and add the fields listed above, apply a filter for a location, collection, or product status if you want to focus, then Save.
From there you can schedule it to email automatically on a daily, weekly, or monthly basis, so you never rebuild it by hand, and auto-send it to your team, your VA, or your accountant on the same schedule. Export it as Excel, CSV, or PDF, or push it to Google Sheets or Google Drive so the numbers land where you already work.
Frequently Asked Questions
What is the Inventory Sale Value Report?
It is a Shopify inventory report that values your current stock at its selling price. For each product and variant, it shows the retail value held in stock so you can see the potential revenue tied up in inventory.
How is Inventory Sale Value calculated?
It multiplies the inventory quantity of each variant by its product price. The result is the Inventory Value column, which represents the value of that stock at full retail rather than at cost.
How is this different from the Inventory Cost Report?
The two reports use the same products but a different price. Sale Value uses the selling price and answers what your stock could be worth. The [Inventory Cost Report](link: /shopify-report/inventory-cost-report) centers the same stock on its acquisition cost. Running both side by side shows the margin waiting in your warehouse.
Is Inventory Sale Value the same as total sales or gross sales?
No. Gross sales and total sales measure revenue from orders that have already been placed, using the quantity customers actually bought. Inventory Sale Value measures the retail worth of stock still sitting in your inventory, using the quantity on hand. One is money earned, the other is money potentially still to be earned. For how [gross sales](link: /post/what-is-shopify-total-sales-and-how-is-it-calculated) is calculated, see the total sales breakdown.
Does it use the current price or the compare-at price?
It uses the current Product Price set in Shopify. If a variant is marked down, the report reflects that lower active price, not the compare-at price.
Can I see sale value by location or collection?
Yes. Filter or group by Location to see value held at each warehouse or store, and by Collections to see value by category or season. This is useful for spotting where retail value is stacking up.
Can I schedule and export this report?
Yes. Schedule it to arrive by email daily, weekly, or monthly, export it as Excel, CSV, or PDF, or send it to Google Sheets or Google Drive on a set schedule.