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.
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.
Authentication
The Amazon Selling Partner connector authenticates with Amazon using credentials from a Selling Partner app client. You must register this app in Amazon Developer Central and authorize it for the seller or vendor account you want to sync.
To authenticate your connection, you must provide the following app client credentials during the connection setup:
Client ID: Identifies your Selling Partner application
Client Secret: Works with the client ID to request access tokens
Refresh Token: Allows Fivetran to refresh access tokens automatically
Fivetran uses these credentials to perform OAuth 2.0 authentication and access the Amazon Selling Partner API (SP-API).
Client secret rotation
Amazon sets a 6-month expiration on app client secrets. You must generate a new client secret for your app client every 6 months and update your Amazon Selling Partner connection to use the new client secret before the current secret expires. If you do not rotate the client secret in time, authentication fails, and the connector stops syncing.
Expand for instructions on rotating the client secret and updating the connection
- Log in to your Amazon Seller Central or Amazon Vendor Central account.
- On the navigation menu, click Apps and Services > Develop Apps.
- In the LWA credentials column, click View for the app client associated with your connection.
- Click Rotate secret.
- Read the cautionary warning and click Rotate secret again.
- Make a note of the new Client secret and click Done.
- In the Fivetran dashboard, go to the connection details page.
- In the top-right corner, click the more options menu and select Edit connection.
- In the Client Secret field, enter the new client secret you generated for your app client.
- Click Save & Test.
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.