目录
2.FBA Manage Inventory - Archived
3.FBA Daily Inventory History Report
5.FBA Inbound Performance Report
6.FBA Stranded Inventory Report
7.FBA Reserved Inventory Report
8.FBA Amazon Fulfilled Inventory Report
9.FBA Received Inventory Report
10.FBA Inventory Event Detail Report
11.FBA Inventory Adjustments Report
12.FBA Inventory Health Report
14.FBA Monthly Inventory History Report
1.FBA Manage Inventory
(1)Description
- Report Type: _GET_FBA_MYI_UNSUPPRESSED_INVENTORY_DATA_
- Link&Location: https://sellercentral.amazon.com/reportcentral/FBA_MYI_UNSUPPRESSED_INVENTORY/1
该report库存数据为fnsku汇总值,即统计account下所有sales market的每个fnsku的库存总量,主要包括在库库存(可售库存、不可售库存、预留库存)和 在途库存 两部大部分数据,有以下几点注意地方:
- 该report不显示已删listing的库存数据,已archived的listing库存放在“FBA Manage Inventory - Archived”报表中
- 在该report中同一fnsku可能会有多条记录,多条记录或asin不相同或sku不相同,但计算真实库存只能取其中一条
- 假如你的amazon帐号可售market包括US、CA、MX,那么该report会包括这3个market的fnsku库存
说明:
- sales market:指amazon account的可售市场,一般以国家为单位,如US(美国)、CA(加拿大)、MX(墨西哥)
- fnsku:商品在amazon仓库标识id为fnsku,如同人的身份证,同一fnsku表示是相同的商品
(2)Field & Definition
Field Name | Data Type | Definition |
sku | varchar(128) | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify your products. |
fnsku | varchar(32) | Fulfillment Network Stock Keeping Units (FNSKUs) are unique identifiers assigned by Amazon to products stored in and fulfilled from Amazon fulfillment centers. |
asin | varchar(32) | Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. Amazon assigns the ASIN, which you can find on the product-detail page. |
product_name | varchar(512) | The title of your product. |
condition | varchar(32) | The condition of your product. |
listing_price | decimal(11,2) | Your current selling price. |
mfn_listing_exists | varchar(32) | "Yes" indicates that the product is listed for fulfillment by you as the seller. |
mfn_fulfillable_quantity | int(11) | The quantity in your fulfillment network that can be picked, packed, and shipped. |
afn_listing_exists | varchar(32) | "Yes" indicates that the item is listed for Fulfillment by Amazon. |
afn_warehouse_quantity | int(11) | The number of units you have for an SKU in Amazon fulfillment centers that have been processed: (afn-warehouse-quantity) = (afn-fulfillable-quantity) + (afn-unsellable-quantity) + (afn-reserved-quantity). |
afn_fulfillable_quantity | int(11) | The number of units you have for a SKU in Amazon fulfillment centers that can be picked, packed, and shipped. |
afn_unsellable_quantity | int(11) | The number of units you have for a SKU in Amazon fulfillment centers in unsellable condition. |
afn_reserved_quantity | int(11) | The number of units you have for a SKU in Amazon fulfillment centers that are currently being picked, packed, and shipped or are sidelined for measurement, sampling, or other internal processes. |
afn_total_quantity | int(11) | The total number of units you have for a SKU in an inbound shipment or in Amazon fulfillment centers: (afn-total-quantity) = (afn-warehouse-quantity) + (afn-inbound-working-quantity) + (afn-inbound-shipped-quantity) + (afn-inbound-receiving-quantity) |
per_unit_volume | varchar(32) | The volume in cubic feet of one unit (to the nearest 1/100 of an inch). |
afn_inbound_working_quantity | int(11) | The number of units you have for a SKU in an inbound shipment that you have notified Amazon about. |
afn_inbound_shipped_quantity | int(11) | The number of units you have for a SKU in an inbound shipment that you have notified Amazon about and provided a tracking number. |
afn_inbound_receiving_quantity | int(11) | The number of units you have for a SKU that have not yet been received at an Amazon fulfillment center for processing, but are part of an inbound shipment with some units that have already been received and processed. |
afn_researching_quantity | int(11) | 商品放错了仓库 或 损坏,目前正在调查,30天内会调查完并对库存数据进行调整 |
afn_reserved_future_supply | int(11) | The number of units that customers have purchased while inventory is on its way to an Amazon fulfillment center through In-Stock Head Start. |
afn_future_supply_buyable | int(11) | The number of units available for customers to find and buy while inventory is on its way to an Amazon fulfillment center through In-Stock Head Start. |
2.FBA Manage Inventory - Archived
(1)Description
- Report Type: _GET_FBA_MYI_ALL_INVENTORY_DATA_
- Link&Location: https://sellercentral.amazon.com/reportcentral/FBA_MYI_ALL_INVENTORY/1
"FBA Manage Inventory - Archived" report 与 "FBA Manage Inventory" report 相似,不同之处:除了包含"FBA Manage Inventory" report 所有数据处,还包含已archived listing的库存数据
(2)Field & Definition
Field Name | Data Type | Definition |
sku | varchar(128) | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify your products. |
fnsku | varchar(32) | Fulfillment Network Stock Keeping Units (FNSKUs) are unique identifiers assigned by Amazon to products stored in and fulfilled from Amazon fulfillment centers. |
asin | varchar(32) | Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. Amazon assigns the ASIN, which you can find on the product-detail page. |
product_name | varchar(512) | The title of your product. |
condition | varchar(32) | The condition of your product. |
listing_price | decimal(11,2) | Your current selling price. |
mfn_listing_exists | varchar(32) | "Yes" indicates that the product is listed for fulfillment by you as the seller. |
mfn_fulfillable_quantity | int(11) | The quantity in your fulfillment network that can be picked, packed, and shipped. |
afn_listing_exists | varchar(32) | "Yes" indicates that the item is listed for Fulfillment by Amazon. |
afn_warehouse_quantity | int(11) | The number of units you have for an SKU in Amazon fulfillment centers that have been processed: (afn-warehouse-quantity) = (afn-fulfillable-quantity) + (afn-unsellable-quantity) + (afn-reserved-quantity). |
afn_fulfillable_quantity | int(11) | The number of units you have for a SKU in Amazon fulfillment centers that can be picked, packed, and shipped. |
afn_unsellable_quantity | int(11) | The number of units you have for a SKU in Amazon fulfillment centers in unsellable condition. |
afn_reserved_quantity | int(11) | The number of units you have for a SKU in Amazon fulfillment centers that are currently being picked, packed, and shipped or are sidelined for measurement, sampling, or other internal processes. |
afn_total_quantity | int(11) | The total number of units you have for a SKU in an inbound shipment or in Amazon fulfillment centers: (afn-total-quantity) = (afn-warehouse-quantity) + (afn-inbound-working-quantity) + (afn-inbound-shipped-quantity) + (afn-inbound-receiving-quantity) |
per_unit_volume | varchar(32) | The volume in cubic feet of one unit (to the nearest 1/100 of an inch). |
afn_inbound_working_quantity | int(11) | The number of units you have for a SKU in an inbound shipment that you have notified Amazon about. |
afn_inbound_shipped_quantity | int(11) | The number of units you have for a SKU in an inbound shipment that you have notified Amazon about and provided a tracking number. |
afn_inbound_receiving_quantity | int(11) | The number of units you have for a SKU that have not yet been received at an Amazon fulfillment center for processing, but are part of an inbound shipment with some units that have already been received and processed. |
afn_researching_quantity | int(11) | 商品放错了仓库 或 损坏,目前正在调查,30天内会调查完并对库存数据进行调整 |
afn_reserved_future_supply | int(11) | The number of units that customers have purchased while inventory is on its way to an Amazon fulfillment center through In-Stock Head Start. |
afn_future_supply_buyable | int(11) | The number of units available for customers to find and buy while inventory is on its way to an Amazon fulfillment center through In-Stock Head Start. |
3.FBA Daily Inventory History Report
(1)Description
- Report Type: _GET_FBA_FULFILLMENT_CURRENT_INVENTORY_DATA_
- Link&Location: https://sellercentral.amazon.com/reportcentral/INVENTORY_SNAPSHOT/0
该report为所有卖家商品在零点时刻在amazon各fulfillment-center的统计数据,注意:库存为0的商品是不会在该report中有数据
(2)Field & Definition
Field Name | Data Type | Definition |
start_date | date | start_date |
end_date | date | end_date |
snapshot_date | datetime | Date of request |
fnsku | varchar(32) | Amazon's Fulfillment Network SKU identifier |
sku | varchar(128) | Seller's product identifier |
product_name | varchar(512) | Product title |
quantity | int(11) | Total units available on hand for this product in an Amazon's fulfillment center |
fulfillment_center_id | varchar(32) | Fulfillment center where inventory is stored |
detailed_disposition | varchar(128) | Status of the product (examples: sellable, damaged, etc) |
country | varchar(32) | Code of country where the inventory is stored |
uds_load_date | date | the date for data loading into uds |
4.Restock Inventory Report
(1)Description
- Report Type: _GET_RESTOCK_INVENTORY_RECOMMENDATIONS_REPORT_
- Link&Location: https://sellercentral.amazon.com/gp/help/202105670?ref_=xx_swlang_head_^&mons_sel_locale=en_US&languageSwitched=1
提供有关待补货商品、补货数量和发货日期方面的建议。该报告有助于您随时掌握库存情况,在确保商品供货充足的同时避免库存积压,从而最大限度地提升销量。
(2)Field & Definition
Field name | Description |
Country/region code | The country associated with this MSKU |
Product name | The title of your product |
FNSKU | Amazon's fulfillment network stock keeping unit (SKU) identifier |
MSKU | Merchant stock keeping units (MSKUs) are unique blocks of letters or numbers that identify your products. MSKUs are assigned by you as the seller. |
ASIN | |
Condition | The condition of the unit (new, used, etc.) |
Supplier | Whether the product has been enrolled in Small and Light 商品是否已注册轻小商品计划。 |
Supplier part no. | The part number used by the supplier to identify the item. You provide this on the SKU details page.供应商用以识别商品的零件编号。您可以在 SKU 详情页面提供此信息。 |
Currency code | The currency used for this MSKU |
Price | Your listed price |
Sales last 30 days (sales) | Amount sold in the last 30 days |
Sales last 30 days (units) | Units sold in the last 30 days |
Total inventory | Total inventory equals all inventory that is available, shipped, and reserved fulfillment center transfer. |
Inbound inventory | The number of units that you have for a SKU in a shipment about which you have notified Amazon, for which you have provided a tracking number, or that has arrived at a fulfillment center for processing. |
Available Inventory | The number of units you have for a SKU in fulfillment centers that can be picked, packed, and shipped |
FC transfer | The number of units being transferred from one fulfillment center to another 正在从一个运营中心转运至另一运营中心的商品数量。 |
FC processing | The number of units that have been sidelined at a fulfillment center for additional processing存放在运营中心内需要进行额外处理的商品数量。 |
Customer order | The number of units reserved for customer orders为买家订单预留的商品数量。 |
Unfulfillable | The number of units that are in fulfillment centers, but not in a condition that can be sold 存放在亚马逊运营中心但不可出售的商品数量。 |
Fulfilled by | Indicates whether the product is listed for fulfillment by Amazon or by you as the seller. 表明发布的商品是由亚马逊配送还是由卖家自行配送。 |
Days of supply | The estimated number of days that your current inventory supply will last based on the projected demand for your product 根据商品的预期需求估算的您当前库存能够持续供货的天数。 |
Instock alert | Indicates if your product is low or out of stock. Low stock identifies items for which the days of supply is less than lead time, which indicates that orders from your supplier may need to be expedited in order to avoid going out of stock. |
Recommended replenishment quantity | The recommendation for the number of units to be restocked for FBA 针对亚马逊物流要补货的商品数量的建议。 |
Recommended ship date | The suggested date to ship the product to avoid running low or going out of stock, based on your estimated days of supply and lead time 根据预计供货天数和交期建议的配送商品的日期,以避免少货或缺货。 |
Inventory level thresholds published - current month | Indicates whether the FNSKU has an inventory level threshold published. Published only for products with limited restock. 表明 FNSKU 是否有已发布的库存水平阈值。仅针对有补货数量限制的商品发布。 |
Current month - very low inventory threshold | N/A |
Current month - minimum inventory threshold | N/A |
Current month - maximum inventory threshold | N/A |
Current month - very high inventory threshold | N/A |
Inventory level thresholds published - next month | N/A |
Next month - very low inventory threshold | N/A |
Next month - minimum inventory threshold | N/A |
Next month - maximum inventory threshold | N/A |
Next month - very high inventory threshold | N/A |
Utilization | N/A |
Max shipment quantity | N/A |
5.FBA Inbound Performance Report
(1)Description
- Report Type: _GET_FBA_FULFILLMENT_INBOUND_NONCOMPLIANCE_DATA_
- Link&Location: https://sellercentral.amazon.com/reportcentral/INBOUND_NONCOMPLIANCE/0
入库问题报告针对我们在运营中心遇到的与您的亚马逊物流货件相关的问题提供货件级详细信息。
(2)Field & Definition
Field Name | Description |
issue-reported-date | Date the shipment problem was reported. |
shipment-creation-date | The date you created the shipment. |
fba-shipment-id | Shipment ID in which the problem was identified. |
fba-carton-id | Box ID in which the problem was identified |
fulfillment-center-id | The fulfillment center where the problem is identified |
problem-level | The level of problem. One of the following: Units / Shipment |
problem-type | The type of problem identified, for example: Barcode cannot be scanned / Item label missing |
problem-quantity | Number of units to which the problem applies |
expected-quantity | The number of units we expected to receive at the fulfillment center. |
received-quantity | The number of units we received at the fulfillment center. |
performance-measurement-unit | The unit of measurement for the particular problem type. 特定问题类型的测评单位。 For example, whether the problem occurred at the unit, box, or shipment level |
sku | Stock keeping units (SKUs) are unique blocks of letters or numbers that identify your products. You, as the seller, assign SKUs. |
fnsku | Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center. |
asin |
|
product-name | The title of your product |
alert-status | Indicates whether the problem has been acknowledged. |
coaching-level | The coaching level for a particular problem group. One of the following: Standard / Elevated / Critical |
fee-type | One of the following: Unplanned Service fee / Unplanned Service fee (preview) / Exempt / Refund |
fee-total | The total Unplanned Service fees charged |
6.FBA Stranded Inventory Report
(1)Description
- Report Type: _GET_STRANDED_INVENTORY_UI_DATA_
- Link&Location: https://sellercentral.amazon.com/gp/help/201835130
Stranded inventory is inventory in a fulfillment center that does not have an active offer on Amazon. Stranded inventory report shows a breakdown of units in your inventory that are in stranded status.
(2)Field & Definition
Field name | Description |
---|---|
primary-action | Action needed to bring your inventory out of stranded status. The possible actions are:
|
date-stranded | This date shows how long your inventory has been stranded and without an active offer. |
date-classified-as-unsellable | This is the date when the inventory will be classified as unsellable unless the offer is made buyable. You are required to remove unsellable units (which are “Unsuitable Units” as defined in the Amazon Services Business Solutions Agreement) as described in our Required removals policy. 此日期是库存将被归类为不可售的日期(除非将商品变成可售状态)。根据我们的按要求移除政策,您需要移除不可售商品(即《亚马逊服务商业解决方案协议》中规定的“不适宜商品”)。 |
status-primary | Identifies whether the offer is active, inactive, or incomplete. Incomplete offers are those missing price or condition. 指明商品处于在售状态、非在售状态还是商品信息不完整状态。商品信息不完整指的是缺少商品价格或状况描述。 |
status-secondary | For inactive offers, this field identifies the reasons — for example, blocked or out of stock. 对于非在售商品,该字段用于说明原因,例如已冻结或缺货。 |
error-message | For select inactive offers, additional information is displayed here — for example, quality alerts. 对于一些非在售商品,此处还会显示一些附加信息,例如数量提醒。 |
asin | Unique blocks of 10 letters or numbers that Amazon assigns to identify products. You can find the ASIN on the product details page. |
sku | Unique blocks of letters or numbers that you assign to identify your products |
fnsku | Unique identifiers that Amazon assigns to items stored in and fulfilled from a fulfillment center |
product-name | The name of your product |
condition | The condition of your product |
fulfilled-by | Indicates whether the product is listed for fulfillment by Amazon or by you. |
fulfillable-quantity | The number of units of a SKU that you have in Amazon fulfillment centers and that can be picked, packed, and shipped |
your-price | Your current selling price |
unfulfillable-qty | The number of units of a SKU that you have in Amazon fulfillment centers and that are in unsellable condition |
reserved-quantity | The number of units of a SKU that you have in Amazon fulfillment centers and that are currently being picked, packed, and shipped or that are sidelined for measurement, sampling, or other internal processes |
inbound-shipped-qty | The number of units of a SKU that you have shipped to Amazon and that are in transit |
7.FBA Reserved Inventory Report
(1)Description
- Report Type: _GET_RESERVED_INVENTORY_DATA_
- Link&Location: https://sellercentral.amazon.com/gp/help/201723860
注意:该report实时更新,只提供最新snapshot
This report shows a breakdown of units in your inventory that are in reserved status.
Inventory in reserved status might be tied to a customer order in the process of being shipped between fulfillment centers, or set aside at a fulfillment center for additional processing. If your inventory is being shipped to another fulfillment center, it is still available for purchase with the message "Back-ordered. Due in stock..." and a date based on the estimated arrival at the fulfillment center.
(2)Field & Definition
Download Header | Description |
---|---|
sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify your products. SKUs are assigned by you as the seller. |
fnsku | Unique identifier assigned by Amazon to items stored in and fulfilled from an Amazon fulfillment center. |
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. |
product-name | The title of your product. |
reserved_qty | The total number of units in reserved status. |
reserved_customerorders | The number of units reserved for customer orders. |
reserved_fc-transfers | The number of units being transferred from one fulfillment center to another. |
reserved_fc-processing | The number of units that have been sidelined at the fulfillment center for additional processing. |
8.FBA Amazon Fulfilled Inventory Report
(1)Description
- Report Type: _GET_AFN_INVENTORY_DATA_
- Link&Location: https://sellercentral.amazon.com/gp/help/200453180
注意:该report实时更新,只提供最新snapshot
This report shows a near real-time snapshot of your inventory in Amazon’s fulfillment centers at the time the report is run.
Since customers can purchase your products at any time, the quantities in an inventory report are at best a spot check of your saleable inventory, and may be out of date almost as soon as the report is requested. To reconcile your inventory levels, compare your Amazon orders and inventory reports to your own inventory records. If you reconcile your inventory through automation, use the Inventory APIs available through our Amazon MWS Fulfillment APIs instead.
(2)Field & Definition
Download Header | Description | Example |
---|---|---|
seller-sku | Stock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller. | 154844 |
fulfillment-channel-sku | Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center. | X00000E5TX |
ASIN | Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters and/or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page. | 0312306180 |
condition-type | The condition of your inventory. | New |
warehouse-condition-code | Code assigned in Amazon's fulfillment center to listings matching the ASIN and the seller's condition-type. | SELLABLE |
quantity-available | The quantity of the product available for purchase. | 15 |
9.FBA Received Inventory Report
(1)Description
- Report Type: _GET_FBA_FULFILLMENT_INVENTORY_RECEIPTS_DATA_
- Link&Location: https://sellercentral.amazon.com/gp/help/200453220
This report shows inventory that has completed the receive process at Amazon's fulfillment centers.
(2)Field & Definition
Download header | Description |
---|---|
received-date | Date the receive process was completed for the shipment, DD-MON-YYYY |
fnsku | Amazon’s Fulfillment network SKU identifier |
sku | Seller's item identifier |
product-name | Product title |
quantity | Total units received of this item in the shipment Note: If a negative number appears in this field, an adjustment has been made to a quantity previously reported. |
fba-shipment-id | ID for the shipment |
fulfillment-center-id | Fulfillment center receiving merchandise |
10.FBA Inventory Event Detail Report
(1)Description
- Report Type: _GET_FBA_FULFILLMENT_INVENTORY_SUMMARY_DATA_
- Link&Location: https://sellercentral.amazon.com/gp/help/200453240
This report shows a history of inventory events (such as receipts, shipments, and adjustments) by SKU and fulfillment center.
注意:只提供近18个月的历史数据
(2)Field & Definition
Download header | Description |
---|---|
snapshot-date | Date of request |
fnsku | Amazon's fulfillment network SKU identifier |
sku | Seller's product identifier |
product-name | Product title |
quantity | Total units available on hand for this product in an Amazon fulfillment center |
fulfillment-center-id | Fulfillment center where inventory is stored |
detailed-disposition | Status of the product (examples: sellable, damaged) |
transaction-type | Type of transaction causing the change (shipment, receipt, vendor return, warehouse transfer, adjustment, or customer return) |
11.FBA Inventory Adjustments Report
(1)Description
- Report Type: _GET_FBA_FULFILLMENT_INVENTORY_ADJUSTMENTS_DATA_
- Link&Location: https://sellercentral.amazon.com/gp/help/200453260
shows the history of adjustments to your inventory in response to issues such as disposition changes, misplaced inventory, found inventory, and ownership corrections.
(2)Field & Definition
Download header | Description |
---|---|
adjustment-date | DD-MM-YYYY |
transaction-item-id | Unique ID for this item adjustment |
fnsku | Unique item ID assigned by Amazon and used by the fulfillment center |
sku | Unique item ID assigned by the seller |
product-name | Name of the product as listed on Amazon |
fulfillment-center-id | Fulfillment center where the adjustment is being made |
quantity | Number of units adjusted |
reason | The download file displays codes while the online view shows descriptions. See the Adjustment types and reason codes table at the top of this page for full codes and descriptions. |
disposition | Whether the item is in sellable or unsellable/unfulfillable condition |
Reconciled | Number of units reconciled with other adjustment events |
Unreconciled | Number of units not reconciled with other adjustment events |
12.FBA Inventory Health Report
(1)Description
- Report Type: _GET_FBA_FULFILLMENT_INVENTORY_HEALTH_DATA_
- Link&Location: https://sellercentral.amazon.com/gp/help/200537120
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.)
(2)Field & Definition
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 | 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 | 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 |
product-name | The title of your product | Toysmith Nonstick Bakeware Set |
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. | 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 |
unsellable-quantity | The number of units you have for a SKU in unsellable condition in our fulfillment network | 1 |
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 |
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 |
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 |
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 are eligible for the LTSF charge. As of February 2019, standard FBA units will not be charged 180-day LTSF. For example, FBA Small and Light fees are not affected by the February 2019 fee change. For more details, see the Program Fees section of FBA Small and Light. | 400 |
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 LTSF charge date (monthly on the 15th in the US; February 15th and August 15th in Canada) | 400 |
qty-in-long-term-storage-program | The number of sellable units that have previously been charged the Long-Term Storage Fee | 500 |
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. As of February 2019, standard FBA units will not be charged 180-day LTSF. For example, FBA Small and Light fees are not affected by the February 2019 fee change. For more details, see the Program Fees section of FBA Small and Light. | 500 |
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 LTSF charge date (monthly on the 15th in the US; February 15th and August 15th in Canada) | 500 |
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 | 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-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 | USD |
your-price | Your current selling price | 10.25 |
sales-price | Your current promotional price | 4.00 |
lowest-afn-new-price | The lowest fulfilled by Amazon price for items in New condition, including any offers from Amazon | 11.75 |
lowest-afn-used-price | The lowest FBA price for items in Used condition | 4.99 |
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-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 footage of each inventory unit | 0.23 |
inbound-quantity | Quantity of units that are recorded in inbound shipments to Amazon fulfillment centers. | 10 |
inbound-recommended quantity | Your recommended inbound quantity for the next eight weeks | 7 |
asin-limit | Your inventory limit for ASINs where we apply an inventory capacity limit. Please see ASIN Quantity Limits for more information. | 42 |
is-hazmat | If your ASIN is considered Hazmat. Please see Hazardous Materials (Hazmat) to see if your products qualify. | Yes |
13.FBA Inventory Age Report
(1)Description
- Report Type: _GET_FBA_INVENTORY_AGED_DATA_
- Link&Location: https://sellercentral.amazon.com/gp/help/201979220
A downloaded Inventory Age report helps you quickly identify how long items in your inventory have been in fulfillment centers and those items 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 fulfilled-by-Amazon inventory.
(2)Field & Definition
Field name | Description |
---|---|
snapshot-date | The date the report was generated |
sku | Unique blocks of letters and numbers that are assigned by you to the product you are selling |
fnsku | Unique blocks of letters and numbers that are assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
asin | Unique blocks of 10 letters or numbers assigned by Amazon to the products sold through Amazon |
product-name | The name of your product |
condition | The condition of the unit (new, used, etc.) |
available-quantity(sellable) | The number of units in inventory available for purchase |
qty-with-removals-in-progress | The number of units in inventory that you have requested be returned to you or disposed of |
inv-age-0-to-90-days | The number of sellable units that have been in the fulfillment center for the last 0-90 days |
inv-age-91-to-180-days | The number of sellable units that have been in the fulfillment center for the last 91-180 days |
inv-age-181-to-270-days | The number of sellable units that have been in the fulfillment center for the last 181-270 days |
inv-age-271-to-365-days | The number of sellable units that have been in the fulfillment center for the last 271-365 days |
inv-age-365-plus-days | The number of sellable units that have been in the fulfillment center for the last 365+ days |
currency | The currency for the estimated long-term storage fee charge |
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 are eligible for the 180-day LTSF charge. For example, FBA Small and Light products are subject to this 180-day LTSF charge. (As of February 2019, standard FBA units will not be charged 180-day long term storage fees.) |
projected-ltsf-6-mo | The projected long-term storage fee for units that have been in fulfillment centers for 180 to 365 days on the next charge date. |
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 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 fulfillment centers for more than 365 days on the next charge date (monthly on the 15th) |
units-shipped-last-7-days | Units sold in the last 7 days |
units-shipped-last-30-days | Units sold in the last 30 days |
units-shipped-last-60-days | Units sold in the last 60 days |
units-shipped-last-90-days | Units sold in the last 90 days |
alert | Shows when this item has a low traffic or low conversion alert Low traffic indicates that a low number of potential buyers have seen the listings. Use the Improve Keywords feature in the actions list to optimize your listing for search. 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 do not follow through to purchase the product. Ensuring a high quality detail page and pricing competitively helps 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 at the time the report is 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 Buy Box 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 likely help you sell through 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 3-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 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 fulfillment centers 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 | 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 six storage types: standard-size, oversize, apparel, footwear, flammable or aerosol. Note: standard-size is including small and standard types. |
14.FBA Monthly Inventory History Report
(1)Description
- Report Type: _GET_FBA_FULFILLMENT_MONTHLY_INVENTORY_DATA_
- Link&Location: https://sellercentral.amazon.com/gp/help/200490420
This report shows monthly inventory in Amazon's fulfillment centers including quantity, location, and disposition. View the Monthly Inventory report.
(2)Field & Definition
Download Header | Description |
---|---|
snapshot-date | Month |
Fnsku | Amazon's Fulfillment network SKU identifier |
Sku | Seller's item identifier |
product-name | Product title |
avg-quantity | Daily average units available on hand for this item in Amazon's fulfillment centers |
end-quantity | Number of units remaining in Amazon's fulfillment centers at the end of the month |
fulfillment-center-id | Fulfillment center where inventory is stored |
detailed-disposition | Status of the item (examples sellable, damaged, and so on) |
15.FBA Storage Fees Report
(1)Description
- Report Type: _GET_FBA_STORAGE_FEE_CHARGES_DATA_
- Link&Location: https://sellercentral.amazon.com/gp/help/202086720
provides estimated monthly inventory storage fees for each ASIN of your inventory in Amazon fulfillment centers.
(2)Field & Definition
Download header | Description | Example value |
---|---|---|
asin | Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. Amazon assigns the ASIN, which you can find on the product-detail page. | 0991519108 |
fnsku | Amazon's fulfillment network stock-keeping unit (SKU) identifier. | X000A8GG1A |
product-name | Description of the ASIN on the product-detail page. | Stylish hat for pets |
fulfillment-center | Fulfillment center in which the ASIN is stored. | FTW3 |
country-code | Country in which the fulfillment center is located. | US |
longest-side | The dimensions of the longest side of a single unit of the item. | 8.43 |
median-side | The dimensions of the side of a single unit of the item that is neither the longest nor the shortest. The Inventory Storage Fee is charged by volume in cubic feet, which equals the longest side x median side x shortest side. These often correspond to the length, width, and height of an item. | 5.81 |
shortest-side | The dimensions of the shortest side of a single unit of the item. The Inventory Storage Fee is charged by volume in cubic feet, which equals the longest side x median side x shortest side. These often correspond to the length, width, and height of an item. | 0.73 |
measurement-units | Unit of measurement for the longest, median, and shortest sides of the item for purposes of calculating the Inventory Storage Fee. | inches |
weight | The item's weight used to identify its product-size tier. This can be the item's unit weight or dimensional weight, depending on the item. | 0.79 |
weight-units | Unit of measurement for the weight of the item. | pounds |
item-volume | The Inventory Storage Fee is charged per volume in cubic feet, which equals the longest side x median side x shortest side. These often correspond to the length, width, and height of an item. | 0.0208 |
volume-units | Unit of measurement for the volume of the item. | cubic feet |
product-size-tier | Classification of the item by its dimensions for purposes of calculating fees. | Standard-sized or Oversize |
average-quantity-on-hand | Daily average quantity of the item in fulfillment centers. This is equal to the inventory for the trailing month divided by the number of days in that month. | 0.71 |
average-quantity-pending-removal | Daily average quantity of items for which removal from the fulfillment center was requested. | 0.0 |
estimated-total-item-volume | Average volume on hand, minus average volume pending removal, multiplied by the volume of the item. | 0.0148 |
month-of-charge | Month of year in which storage-fee estimate applies; format is YEAR-MONTH. | 2016-07 |
storage-rate | Amount of the Monthly Inventory Storage Fee that will apply to this ASIN. | 0.51 |
estimated-monthly-storage-fee | Estimated monthly storage fee per ASIN. | 5.373 |
currency | Currency of the storage rate amount. | USD |