amazon - sellercentral 之 sellercentral report - fee preview report

目录

1.Report Field Definitions

2.Business and Data Method

---

The Fee Preview report shows the estimated Selling on Amazon and Fulfillment fees for your current FBA inventory. 

1.Report Field Definitions

column name	column type	discription
sku	varchar(128)
fnsku	varchar(32)
asin	varchar(32)
product_name	varchar(512)
product_group	varchar(128)	The Amazon department or category
brand	varchar(128)	The brand of your product
fulfilled_by	varchar(32)	发货方式，fba 或 fbm
listing_price	decimal(11,2)	Your current selling price
sales_price	decimal(11,2)	Your current promotional price
longest_side	double(16,2)
median_side	double(16,2)
shortest_side	double(16,2)
length_and_girth	double(16,2)	girth= 2 x (median side + shortest side) length_and_girth = longest_side + girth
unit_of_dimension	varchar(32)	长宽高单位，一般为inches 英寸
item_package_weight	double(16,2)	The weight of the product including its packaging
unit_of_weight	varchar(32)	体重单位，一般为pound 英磅
product_size_tier	varchar(32)	The size tier assigned to your product by FBA based on its dimensions and weight
currency	varchar(32)	The currency in which the fee is calculated
estimated_fee_total	decimal(11,2)	The estimated fulfillment and Selling on Amazon fee
estimated_referral_fee_per_unit	decimal(11,2)	平台销售佣金The estimated Selling on Amazon Referral Fee
estimated_variable_closing_fee	decimal(11,2)	BDMV类产品收取$1.8每item
estimated_order_handling_fee_per_order	decimal(11,2)	订单处理费，The estimated Order Handling Fee per order
estimated_pick_pack_fee_per_unit	decimal(11,2)	分拣包装费，按件收，The estimated Pick & Pack Fee
estimated_weight_handling_fee_per_unit	decimal(11,2)	称重处理费，The estimated Weight Handling Fee for your product based on the Outbound Shipping Weight
expected_fulfillment_fee_per_unit	decimal(11,2)	The estimated  fulfillment fee

 

2.Business and Data Method

1)estimated_fee_total

• estimated_fee_total =selling fee (销售佣金) + fba fee (运费)
• selling fee = estimated_referral_fee_per_unit + estimated_variable_closing_fee + estimated_order_handling_fee_per_order
• fba fee = estimated_pick_pack_fee_per_unit + estimated_weight_handling_fee_per_unit + expected_fulfillment_fee_per_unit

 

2)Selling Fee

[1]estimated_referral_fee_per_unit

• 平台销售佣金，根据产品category不同而不同 ，most between 8% and 15%.

[2]estimated_variable_closing_fee

• 如果产品是Books, DVD, Music, Software & Computer/Video Games, Video, Video Game Consoles, and Video Game Accessories这些类目，每 item 收取 $1.80

[3]estimated_order_handling_fee_per_order

• 订单处理费，数值一般为null

 

3)FBA Fee

[1]estimated_pick_pack_fee_per_unit

• 分拣包装费，按产品个数收取，数值一般为null

[2]estimated_weight_handling_fee_per_unit

• 称重处理费，基于产品的尺寸和重量来收取，数值一般为null

[3]expected_fulfillment_fee_per_unit

• 发货运输费

 

注意：亚马逊自2017 年 2 月 22 日起，“订单处理费”、“取件及包装费用”和“首重和续重费(称重处理费)”将合并为单独的配送费用，即 estimated_order_handling_fee_per_order 、estimated_pick_pack_fee_per_unit 、estimated_weight_handling_fee_per_unit 3字段数值都为null ，但它们费用都合并到了expected_fulfillment_fee_per_unit中