Quick Overview of Shopify Inventory Value Report

Conventionally, all inventory reports can be divided into 3 groups by reporting period:

• historical inventory reports or inventory on the date
• inventory on hand - actual stock quantities, costs, values
• inventory forecasting reports (demands, replenishment time, etc.)

Shopify Inventory Value Report

Inventory value reports provide you with precise quantitative information about the products and variants available in your locations (warehouses).

Unlike other inventory reports, the inventory value report is based only on actual stock quantities on a date:

• month-end inventory value
• day-end inventory value
• current inventory value (inventory on hand), and so on.

In general cases, an inventory value report provides stock quantity, cost, and total cost for each product or product variant that is available in your Shopify store. Additionally, the report can include the actual product price, margin rate, potential profit, etc.

By default, the report is grouped by SKU (i.e., one product - one row in the report), but for other tasks, the report can be grouped by Inventory Locations, Vendor Names, Suppliers, or even by the product's ABC class.

Key Definitions

• Financial Quantity (Total Available, Quantity) - the total quantity of physical inventory.
• Ending Quantity - the total quantity at the end of the reporting period.
• Cost - the cost of purchased merchandise.
• Price - the price of the product for the end-user.
• Total Inventory Cost - SUM(Quantity × Cost)
• Margin Rate, % - (Price ÷ Cost - 1) × 100%
• Potential Profit, $ - Total Price - Total Cost

Inventory Value Report Examples

Below, we have collected different variations of inventory value reports that can be generated in Shopify or with our app. In addition to built-in reports, you can build custom Shopify reports with your own columns and filters.

Common Inventory Value Report

An inventory value report (also known as Inventory on Hand) shows the cost and quantity of inventory at this moment. The report typically includes the total value of all items in inventory, with a breakdown by SKU.

Live Example of Shopify Inventory Value Report

Inventory value reports are used to track inventory performance and to make decisions about inventory management (increase or reduce stock).

Inventory value report with a pivot by Location

Inventory by Location report provides a detailed analysis of your Shopify inventory value, broken down by location. By pivoting the data by location, you can gain insights into how inventory splitter by location in an easy-to-read view.

Live example of Shopify Inventory Report by Locations