Important: The Inventory Age report will be discontinued in 2022 and is being replaced by the Manage Inventory Health report. The Manage Inventory Health 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. To learn more, go to Manage Inventory Health overview.
Use the Inventory Age report to see how long your inventory has been in fulfilment centres and identify items that will be subject to upcoming long-term storage fees. The report also provides details about sales, current sellable quantities, your list price and the lowest price on Amazon for the same item for all of your FBA inventory.
To download this report, do the following:
The following per-ASIN information is included in the report:
Field name | Description |
---|---|
snapshot-date | The date the report was generated on |
sku | Unique blocks of letters and numbers that you assign to the product that you are selling |
fnsku | Unique blocks of letters and numbers that Amazon assigns to products that are stored in and fulfilled from an Amazon fulfilment centre |
asin | Unique blocks of 10 letters or numbers that Amazon assigns to the products that are sold through Amazon |
product-name | The name of your product |
condition | The condition of the unit (for example, new or used) |
available-quantity(sellable) | The number of units in inventory that are available for purchase |
qty-with-removals-in-progress | The number of units in inventory that you have asked to be returned to you or disposed of |
inv-age-0-to-90-days | The number of sellable units that have been in the fulfilment centre for the last 0–90 days |
inv-age-91-to-180-days | The number of sellable units that have been in the fulfilment centre for the last 91–180 days |
inv-age-181-to-270-days | The number of sellable units that have been in the fulfilment centre for the last 181–270 days |
inv-age-271-to-365-days | The number of sellable units that have been in the fulfilment centre for the last 271–365 days |
inv-age-365-plus-days | The number of sellable units that have been in the fulfilment centre for the last 365+ days |
Currency | The currency for the estimated long-term storage fee |
qty-to-be-charged-ltsf-12-mo | The number of sellable units that will have been in the fulfilment centre for more than 365 days as of the next charge date (monthly on the 15th) |
projected-ltsf-12-mo | The projected long-term storage fee that will be charged for units that have been in fulfilment centres for more than 365 days on the next charge date (monthly on the 15th) |
units-shipped-last-7-days | Units shipped in the last 7 days |
units-shipped-last-30-days | Units shipped in the last 30 days |
units-shipped-last-60-days | Units shipped in the last 60 days |
units-shipped-last-90-days | Units shipped in the last 90 days |
alert |
Shows whether this item has low traffic or low conversion. Low traffic indicates that a low number of potential buyers have seen the listing. Use the Improve keywords feature in the actions list to optimise how your listing appears in searches. The Advertise listing feature allows you to advertise through Sponsored Products to drive additional traffic to your listing. Low conversion indicates that potential buyers are viewing the listing but not following through and buying the product. Ensuring a high-quality detail page and pricing competitively can help to improve conversion rates. |
your-price | Your listed price |
sale_price | Your sale price if you are running a sale on the product |
lowest_price_new | The lowest price, including shipping, for this item in new condition on Amazon |
lowest_price_used | The lowest price, including shipping, for this item in used condition on Amazon |
Recommended Action | The action recommended for your inventory. Recommendations depend on your inventory position, ASIN alerts and known inputs when the report was generated. |
Healthy inventory level | Quantity of inventory that is not considered excess based on product demand and your costs. Our recommendations are based on helping you reach this level of inventory. |
Recommended sales price | Sales price recommended to help you sell through your inventory based on your current inventory settings. This value may be different from the lowest price or Featured Offer price. We recommend that you keep your product at this price until you have sold through your excess inventory. |
Recommended sale duration | If a sale is recommended, this is the estimated sale duration in days that would be likely to help you sell your excess inventory. |
Estimated storage cost | Estimated FBA storage fees and your holding cost of capital if no action is taken to help sell through or remove your inventory. The storage fees may include the long-term storage fee and are based on your current sales rate. The estimation is calculated over a three-year horizon.
Note: Inventory quantities are based on a daily snapshot and may differ from your actual inventory quantities.
|
Recommended Removal Quantity | Estimated quantity of inventory that would likely benefit from removal instead of being charged storage fees |
estimated-cost-savings-of-recommended-actions | Estimated cost savings between taking the recommended action versus the storage fees that you would incur on that inventory by taking no action |
sell-through | The rate at which your units sold and shipped over the past 90 days divided by the average inventory available at fulfilment centres during that time period. Tracking your sell-through rate can help you determine whether you need to take action to improve traffic or conversion for your products. |
item-volume | The volume of the item, which is calculated by multiplying the longest side, median side and shortest side together. These measurements generally correspond to the length, width and height of the item. |
volume-units | The unit of measurement for the volume of the item |
storage-type | Storage type category of the product for which storage limits are set. There are seven storage types: standard-size, oversize, clothing, footwear, flammable, aerosol and extra-large.
Note: Standard-size includes small and standard types.
|
For a dashboard view of inventory age information, go to Manage Inventory Health.