The Inventory Health report provides detailed data about your sales, current sellable and unsellable quantities, inventory age, weeks of cover left, units which will be eligible for long-term storage fee (LTSF), estimated long-term storage fee (LTSF) amount, and information about additional offers that are available on your products. For example, you can see how many FBA offers, New and Used, are available for a given product, as well as the lowest FBA and non-FBA price for both New and Used condition. View the Inventory Health report.
Notes:
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 and the long-term storage fees columns in the table below:
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 Amazon 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 Amazon fulfillment centers, your Weeks of Cover t30 would be 1. |
units-shipped-last-365-days | If you have no sales for a given item in the last 365 days, the Weeks of Cover t365 value would be "infinite". | |
Est. Long-Term Storage Units (12+ months) | qty-to-be-charged-ltsf-12-mo | If you have 10 units of a given item which will be older than 12 months on the next long-term storage fees assessment date, the qty-to-be-charged-ltsf-12-mo will be 10, assuming no further sale of the item. |
qty-in-long-term-storage-program | If you had a total of five units of a given item which were already charged long-term storage fees in the last long-term storage fees charge date, the qty-in-long-term-storage-program will be 5. | |
Est. Long-Term Storage Fee (12+ months | projected-ltsf-12-mo | The amount of long-term storage fees you might pay for 10 units of a given item which will be older than 12 months on the next long-term storage fees assessment date, assuming no further sale of the item. This is calculated based on the volume occupied by the 10 units and the 12-monthly long-term storage fees rate. |
Est. Long-Term Storage Units (6+ Months) | qty-to-be-charged-ltsf-6-mo | If you have 15 units of a given item which will be aged between six months and 12 months on the next long-term storage fees assessment date, the qty-to-be-charged-ltsf-6-mo will be 15, assuming no further sale of the item. |
Est. Long-Term Storage Fee (6+ Months) | projected-ltsf-6-mo | The amount of long-term storage fees you might pay for 15 units of a given item which will be aged between six months and 12 months on the next long-term storage fees assessment date, assuming no further sale of the item. This is calculated based on the volume occupied by the 15 units and the six-monthly long-term storage fees rate. |
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 on a daily basis and will reflect information that is about 24 hours old.
This report is available for download through your seller account and through Merchant Web Services APIs.
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 | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify your products. SKUs are assigned by you as the seller. | AB-8675309 |
FNSKU | fnsku | Unique identifier assigned by Amazon to items stored in and fulfilled from an Amazon fulfillment center. | X00000E5TX |
asin | Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page. | B003ZYF3LO | |
Title | product-name | The title of your product | Toysmith Nonstick Bakeware Set |
Condition | condition | The condition of your item | New |
sales-rank | The Sales Rank calculation is based on Amazon sales and is updated daily to reflect recent and historical sales of the item sold on Amazon. The Sales Rank displayed here is for the Product Group within 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 is applicable. | Kitchen | |
total-quantity | The number of Units you have for a SKU in sellable condition in our fulfillment network. | 21 | |
Total unsellable quantity | unsellable-quantity | The number of units you have for a SKU in unsellable condition in our fulfillment network | 1 |
Total sellable quantity | sellable-quantity | The number of Units you have for a SKU in sellable condition in our fulfillment network. | 20 |
inv-age-0-to-90-days | The number of sellable Units 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 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 you have for a SKU that have been in the fulfillment center for the last 181 - 270 days | 3 | |
Sellable Inventory Age 271-365 days | inv-age-271-to-365-days | The number of sellable Units 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 you have for a SKU that have been in the fulfillment center for the last 365+ days | 2 |
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 from six to 12 months as of the next long-term storage fees assessment date | 3 |
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 12 months as of the next long-term storage fees assessment date | 2 |
Est. Long-Term Storage Fee (6+ Months) | projected-ltsf-6-mo | The projected long-term storage fees that will be charged for units that have been in fulfillment centers for six to 12 months on the next long-term storage fees assessment date, assuming no further sales of your inventory. | 663 |
Est. Long-Term Storage Fee (12+ months) | projected-ltsf-12-mo | The projected long-term storage fees that will be charged for units that have been in fulfillment centers for more than 12 months on the next long-term storage fees assessment date, assuming no further sale of your inventory. | 884 |
qty-in-long-term-storage-program | The number of sellable units that have already been charged long-term storage fees on the last charge date | 3 | |
Removal Units Requested | qty-with-removals-in-progress | The number of Units in inventory that you have requested 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 Amazon 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 that are in New condition | 10 | |
local_currency | Local currency for this market | AED | |
Your Price | your-price | Your current selling price | 200 |
sales-price | Your current promotional price | 150 | |
Lowest New AFN Price | lowest-afn-new-price | The lowest fulfilled by Amazon price for items in New condition, including any offers from Amazon.in. | 175 |
Lowest non-FBA New Price | lowest-mfn-new-price | The lowest price for items that are fulfilled by a seller. This includes the seller's shipping cost | 250 |
per-unit-volume | The volume in cubic footage of each inventory unit | 0.23 | |
Inbound Quantity | inbound-quantity | Quantity of units that are recorded in inbound shipments to Amazon fulfillment centers. | 10 |
Inbound Recommended Quantity | inbound-recommended quantity | Your recommended inbound quantity for the next eight weeks | 7 |
ASIN Limit | asin-limit | Your inventory limit for ASIN. Here we apply an inventory capacity limit. See ASIN Quantity Limit for more information. | 42 |
Hazmat? | is-hazmat | If your ASIN is considered Hazmat. See Hazardous Materials (Hazmat) to verify that your products qualify. | Yes |