Amazon 结算数据 → SellingPilot 系统 帮助文档
一、文档目的
本文档用于说明：
- Amazon 费用项如何映射到 SellingPilot 费用科目
- Amazon TransactionType 如何映射到 SellingPilot 订单类型
二、Amazon 结算数据结构说明
Amazon 结算记录由三段结构组成：
TransactionType / AmountType / AmountDescription
示例：
Order / ItemPrice / Principal
Refund / ItemFees / Commission
other-transaction / FBA Inventory Reimbursement / WAREHOUSE_LOST
SellingPilot 通过三段组合键进行映射归类。
三、Amazon → SellingPilot 费用科目映射
1. 销售收入（SalesAmount）
| Amazon 原始项(TransactionType / AmountType / AmountDescription) |
订单类型 |
| Order / ItemPrice / Principal |
Order |
| Order / ItemPrice / Tax |
Order |
| Refund / ItemPrice / Principal |
Refund |
| Refund / ItemPrice / Tax |
Refund |
| A-to-z Guarantee Refund / ItemPrice / Principal |
OnlyRefund |
| A-to-z Guarantee Refund / ItemPrice / Tax |
OnlyRefund |
| Chargeback Refund / ItemPrice / Principal |
Chargeback Refund |
| Chargeback Refund / ItemPrice / Tax |
Chargeback Refund |
2. 折扣（Discounts）
| Amazon 原始项(TransactionType / AmountType / AmountDescription) |
订单类型 |
| Order / Promotion / Shipping |
Order |
| Refund / Promotion / Shipping |
Refund |
3. 运费收入（ShippingFee）
| Amazon 原始项(TransactionType / AmountType / AmountDescription) |
订单类型 |
| Order / ItemPrice / Shipping |
Order |
| Order / ItemPrice / ShippingTax |
Order |
| Refund / ItemPrice / Shipping |
Refund |
| Refund / ItemPrice / ShippingTax |
Refund |
4. 其他收入（OtherIncome）
| Amazon 原始项(TransactionType / AmountType / AmountDescription) |
订单类型 |
| Order / ItemPrice / RegulatoryFee |
Order |
| Refund / ItemPrice / RegulatoryFee |
Refund |
| Refund / ItemPrice / RestockingFee |
Refund |
| other-transaction / FBA Inventory Reimbursement / MISSING_FROM_INBOUND |
Order |
| other-transaction / FBA Inventory Reimbursement / WAREHOUSE_DAMAGE |
Order |
| other-transaction / FBA Inventory Reimbursement / WAREHOUSE_LOST |
Order |
| other-transaction / FBA Inventory Reimbursement / REVERSAL_REIMBURSEMENT |
Order |
| other-transaction / FBA Inventory Reimbursement / FREE_REPLACEMENT_REFUND_ITEMS |
Order |
| SAFE-T Reimbursement / Other transactions / SAFE-T reimbursement |
Refund |
| Liquidations / ItemPrice / Principal |
Order |
5. 平台佣金（Commission）
| Amazon 原始项(TransactionType / AmountType / AmountDescription) |
订单类型 |
| Order / ItemFees / Commission |
Order |
| Refund / ItemFees / Commission |
Refund |
| Refund / ItemFees / RefundCommission |
Refund |
| A-to-z Guarantee Refund / ItemFees / Commission |
OnlyRefund |
| A-to-z Guarantee Refund / ItemFees / RefundCommission |
OnlyRefund |
| Chargeback Refund / ItemFees / Commission |
Chargeback Refund |
| Chargeback Refund / ItemFees / RefundCommission |
Chargeback Refund |
| Amazon 原始项(TransactionType / AmountType / AmountDescription) |
订单类型 |
| Order / ItemFees / FBAPerUnitFulfillmentFee |
Order |
| Order / ItemFees / ShippingChargeback |
Order |
| Refund / ItemFees / ShippingChargeback |
Refund |
7. 营销费用（Marketing）
| Amazon 原始项(TransactionType / AmountType / AmountDescription) |
订单类型 |
| AmazonFees / Coupon Participation Fee / Base fee |
Order |
8. 广告费（AdvertisingFee）
| Amazon 原始项(TransactionType / AmountType / AmountDescription) |
订单类型 |
| ServiceFee / Cost of Advertising / TransactionTotalAmount |
Order |
9. 调整费用（AdjustmentFee）
| Amazon 原始项(TransactionType / AmountType / AmountDescription) |
订单类型 |
| other-transaction / other-transaction / Adjustment |
Order |
| other-transaction / other-transaction / Current Reserve Amount |
Order |
| other-transaction / other-transaction / Previous Reserve Amount Balance |
Order |
| other-transaction / FBA Inventory Reimbursement / MISSING_FROM_INBOUND_CLAWBACK |
Order |
| other-transaction / other-transaction / MiscAdjustment |
Order |
| Amazon 原始项(TransactionType / AmountType / AmountDescription) |
订单类型 |
| other-transaction / other-transaction / RemovalComplete |
Order |
| other-transaction / other-transaction / FBA Inbound Placement Service Fee |
Order |
| other-transaction / other-transaction / Storage Fee |
Order |
| Amazon 原始项(TransactionType / AmountType / AmountDescription) |
订单类型 |
| Order / ItemFees / VariableClosingFee |
Order |
| Refund / ItemFees / VariableClosingFee |
Refund |
| other-transaction / other-transaction / Shipping label purchase for return |
Order |
| Liquidations / ItemFees / LiquidationsBrokerageFee |
Order |
12. 销售税（SalesTax）
| Amazon 原始项(TransactionType / AmountType / AmountDescription) |
订单类型 |
| Order / ItemWithheldTax / MarketplaceFacilitatorTax-Principal |
Order |
| Order / ItemWithheldTax / MarketplaceFacilitatorTax-Shipping |
Order |
| Refund / ItemWithheldTax / MarketplaceFacilitatorTax-Principal |
Refund |
| Refund / ItemWithheldTax / MarketplaceFacilitatorTax-Shipping |
Refund |
| Refund / ItemWithheldTax / MarketplaceFacilitatorRegulatoryFee-Principal |
Refund |
| A-to-z Guarantee Refund / ItemWithheldTax / MarketplaceFacilitatorTax-Principal |
OnlyRefund |
| A-to-z Guarantee Refund / ItemWithheldTax / MarketplaceFacilitatorTax-Shipping |
OnlyRefund |
| Chargeback Refund / ItemWithheldTax / MarketplaceFacilitatorTax-Principal |
Chargeback Refund |
| Chargeback Refund / ItemWithheldTax / MarketplaceFacilitatorTax-Shipping |
Chargeback Refund |
| Order_Retrocharge / ItemPrice / Tax |
Order |
| Order_Retrocharge / ItemPrice / ShippingTax |
Order |
| Order_Retrocharge / ItemWithheldTax / MarketplaceFacilitatorTax-Principal |
Order |
13. 其他税费（OtherTaxes）
| Amazon 原始项(TransactionType / AmountType / AmountDescription) |
系统费用科目 |
| Order / ItemWithheldTax / MarketplaceFacilitatorRegulatoryFee-Principal |
OtherTaxes |