Important: The Inventory Health report will be discontinued in 2022 and is being replaced by the new Manage Inventory Health report. The new report combines the best of the Inventory Age, Inventory Health, and Excess Inventory report metrics across sales, shipment statuses, estimated fees, storage volume and type, and aged and excess inventory. You can start using the new report right away. To learn more, go to Manage Inventory Health overview. You’ll still be able to access and download the Inventory Health report through 2021.
The Inventory Health report provides detailed data about your sales, current sellable and unsellable quantities, inventory age, and weeks of cover left, as well as information about additional offers that are available on your products. The online version of this report does not include all the columns available in the downloadable version.
The display columns were selected to show key information that can easily be viewed on a computer screen. Download the full report to see all available Inventory Health report data.
A detailed description of each of the fields is given in the table below. While most of the fields are self-explanatory, we have provided examples of weeks of cover.
Online Header | Download Header | Description |
---|---|---|
weeks-of-cover-t7 | If you sold 10 units for a given item in the last 7 days (1 week) and had 20 sellable units in fulfillment centers, you would have 2 weeks of cover. | |
Weeks of cover trailing 30 days | weeks-of-cover-t30 | If you sold 400 units in the last 30 days (4 weeks) for a given item and had 100 sellable units in fulfillment centers, your weeks of cover t30 would be 1. |
units-shipped-last-365-days | If you have had no sales for a given item in the last 365 days, the weeks of cover t365 value would be "infinite." |
We provide your sales and weeks of cover for a wide range of days, from 7 to 365, to accommodate varying business needs. We suggest you use the weeks of cover information (using the number of days that is appropriate for your business) to ensure that you are not understocked or overstocked for a given item. For items that are low on cover, we suggest that you replenish your inventory. For items that have excess cover, we suggest that you don't send any more inventory and perhaps schedule a removal.
The Inventory Health report is refreshed daily and will reflect information that is about 24 to 72 hours old.
Online header | Download header | Description | Example |
---|---|---|---|
snapshot-date | Report data is current as of the date in this field | 2011-06-26T07:00:00+00:00 | |
SKU | sku | Unique blocks of letters or numbers that you assign to the products that you are selling | AB-8675309 |
FNSKU | fnsku | Unique blocks of letters and numbers that Amazon assigns to products that are stored in and fulfilled from an Amazon fulfillment center | X00000E5TX |
asin | Unique blocks of 10 letters or numbers that Amazon assigns to the products that are sold through Amazon. You can find the ASIN on the product detail page. | B003ZYF3LO | |
Title | product-name | The name of your product | Toysmith Nonstick Bakeware Set |
Condition | condition | The condition of your item | New or used |
sales-rank | The sales rank is based on Amazon sales and is updated daily to reflect recent and historical sales of the item. The sales rank displayed here is for the product group in which the item is featured.
Note: If there is no sales ranking for the ASIN on Amazon, there will be no ranking in the report.
|
1,420 | |
product-group | The Amazon department or category for which the sales rank in the previous field applies | Kitchen | |
total-quantity | The number of sellable and unsellable units that you have for a SKU in our fulfillment network | 21 | |
Total unsellable quantity | unsellable-quantity | The number of unsellable units that you have for a SKU in our fulfillment network | 1 |
Total sellable quantity | sellable-quantity | The number of sellable units that you have for a SKU in our fulfillment network | 20 |
inv-age-0-to-90-days | The number of sellable units that you have for a SKU that have been in the fulfillment center for the last 0-90 days | 0 | |
inv-age-91-to-180-days | The number of sellable units that you have for a SKU that have been in the fulfillment center for the last 91-180 days | 19 | |
inv-age-181-to-270-days | The number of sellable units that you have for a SKU that have been in the fulfillment center for the last 181-270 days | 0 | |
Sellable inventory age 271-365 days | inv-age-271-to-365-days | The number of sellable units that you have for a SKU that have been in the fulfillment center for the last 271-365 days | 0 |
Sellable inventory age 365+ days | inv-age-365-plus-days | The number of sellable units that you have for a SKU that have been in the fulfillment center for the last 365+ days | 1 |
Est. long-term storage units (6+ months) | qty-to-be-charged-ltsf-6-mo | The number of sellable units that will have been in the fulfillment center for 180 to 365 days and would be subject to the 180-day long-term storage fee charge as of the next charge date. For example, FBA Small and Light products are subject to this 180-day fee. | 400 |
Est. long-term storage units (12+ months) | qty-to-be-charged-ltsf-12-mo | The number of sellable units that will have been in the fulfillment center for more than 365 days as of the next long-term storage fee charge date (monthly on the 15th) | 400 |
qty-in-long-term-storage-program | The number of sellable units that have previously been charged the long-term storage fee | 500 | |
Est. long-term storage fee (6+ months) | projected-ltsf-6-mo | The projected long-term storage fee that will be charged for eligible units that have been in fulfillment centers for 180 to 365 days on the next charge date. For example, FBA Small and Light products are subject to this 180-day fee. | 500 |
Est. long-term storage fee (12+ months) | projected-ltsf-12-mo | The projected long-term storage fee that will be charged for units that have been in fulfillment centers for more than 365 days on the next charge date (monthly on the 15th) | 500 |
Removal units requested | qty-with-removals-in-progress | The number of units in inventory that you have asked to be removed | 1000 |
units-shipped-last-24-hrs | Sales of this item in last 24 hours | 1 | |
units-shipped-last-7-days | Sales of this item in last 7 days | 2 | |
Units shipped last 30 days | units-shipped-last-30-days | Sales of this item in last 30 days | 8 |
units-shipped-last-90-days | Sales of this item in last 90 days | 25 | |
units-shipped-last-180-days | Sales of this item in last 180 days | 40 | |
units-shipped-last-365-days | Sales for this item in last 365 days | 95 | |
weeks-of-cover-t7 | Based on your sales in the last 7 days, the weeks of cover of sellable inventory that you have in the fulfillment centers. For example, if you sold 10 units in the last 7 days and had 20 sellable units in fulfillment centers, you would have 2 weeks of cover. | Infinite | |
Weeks of cover trailing 30 Days | weeks-of-cover-t30 | Based on your sales in the last 30 days, the weeks of cover of sellable inventory that you have in the fulfillment center | 54.7 |
weeks-of-cover-t90 | Based on your sales in the last 90 days, the weeks of cover of sellable inventory that you have in the fulfillment center | 25.4 | |
weeks-of-cover-t180 | Based on your sales in the last 180 days, the weeks of cover of sellable inventory that you have in the fulfillment center | 28.1 | |
weeks-of-cover-t365 | Based on your sales in the last 365 days, the weeks of cover of sellable inventory that you have in the fulfillment center | 36.1 | |
num-afn-new-sellers | The number of sellers with FBA offers for the product in new condition | 10 | |
num-afn-used-sellers | The number of sellers with FBA offers for the product in used condition | 112 | |
local_currency | Local currency for this store | USD | |
Your price | your-price | Your current selling price | 10.25 |
sales-price | Your current promotional price | 4.00 | |
Lowest new AFN price | lowest-afn-new-price | The lowest FBA price for items in new condition, including any offers from Amazon | 11.75 |
Lowest FBA used price | lowest-afn-used-price | The lowest FBA price for items in used condition | 4.99 |
Lowest non-FBA new price | lowest-mfn-new-price | The lowest price for items in new condition that are fulfilled by a seller. This includes the seller's shipping cost. | 12.25 |
Lowest non-FBA used price | lowest-mfn-used-price | The lowest price for items in used condition that are fulfilled by a seller. This includes the seller's shipping cost. | 4.95 |
per-unit-volume | The volume in cubic feet of each inventory unit | 0.23 | |
Inbound quantity | inbound-quantity | Number of units that are recorded in shipments to fulfillment centers | 10 |
Inbound recommended quantity | inbound-recommended quantity | Your recommended shipment quantity for the next eight weeks | 7 |
ASIN limit | asin-limit | Your inventory limit for ASINs on which we apply an inventory capacity limit | 42 |
Hazmat? | is-hazmat | Indicates whether the ASIN is considered a dangerous good | Yes |