本文介绍亚马逊FBA提供的15种库存管理报告，包括报告类型、获取链接及字段定义等内容，帮助卖家理解并利用这些报告来优化库存管理。
目录
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&nb |
扫一扫
7677
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
