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 |