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 | check | CATALOG and PRODUCT PRICING modules. |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | REPORTS, FINANCE, and ORDERS modules. |
| Fivetran data models | check | |
| Private networking | ||
| Authorization via API | check |
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.
To zoom, open the ERD in a new window.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.
Application access scopes
The roles listed below are applicable only to Amazon Selling Partner connections created using a non-Fivetran application (custom, private or another public application).
Fivetran requires the following application roles for Amazon Seller's/Vendor's private application:
Seller
Amazon FulfillmentBrand AnalyticsBuyer CommunicationBuyer SolicitationFinance and AccountingInventory and Order TrackingPricingProduct ListingNoSelling Partner Insights
Vendor
Amazon FulfillmentBrand AnalyticsProduct ListingNo
Historical sync time frame
You can configure the historical sync time frame when setting up your connection to speed up both the initial sync and subsequent re-syncs. Historical sync time frame limits the amount of data synced for the following tables:
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 following modules as Amazon Selling Partner's APIs do not return PII for them:
ORDERSSHIPPING
For vendor data, we can sync the reports only for the marketplace ID you've registered.
In FINANCIAL_ADJUSTMENT_EVENT tables, records with the same adjustment_type and posted_date share the same hashed primary key (fivetran_id). Since the Amazon Selling Partner API doesn’t provide unique IDs, duplicate events with identical adjustment_type and posted_date (to the millisecond) sync as a single record to the destination.