The Inventory Health report provides detailed data about your sales, current sellable and unsellable quantities, inventory age, weeks of cover left, 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. (For non-FBA units, the lowest new and used prices includes both product price and shipping charge.)
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 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 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”.|
We have provided your sales and Weeks of Cover for a wide range of days, from 7 to 365 days, 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 under-stocked or over-stocked for a given item. For items that are low on cover, we suggest you replenish your inventory. For items that have excess cover, we suggest 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-72 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 or Used|
|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.
|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||0|
|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||1|
|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 12+ months as of the next Inventory Cleanup (August 15 or February 15)||400|
|qty-in-long-term-storage-program||The number of sellable units that have already been charged an annual Long-Term Storage Fee||500|
|Est. Long Term Storage Fee (12+ Months)||projected-ltsf-12-mo||The projected Long-Term Storage Fees that will be charged for the Est. Long-Term Storage Units (12+ months), assuming no further sales of your inventory.||500|
|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|
|num-afn-used-sellers||The number of sellers with FBA offers that are in Used condition||112|
|local_currency||Local currency for this market||EUR|
|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 fulfilled by Amazon 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 meters 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 ASINs where we apply an inventory capacity limit. Please see ASIN Quantity Limits for more information.||42|
|Hazmat?||is-hazmat||If your ASIN is considered Hazmat. Please see Hazardous Materials (Hazmat) to see if your products qualify.||Yes|