Amazon Settlement Data → SellingPilot System Help
1. Document Purpose
This document explains:
- How Amazon fee items map to SellingPilot fee categories
- How Amazon TransactionType maps to SellingPilot order types
2. Amazon Settlement Data Structure
Amazon settlement records have a three-part structure:
TransactionType / AmountType / AmountDescription
Examples:
- Order / ItemPrice / Principal
- Refund / ItemFees / Commission
- other-transaction / FBA Inventory Reimbursement / WAREHOUSE_LOST
SellingPilot maps and classifies using this three-part composite key.
3. Amazon → SellingPilot Fee Category Mapping
1. Sales Revenue (SalesAmount)
| Amazon (TransactionType / AmountType / AmountDescription) |
Order Type |
| 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 Type |
| Order / Promotion / Shipping |
Order |
| Refund / Promotion / Shipping |
Refund |
3. Shipping Revenue (ShippingFee)
| Amazon (TransactionType / AmountType / AmountDescription) |
Order Type |
| Order / ItemPrice / Shipping |
Order |
| Order / ItemPrice / ShippingTax |
Order |
| Refund / ItemPrice / Shipping |
Refund |
| Refund / ItemPrice / ShippingTax |
Refund |
4. Other Income (OtherIncome)
| Amazon (TransactionType / AmountType / AmountDescription) |
Order Type |
| 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 |
| Amazon (TransactionType / AmountType / AmountDescription) |
Order Type |
| 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 Type |
| Order / ItemFees / FBAPerUnitFulfillmentFee |
Order |
| Order / ItemFees / ShippingChargeback |
Order |
| Refund / ItemFees / ShippingChargeback |
Refund |
7. Marketing (Marketing)
| Amazon (TransactionType / AmountType / AmountDescription) |
Order Type |
| AmazonFees / Coupon Participation Fee / Base fee |
Order |
8. Advertising (AdvertisingFee)
| Amazon (TransactionType / AmountType / AmountDescription) |
Order Type |
| ServiceFee / Cost of Advertising / TransactionTotalAmount |
Order |
9. Adjustment (AdjustmentFee)
| Amazon (TransactionType / AmountType / AmountDescription) |
Order Type |
| 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) |
Order Type |
| 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 Type |
| Order / ItemFees / VariableClosingFee |
Order |
| Refund / ItemFees / VariableClosingFee |
Refund |
| other-transaction / other-transaction / Shipping label purchase for return |
Order |
| Liquidations / ItemFees / LiquidationsBrokerageFee |
Order |
12. Sales Tax (SalesTax)
| Amazon (TransactionType / AmountType / AmountDescription) |
Order Type |
| 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. Other Taxes (OtherTaxes)
| Amazon (TransactionType / AmountType / AmountDescription) |
System Fee Category |
| Order / ItemWithheldTax / MarketplaceFacilitatorRegulatoryFee-Principal |
OtherTaxes |