Inventory reports
If your store is on the Basic Shopify plan or higher, then you have access to reports about your inventory. You can use your inventory reports to view a month-end snapshot of your inventory, and track the quantity and percentage of inventory sold per day.
It can take 12-72 hours before inventory changes appear in reports.
View your inventory reports
- From your Shopify admin, go to Analytics > Reports.
- From the Shopify app, tap Store, and then tap Analytics.
- Tap Reports.
- From the Shopify app, tap Store, and then tap Analytics.
- Tap Reports.
- In the Inventory section, click the report that you want to see.
Month-end inventory snapshot
The Month-end inventory snapshot report shows the quantity of each product variant you had in stock at the end of each month.
The following columns are in the report:
Term | Description |
---|---|
Product title | The title of the product |
Variant title | The title of the product variant |
Variant SKU | The stock keeping unit identification code for the product variant option |
Ending quantity | The trackable inventory quantity of a product variant at the end of the last day of the selected time period (might be a negative number) |
Negative inventory numbers
You might see a negative number in the Ending quantity column in the Month-end inventory snapshot report for the following reasons:
You have inventory tracking enabled and you oversell a variant. For example, if you set the inventory quantity of a product to
5
at the beginning of the day and you receive eight orders for the product during the day, then the starting quantity is5
and the ending quantity is-3
, because you oversold the product by three units.You don't have inventory tracking enabled. If you don't have inventory tracking enabled, then the default quantity is set to
0
and each order decreases the number of items available by one. For example, without inventory tracking enabled, if you add a new product to your store and receive two orders for that product, then the starting quantity is0
and the Ending quantity is-2
.
For more information about inventory tracking, refer to Tracking and adjusting inventory.
Average inventory sold per day
The Average inventory sold per day report shows the average number of items of inventory sold per day by product variant.
The following terms are in the report:
Term | Description |
---|---|
Product title | The title of the product |
Variant title | The title of the product variant |
Variant SKU | The stock keeping unit identification code for the product variant option |
Quantity sold | Number of units of a product variant sold during the selected period (doesn't reflect inventory adjustments such as returns, manual adjustments, or transfer receipts) |
Ending quantity | The trackable inventory quantity of a product variant at the end of the last day of the selected time period (might be a negative number) |
Quantity sold per day | Average number of items of the product variant sold per day during the selected period (quantity sold divided by number of days in the time period) |
Percent of inventory sold
The Percent of inventory sold report shows the percentage of each variant's inventory sold that is sold from the total starting quantity during the selected period. Product variants will only appear in the report if they have been sold at least once before or during the selected period.
The following terms are in the report:
Term | Description |
---|---|
Product title | The title of the product |
Variant title | The title of the product variant |
Variant SKU | The stock keeping unit identification code for the product variant option |
Quantity sold | Number of units of a product variant sold during the selected period (doesn't reflect inventory adjustments such as returns, manual adjustments, or transfer receipts) |
Starting quantity | Quantity of a product variant at the beginning of the first day of the selected time period (might be a negative number), or the variant's Starting quantity for variants that were added within the selected time period |
Percent sold | Percentage of the product variant sold during the selected period, out of the total starting quantity (values greater than 100%, lower than 0%, or N/A are possible) |
Values below 0% or over 100%
You might see a value below 0% or above 100% in the Percent sold column in the Percent of inventory sold report for the following reasons:
You have inventory tracking enabled and you oversell a variant. For example, if the inventory quantity of a product is
5
at the beginning of the day and you receive ten orders for the product during the day, then the Percent sold is200%
.The Starting quantity is negative. For example, if the inventory quantity of a product is
10
at the beginning of the day and you receive 15 orders for the product during the day, then the Starting quantity the following day will be-5
. If you don't restock the product the following day and you receive two more orders for the product, then the Percent sold that day is-40%
.
The value is N/A if the Starting quantity is 0
.
ABC analysis by product
The ABC analysis by product report is available on the Shopify plan or higher.
The report gives each product variant a grade based on the percentage of your revenue that each variant contributed to over the last 28 days. The timeframe cannot be adjusted, and will update daily to provide the most up-to-date information:
- A-grade - Your top selling products that collectively account for 80% of your revenue.
- B-grade - The products that collectively account for the next 15% of your revenue.
- C-grade - The products that collectively account for the last 5% of your revenue.
For more information about how to use the data from this report, refer to ABC analysis.
The ABC analysis report contains the following columns.
Term | Description |
---|---|
Product title | The title of the product |
Variant title | The title of the product variant |
Variant SKU | The stock keeping unit identification code for the product variant option |
Product grade | The grade based on the percentage of your revenue that each variant contributed to over the last 28 days |
Ending quantity | The trackable inventory quantity of a product variant at the end of the last day of the selected time period (might be a negative number) |
Total value (cost) | The total value of the product inventory based on the merchant cost |
Total value (price) | The total value of the product inventory based on the sale price, excluding discounts |
The ABC analysis report helps you understand which products to prioritize when restocking, and which products you shouldn’t invest in too heavily. If you sell out of the products that account for 80% of your revenue(A-grade products), then you can miss out on sales. If you overstock products that account for only 5% of your revenue (C-grade products), then you can spend more on warehousing costs than necessary.