Inventory reports

Inventory reports display a month-end snapshot of your inventory, and help you track the quantity and percentage of inventory sold per day.

If you delete a product or variant from your inventory, then the analytics data related to that product or variant is preserved for reporting services. This ensures that you can still access historical data even after deletion.

It can take 12-72 hours before inventory changes display in reports.

View your inventory reports

  1. From your Shopify admin, go to Analytics > Reports.
  2. Click Categories.
  3. Click Inventory to filter the reports to display only inventory reports.

Month-end inventory snapshot

The Month-end inventory snapshot report displays the quantity of each product variant you had in stock at the end of each month.

For this report, Available inventory excludes:

  • Committed inventory for orders pending fulfillment
  • Incoming units that are a part of a transfer

The following columns are in the Month-end inventory snapshot report:

Definition of terms in the month-end inventory snapshot
TermDescription
Product titleThe title of the product.
Variant titleThe title of the product variant.
Variant SKUThe stock keeping unit identification code for the product variant option.
Ending quantityThe trackable Available inventory quantity of a product variant at the end of the last day of the selected time period (might be a negative number). This excludes Incoming and Committed inventory.

Negative inventory numbers

A negative number might display in the Ending quantity column in the Month-end inventory snapshot report for the following reasons:

  • You have inventory tracking checked 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 is 5 and the ending quantity is -3, because you oversold the product by three units.
  • You don't have inventory tracking checked. If you don't have inventory tracking checked, then the default quantity is set to 0 and each order decreases the number of items available by one. For example, without inventory tracking checked, if you add a new product to your store and receive two orders for that product, then the starting quantity is 0 and the Ending quantity is -2.

For more information about inventory tracking, refer to Tracking and adjusting inventory.

Month-end inventory value

Similar to the month-end inventory snapshot, the Month-end inventory value report totals the current amount of Available inventory on products with a cost per item value assigned at the time of sale.

For this report, Available inventory excludes:

  • Committed inventory for orders pending fulfillment
  • Incoming units that are a part of a transfer

The following columns are in the Month-end inventory value report:

Definition of terms in the month-end inventory value report
TermDescription
Product titleThe title of the product.
Variant titleThe title of the product variant.
Variant SKUThe stock keeping unit identification code for the product variant option.
CostThe cost per item value for the product variant option.
Ending quantityThe trackable Available inventory quantity of a product variant at the end of the last day of the selected time period (might be a negative number). This excludes Incoming and Committed inventory.
Total inventory valueThe cost per item multiplied by the ending quantity amount for each product variant option. The sum of these values displays in the Summary row.

Average inventory sold per day

The Average inventory sold per day report displays the average number of items of inventory sold per day by product variant.

The following columns are in the Average inventory sold per day report:

Definition of terms in the average inventory sold per day report
TermDescription
Product titleThe title of the product.
Variant titleThe title of the product variant.
Variant SKUThe stock keeping unit identification code for the product variant option.
Quantity soldNumber 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 quantityThe 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 dayAverage 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 displays the percentage of each variant's inventory sold that is sold from the total starting quantity during the selected period. Product variants only display in the report if they have been sold at least one time before or during the selected period.

The following columns are in the Percent of inventory sold report:

Definition of terms in the percent of inventory sold report
TermDescription
Product titleThe title of the product.
Variant titleThe title of the product variant.
Variant SKUThe stock keeping unit identification code for the product variant option.
Quantity soldNumber 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 quantityQuantity 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 soldPercentage 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%

A value below 0% or above 100% might display in the Percent sold column in the Percent of inventory sold report for the following reasons:

  • You have inventory tracking checked 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 is 200%.
  • 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 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 cost of the item does not factor into the calculation of an item's grade. 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 following columns are in the ABC analysis by product report:

Definition of terms in the ABC analysis report
TermDescription
Product titleThe title of the product.
Variant titleThe title of the product variant.
Variant SKUThe stock keeping unit identification code for the product variant option.
Product gradeThe grade based on the percentage of your revenue that each variant contributed to over the last 28 days.
Ending quantityThe 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. Any product whose ending inventory quantity value is less than 0 is considered to have a total value (cost) of 0 USD.
Total value (price)The total value of the product inventory based on the sale price, excluding discounts. Any product whose ending inventory quantity value is less than 0 is considered to have a total value (price) of 0 USD.

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.

Product sell-through rate

The Product sell-through report displays what percentage of your total inventory you’ve sold during the selected time period. Due to data latency and processing times, the most recent time period that can be returned for this report is approximately two days prior to the current date. For earlier time zones, such as UTC +14:00, this delay is closer to three days. The exact dates are displayed at the top of the report.

Sell-through rate is calculated as: Total quantity of items sold divided by the (total quantity of items sold + total quantity of items still in inventory).

The calculation's denominator, (total quantity of items sold + total quantity of items still in inventory), represents the amount of stock on hand. It accounts for any restocks or new inventory received during the selected period.

The total quantity of items sold is measured over the selected time period, and the total quantity of items still in inventory is measured at the last date in the selected time period.

Our sell-through rate calculation automatically ignores negative inventory quantities, which can occur in the case of products whose inventory isn't tracked (such as gift cards and digital products) and products that are oversold.

Product variants only display in the report if they have been sold at least one time before or during the selected period.

For the purposes of the sell-through calculation:

  • Products whose inventory isn't tracked are considered to have sold 0 units of inventory.
  • Any product whose ending inventory quantity value is less than 0 is considered to have an ending quantity value of 0.

The following columns are in the Product sell-through report:

Definition of terms in the Product sell-through report
TermDescription
Product titleThe title of the product.
Variant titleThe title of the product variant.
Variant SKUThe stock keeping unit identification code for the product variant option.
Starting quantityThe trackable inventory quantity of a product variant at the start 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.
Ending quantityThe 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 soldNumber of units of a product variant sold during the selected period (doesn't reflect inventory adjustments such as returns, manual adjustments, or transfer receipts).
Sell-through rateTotal quantity of items sold divided by the (total quantity of items sold + total quantity of items still in inventory).
The data is calculated using the most recent 30 day period available (usually a 2 day processing delay, exact dates are indicated in the sell-through rate report).

Days of inventory remaining

The purpose of this report is to give an overall sense of how long your tracked inventory is estimated to last, based on your average sales rates for each variant, and the amount of inventory you have left.

The chart in this report displays how many product variants are predicted to run out of stock soon (0 days remaining), or have some days of stock remaining (0-30 days, up to 91+ days remaining).

The table in this report displays the days of inventory remaining for each of your product variants. Days of inventory remaining is calculated as:

Total quantity of items still in inventory (ending quantity) divided by the average quantity of items sold per day.

A product variant's average quantity of items sold per day is calculated based on its sales over the last 28 days.

If a product variant did not have any sales in the selected time period (and thus has an average quantity of items sold per day value of 0), then its days of inventory remaining value is set to N/A, as we don't have sufficient data to make a prediction. If a product variant has a negative ending quantity value, then its days of inventory remaining value is set to 0.

The following columns are in the Days of inventory remaining report:

Definition of terms in the days of inventory remaining report
TermDescription
Product titleThe title of the product.
Variant titleThe title of the product variant.
Variant SKUThe stock keeping unit identification code for the product variant option.
Ending quantityThe 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 dayThe total quantity of items of a product variant sold in the selected time period, divided by the number of days that the product variant was active during that time period.
Days of inventory remainingThe total quantity of items still in inventory, divided by the average quantity of items sold per day, to give an estimate of how many days remain before inventory runs out.
Can’t find the answers you’re looking for? We’re here to help.