本文详细解析了亚马逊每月库存存储费用报告的字段定义、计算方法和收费标准。报告涉及ASIN、FNSKU、产品尺寸、体积、重量等信息，费用依据每日平均库存量、产品尺寸级别和存储月份进行计算。标准尺寸和超大尺寸商品在不同季度的存储费率有所不同，并且对于危险品，费用会更高。此外，最近存储费用每立方英尺增加了0.05美元。
目录
3.Monthly inventory storage fee charge logic
4.Monthly Inventory Storage Fee Change History
The Monthly Storage Fees report provides estimated monthly inventory storage fees for each ASIN of your inventory in Amazon fulfillment centers.
注意:每月的 7th and 15th 出上个月的Monthly storagee fees report
1.Report Field Definitions
| column name | column type | discription |
| asin | varchar(32) | Amazon Standard Identification Numbers (ASINs) |
| fnsku | varchar(32) | Amazon's fulfillment network stock-keeping unit (SKU) identifier. |
| product_name | varchar(512) | Description of the ASIN on the product-detail page. |
| fulfillment_center | varchar(32) | Fulfillment center in which the ASIN is stored. |
| country_code | varchar(32) | Country in which the fulfillment center is located. |
| longest_side | double(16,2) | 最长边边长(包括包装)，单位英寸(inches) |
| median_side | double(16,2) | 第二长边(包括包装)，单位英寸(inches) |
| shortest_side | double(16,2) | 最短边(包括包装)，单位英寸(inches) |
| measurement_units | varchar(32) | 长宽高单位，一般为inches |
| weight | double(16,2) | 体重(包括包装) |
| weight_units | varchar(32) | 体重单位，一般pounds |
| item_volume | double(16,4) | 体积(包括包装) |
| volume_units | varchar(32) | 体积单位，cubic feet (立方英尺) |
| product_size_tier | varchar(32) | product size tier ，分为standard-size 和 over-size |
| average_quantity_on_hand | double(16,2) | (日均库存单位数量)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. |
| average_quantity_pending_removal | double(16,2) | (日均库存remove单位数量)Daily average quantity of items for which removal from the fulfillment center was requested. |
| estimated_total_item_volume | double(16,4) | 日均占用仓库体积，等于 (average_quantity_on_hand - avera ge_quantity_pending_removal) * item_volume Average volume on hand, minus average volume pending removal, multiplied by the volume of the item. |
| month_of_charge | varchar(32) | Month of year in which storage-fee estimate applies; format is YEAR-MONTH. |
| storage_rate | decimal(11,2) | (日均立方英尺每月应收storage fee)Amount of the Monthly Inventory Storage Fee that will apply to this ASIN. |
| currency | varchar(32) | Currency of the storage rate amount. |
| estimated_monthly_storage_fee | decimal(11,4) | (该fulfillment_center应收该asin的月度storage fee，估计值) Estimated monthly storage fee per ASIN. |
| dangerous_goods_storage_type | varchar(32) | 是否危险品及危险品类型，如FLAMMABLES等 |
2.Business and Data Method
说明:monthly storage fee 是根据daily average volume 来计费的，影晌计费的因素还有product size tier 与 存储月份
1)product 体积 item_volume
item_volume = (longest_side * median_side * shortest_side )/1728
#英寸转英尺 ，1英尺等12英寸
2)storage_rate
storage_rate 是该asin 日均1立方英尺每月 估计应收的storage fee ，每个aisn 都是一样的
3)日均占用仓库体积估计值 estimated_total_item_volume
estimated_total_item_volume = (average_quantity_on_hand - average_quantity_pending_removal) * item_volume
4)asin 月度storage fee 估计值 estimated_monthly_storage_fee
estimated_monthly_storage_fee = estimated_total_item_volume * storage_rate
3.Monthly inventory storage fee charge logic
1)Non dangerous goods
| Month | Standard-size | Oversize |
| January - September | $0.75 per cubic foot | $0.48 per cubic foot |
| October - December | $2.40 per cubic foot | $1.20 per cubic foot |
2)dangerous goods
| Month | Standard-size | Oversize |
| January - September | $0.99 per cubic foot | $0.78 per cubic foot |
| October - December | $3.63 per cubic foot | $2.43 per cubic foot |
4.Monthly Inventory Storage Fee Change History
现在每立方英尺又增加 0.05 美元。
| Month | Standard-size | Oversize |
| January - September | $0.75 per cubic foot | $0.48 per cubic foot |
| October - December | $2.40 per cubic foot | $1.20 per cubic foot |
扫一扫
1212
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
