- The Product ASIN, SKU & Product Title are taken directly from the Product Settings page (if you edit the name of your product in that section, those changes will be reflected here as well):
Now let's look at the next set of columns to understand which information is displayed, and the formulas used to obtain each value:
- Inventory Status → This represents the status of your current inventory levels, and it is calculated based on the Reorder Days of Supply vs Lead Time vs Days Remaining.
- In stock means that the Days Remaining is great than the lead time plus 7 days
- Order Now means you will most likely run out of stock if you keep selling at your Average Daily Sales rate. This is because your Lead Time is greater than the number of days of inventory you currently have. You should reorder this product right away to minimize the days you will be out of stock.
- Reorder Soon means you are within a 7-day window of the Reorder Now status. This means you should reorder this product right away and have 7 days or less to order and avoid a stock out.
- Overstock means that the days remaining is 150% of reorder of days supply.
If you added all the required information, but you still do not see the Inventory Status for your products, please check if you have the Average Daily Sales data. If there is no sales data for us to use, the Inventory Manager won't be able to apply a status for your products
- Date to Reorder = Today ➕ (Days Remaining ➖ Lead Time) → This shows you the latest date for you to reorder your products to avoid a stock out.
- Reorder Quantity = Reorder Days of Supply ✖️ Avg Daily Sales → This is the recommended number of units you need to order on the recommended reorder date.
- Reorder Cost = Reorder Qty ✖️ Total Cost Per Unit → The cost of purchasing the recommended reorder quantity.
- Reorder Profit = Avg. Profit Per Unit ✖️ Reorder Qty → This shows you the potential profit from the recommended reorder quantity.
- Reorder Days of Supply → Taken from the Product Costs Page (you need to add this info manually as part of your product costs). This represents how many additional days of selling you'll have once your next inventory reorder arrives.
- Lead Time → Taken from the Product Costs Page (you need to add this info manually as part of your product costs). This represents how many days it takes for your product to be manufactured, shipped, and delivered to an Amazon Fulfillment Center.
- Days Remaining = (Inventory Level ➕ Inbound Level) ➗ Avg Daily Sales → It represents how many days remain until you run out of stock.
- Inventory Level = Fulfillable Inventory ➕ reserved Inventory ➖ Pending Orders→ This information comes directly from Amazon, and it represents how many available units you currently have. It does not include any inbound units (as technically, they are not available for shipment), but it does include reserved units. For an in-depth explanation of reserved inventory, make sure you read the following 📝 Seller Central article
- Inbound Level → This information comes directly from Amazon and it represents the number of units on their way to a Fulfilment Center.
- Inventory Level Revenue = Inventory Level ✖️ Sales Price → The potential revenue your current inventory could earn.
- Inventory Level Cost = Inventory Level ✖️ Total Cost Per Unit → The total value, at cost, of your available inventory.
- Inventory Level Profit = Inventory Level ✖️ Avg. Profit Per Unit → The potential profit of your available inventory.
- Avg Daily Sales → Information originates from Sales Data (this is the average number of sales per day for the product).
- Avg. Profit Per Unit → This information originates from Sales Data and represents the average profit per unit for the chosen sales history period.