Newegg Settlement Data → SellingPilot Mapping Help

---

1. Document Purpose

This document explains:

1. How Newegg fee items map to SellingPilot fee categories
2. How Newegg TransactionType maps to SellingPilot order types

---

2. Order Type Reference

Order Type	Description
Order	Regular order
Refund	Refund order
OnlyRefund	Refund only
Chargeback Refund	Chargeback refund
Other	Non-order fund movements

---

3. Fee Mapping Details

---

1. Sales Revenue (SalesAmount)

TransactionType	Amount Field	Order Type
Order	Amount	Order
Refund	Amount	Refund

---

2. Shipping Revenue (ShippingFee)

TransactionType	Amount Field	Order Type
Order	Shipping	Order
Refund	Shipping	Refund

---

3. Other Income (OtherIncome)

TransactionType	Amount Field	Order Type
Order Subsidy	Amount	Order
Refund Subsidy	Amount	Refund

---

4. Platform Commission (Commission)

TransactionType	Amount Field	Order Type
Order	CommissionFee	Order
Refund	CommissionFee	Refund

---

5. Platform Fulfillment (PlatformShipping)

TransactionType	Amount Field	Order Type
Starts with Order:	Amount	Order
Print Shipping Label Service: Adjustment	Amount	Order
Print Shipping Label Service	Amount	Order
Newegg Relabeling Fee	Amount	Refund
Print Shipping Label Service: Refund'	Amount	Refund
Starts with RMA:	Amount	Refund
Starts with Replacement:	Amount	Refund

---

6. Marketing (Marketing)

TransactionType	Order Type	Amount Field
Unsold Listing Fee	Order	Amount
Wire Transfer Fee	Order	Amount
Order Gift Card Funding	Order	Amount
Merchandising Fee	Order	Amount
A+ Content	Order	Amount
SKU Listing Fee	Order	Amount
Refund Gift Card Funding	Refund	Amount

---

7. Advertising (AdvertisingFee)

TransactionType	Amount Field	Order Type
Sponsored Ads	Amount	Order

---

8. Adjustment (AdjustmentFee)

TransactionType	Amount Field	Order Type
Starts with Adjustment Fee:.	Amount	Order
Credit Request	Amount	OnlyRefund
Chargeback	Amount	Chargeback Refund

---

9. Storage & Inbound (PlatformStorageFee)

TransactionType	Amount Field	Order Type
SBN Inbound Fee	Amount	Order
SBN Inbound Incompliance Charges	Amount	Order
Return Inventory	Amount	Order

---

10. Platform Other (PlatformOther)

Non-order fund movements

TransactionType	Amount Field	Order Type
Reserved Balance	Amount	Other
Previous Reserved Balance	Amount	Other

Order fees

TransactionType	Amount Field	Order Type
Newegg Premier Fee	Amount	Order
Item Overage Fee	Amount	Order
Starts with Multi-Channel	Amount	Order
EHF	Amount	Order
E-waste Recycling Fee	Amount	Order
Battery Fee	Amount	Order

Refund-related fees

TransactionType	Amount Field	Order Type
RMA Processing Fee	Amount	Refund
Starts with Debit Balance	Amount	Refund
Return RMA Goods	Amount	Refund
RMA Buy-out Fee	Amount	Refund
Tire Fee	Amount	Refund
Eco Fee	Amount	Refund

---

11. Sales Tax (SalesTax)

TransactionType	Amount Field	Order Type
GST	Amount	Order
HST	Amount	Order
PST	Amount	Order

---

12. VAT

TransactionType	Amount Field	Order Type
VAT	Amount	Order

---

13. Other Taxes (OtherTaxes)

Condition	Amount Field	Order Type
Starts with Newegg Service Fee Tax	Amount	Order
Duty	Amount	Order
Elite Monthly Fee Tax	Amount	Order

---