Amazon Selling Partner
Seller Central and Vendor Central are the official Amazon services that allow businesses to manage their Amazon sales activity.
Selling Partner API (SP-API) is a REST-based API that helps Amazon Selling partners access their Seller Central account data.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | CATALOG and PRODUCT PRICING modules. | |
| History mode | ||
| Custom data | ||
| Data blocking | ||
| Column hashing | ||
| Re-sync | ||
| Row filtering | ||
| API configurable | API configuration | |
| Priority-first sync | REPORTS, FINANCE, and ORDERS modules. | |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API |
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step Amazon Selling Partner setup guide to connect Amazon Selling Partner with your destination using Fivetran connectors. You can access the setup guide alongside the Amazon Selling Partner connection setup form in the Fivetran dashboard.
Schema information
This schema applies to all Amazon Selling Partner connections.
Seller modules
The following modules are available for the sellers:
A+ CONTENT MANAGEMENTCATALOGEASYSHIPFBAFINANCEFULFILLMENT OUTBOUNDLISTED ITEMORDERSPRODUCT PRICINGSERVICESSHIPPING
FINANCE
The FINANCIAL_SHIPMENT_EVENT table and its child table, FINANCIAL_SHIPMENT_EVEN_ITEM store shipment events data, such as the order_id, event_type, and quantity_shipped.
The charges or fees associated with these shipment events and items, such as order charges, shipment fees, item charges, item fees, and promotions, is stored in the FINANCIAL_CHARGE_COMPONENT as following:
For charges related to the
SHIPMENT_EVENTtable, the corresponding columns in theFINANCIAL_CHARGE_COMPONENTtable have the following values:linked_to: SHIPMENT_EVENTlinked_to_id: shipment_event_id (_fivetran_id)charge_kind: OrderCharge
For charges related to the
FINANCIAL_SHIPMENT_EVEN_ITEM, the corresponding columns have the following values:linked_to: SHIPMENT_EVENT_ITEMlinked_to_id: shipment_event_item_id (_fivetran_id)chargeKind: ItemCharge
Vendor modules
The two modules, A+ CONTENT MANAGEMENT and VENDOR are available for the vendors.
Report tables
We support a set of reports.
Historical sync time frame
When setting up your connection, you can configure the historical sync time frame to speed up the initial sync and subsequent re-syncs. This setting limits the amount of historical data Fivetran syncs for certain tables, thereby significantly reducing sync time.
Expand to see the list of tables affected by the historical sync time frame
APPROVAL_SUPPORT_DATA_ELEMENTFINANCIAL_ADHOC_DISBURSEMENT_EVENTFINANCIAL_ADJUSTMENT_ITEMFINANCIAL_AFFORDABILITY_EXPENSE_EVENTFINANCIAL_CAPACITY_RESERVATION_BILLING_EVENTFINANCIAL_CHARGE_COMPONENTFINANCIAL_CHARGE_INSTRUMENTFINANCIAL_CHARGE_REFUND_EVENTFINANCIAL_COUPON_PAYMENT_EVENTFINANCIAL_DEBT_RECOVERY_EVENTFINANCIAL_DEBT_RECOVERY_ITEMFINANCIAL_FAILED_ADHOC_DISBURSEMENT_EVENTFINANCIAL_FBA_LIQUIDATION_EVENTFINANCIAL_FEE_COMPONENTFINANCIAL_IMAGING_SERVICES_FEE_EVENTFINANCIAL_LOAN_SERVICING_EVENTFINANCIAL_PAY_WITH_AMAZON_EVENTFINANCIAL_PRODUCT_ADS_PAYMENT_EVENTFINANCIAL_REMOVAL_SHIPMENT_ADJUSTMENT_EVENTFINANCIAL_REMOVAL_SHIPMENT_EVENTFINANCIAL_REMOVAL_SHIPMENT_ITEMFINANCIAL_REMOVAL_SHIPMENT_ITEM_ADJUSTMENTFINANCIAL_RENTAL_TRANSACTIONFINANCIAL_RETRO_CHARGE_EVENTFINANCIAL_SAFET_REIMBURSEMENT_EVENTFINANCIAL_SAFET_REIMBURSEMENT_ITEMFINANCIAL_SELLER_DEAL_PAYMENT_EVENTFINANCIAL_SELLER_REVIEW_ENROLLMENT_PAYMENT_EVENTFINANCIAL_SERVICE_FEE_EVENTFINANCIAL_SHIPMENT_DIRECT_PAYMENTFINANCIAL_SHIPMENT_EVENTFINANCIAL_SHIPMENT_EVENT_ITEMFINANCIAL_SHIPMENT_EVENT_ITEM_PROMOTIONFINANCIAL_SOLUTION_PROVIDER_CREDIT_EVENTFINANCIAL_TAX_WITHHOLDING_EVENTFINANCIAL_TDS_REIMBURSEMENT_EVENTFINANCIAL_TRIAL_SHIPMENT_EVENTFINANCIAL_VALUE_ADDED_SERVICE_CHARGE_EVENTMARKET_BASKET_ANALYSIS_REPORT_DAILYMARKET_BASKET_ANALYSIS_REPORT_MONTHLYMARKET_BASKET_ANALYSIS_REPORT_QUARTERLYMARKETPLACE_TAX_CLASSIFICATIONNET_PURE_PRODUCT_MARGIN_REPORT_DAILYNET_PURE_PRODUCT_MARGIN_REPORT_MONTHLYNET_PURE_PRODUCT_MARGIN_REPORT_QUARTERLYNETWORK_COMMINGLING_TRANSACTION_EVENTORDERORDER_ITEMSORDERS_ITEM_PROMOTION_IDORDER_ITEM_SERIAL_NUMBERORDER_REGULATED_INFOPAYMENT_EXECUTION_DETAIL_ITEMPAYMENT_METHOD_DETAIL_ITEMRAPID_RETAIL_ANALYTICS_INVENTORY_REPORT_HOURLYRAPID_RETAIL_ANALYTICS_SALES_REPORT_HOURLYRAPID_RETAIL_ANALYTICS_TRAFFIC_REPORT_HOURLYREGULATED_INFORMATION_FIELDREPEAT_PURCHASE_REPORT_MONTHLYREPEAT_PURCHASE_REPORT_QUARTERLYSALES_AND_TRAFFIC_BUSINESS_REPORT_DAILYSALES_AND_TRAFFIC_BUSINESS_REPORT_MONTHLYSEARCH_TERMS_REPORT_DAILYSEARCH_TERMS_REPORT_MONTHLYSEARCH_TERMS_REPORT_QUARTERLYVENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_DAILYVENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_MONTHLYVENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_QUARTERLYVENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_DAILYVENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_MONTHLYVENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_QUARTERLYVENDOR_INVENTORY_SOURCING_FRESH_REPORT_DAILYVENDOR_INVENTORY_SOURCING_FRESH_REPORT_MONTHLYVENDOR_INVENTORY_SOURCING_FRESH_REPORT_QUARTERLYVENDOR_INVENTORY_SOURCING_RETAIL_REPORT_DAILYVENDOR_INVENTORY_SOURCING_RETAIL_REPORT_MONTHLYVENDOR_INVENTORY_SOURCING_RETAIL_REPORT_QUARTERLYVENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_DAILYVENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_MONTHLYVENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_QUARTERLYVENDOR_SALES_MANUFACTURING_FRESH_REPORT_DAILYVENDOR_SALES_MANUFACTURING_FRESH_REPORT_MONTHLYVENDOR_SALES_MANUFACTURING_FRESH_REPORT_QUARTERLYVENDOR_SALES_MANUFACTURING_RETAIL_REPORT_DAILYVENDOR_SALES_MANUFACTURING_RETAIL_REPORT_MONTHLYVENDOR_SALES_MANUFACTURING_RETAIL_REPORT_QUARTERLYVENDOR_SALES_SOURCING_BUSINESS_REPORT_DAILYVENDOR_SALES_SOURCING_BUSINESS_REPORT_MONTHLYVENDOR_SALES_SOURCING_BUSINESS_REPORT_QUARTERLYVENDOR_SALES_SOURCING_FRESH_REPORT_DAILYVENDOR_SALES_SOURCING_FRESH_REPORT_MONTHLYVENDOR_SALES_SOURCING_FRESH_REPORT_QUARTERLYVENDOR_SALES_SOURCING_RETAIL_REPORT_DAILYVENDOR_SALES_SOURCING_RETAIL_REPORT_MONTHLYVENDOR_SALES_SOURCING_RETAIL_REPORT_QUARTERLYVENDOR_TRAFFIC_REPORT_DAILYVENDOR_TRAFFIC_REPORT_MONTHLYVENDOR_TRAFFIC_REPORT_QUARTERLY
You can modify the historical sync time frame at any time. If you change it to an earlier date, we perform a full historical re-sync, syncing data back to that new date. If you set it to a later date, we do not delete any existing data. Instead, we apply the new time frame only to subsequent re-syncs.
Limitations
- We do not sync Personally Identifiable Information (PII) for the
ORDERSandSHIPPINGmodules as Amazon Selling Partner APIs do not return PII for them. - For vendor data, we can sync the reports only for the marketplace ID you've registered.
- In
FINANCIAL_ADJUSTMENT_EVENTtables, records with the sameadjustment_typeandposted_dateshare the same hashed primary key (fivetran_id). Since the Amazon Selling Partner API doesn’t provide unique IDs, duplicate events with identicaladjustment_typeandposted_date(to the millisecond) sync as a single record to the destination.