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 | FINANCE and ORDERS modules. |
Fivetran data models | ||
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 connectors.
To zoom, open the ERD in a new window.Seller modules
The following modules are available for the sellers:
A+ CONTENT MANAGEMENT
CATALOG
EASYSHIP
FBA
FINANCE
FULFILLMENT INBOUND
FULFILLMENT OUTBOUND
LISTED ITEM
ORDERS
PRODUCT PRICING
SERVICES
SHIPPING
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_EVENT
table, the corresponding columns in theFINANCIAL_CHARGE_COMPONENT
table 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
IMPORTANT: The roles listed below are applicable only for the Amazon Selling connectors 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 Fulfillment
Brand Analytics
Buyer Communication
Buyer Solicitation
Finance and Accounting
Inventory and Order Tracking
Pricing
Product Listing
No
Selling Partner Insights
Vendor
Amazon Fulfillment
Brand Analytics
Product Listing
No
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_ELEMENT
FINANCIAL_ADHOC_DISBURSEMENT_EVENT
FINANCIAL_AFFORDABILITY_EXPENSE_EVENT
FINANCIAL_CAPACITY_RESERVATION_BILLING_EVENT
FINANCIAL_CHARGE_COMPONENT
FINANCIAL_CHARGE_INSTRUMENT
FINANCIAL_CHARGE_REFUND_EVENT
FINANCIAL_COUPON_PAYMENT_EVENT
FINANCIAL_DEBT_RECOVERY_EVENT
FINANCIAL_DEBT_RECOVERY_ITEM
FINANCIAL_FAILED_ADHOC_DISBURSEMENT_EVENT
FINANCIAL_FBA_LIQUIDATION_EVENT
FINANCIAL_FEE_COMPONENT
FINANCIAL_IMAGING_SERVICES_FEE_EVENT
FINANCIAL_PAY_WITH_AMAZON_EVENT
FINANCIAL_PRODUCT_ADS_PAYMENT_EVENT
FINANCIAL_REMOVAL_SHIPMENT_ADJUSTMENT_EVENT
FINANCIAL_REMOVAL_SHIPMENT_EVENT
FINANCIAL_REMOVAL_SHIPMENT_ITEM
FINANCIAL_REMOVAL_SHIPMENT_ITEM_ADJUSTMENT
FINANCIAL_RENTAL_TRANSACTION
FINANCIAL_RETRO_CHARGE_EVENT
FINANCIAL_SAFET_REIMBURSEMENT_EVENT
FINANCIAL_SAFET_REIMBURSEMENT_ITEM
FINANCIAL_SELLER_DEAL_PAYMENT_EVENT
FINANCIAL_SELLER_REVIEW_ENROLLMENT_PAYMENT_EVENT
FINANCIAL_SERVICE_FEE_EVENT
FINANCIAL_SHIPMENT_DIRECT_PAYMENT
FINANCIAL_SHIPMENT_EVENT
FINANCIAL_SHIPMENT_EVENT_ITEM
FINANCIAL_SHIPMENT_EVENT_ITEM_PROMOTION
FINANCIAL_SOLUTION_PROVIDER_CREDIT_EVENT
FINANCIAL_TAX_WITHHOLDING_EVENT
FINANCIAL_TDS_REIMBURSEMENT_EVENT
FINANCIAL_TRIAL_SHIPMENT_EVENT
FINANCIAL_VALUE_ADDED_SERVICE_CHARGE_EVENT
MARKET_BASKET_ANALYSIS_REPORT_DAILY
MARKET_BASKET_ANALYSIS_REPORT_MONTHLY
MARKET_BASKET_ANALYSIS_REPORT_QUARTERLY
MARKETPLACE_TAX_CLASSIFICATION
NET_PURE_PRODUCT_MARGIN_REPORT_DAILY
NET_PURE_PRODUCT_MARGIN_REPORT_MONTHLY
NET_PURE_PRODUCT_MARGIN_REPORT_QUARTERLY
NETWORK_COMMINGLING_TRANSACTION_EVENT
ORDER
ORDER_ITEMS
ORDERS_ITEM_PROMOTION_ID
ORDER_ITEM_SERIAL_NUMBER
ORDER_REGULATED_INFO
PAYMENT_EXECUTION_DETAIL_ITEM
PAYMENT_METHOD_DETAIL_ITEM
RAPID_RETAIL_ANALYTICS_INVENTORY_REPORT_HOURLY
RAPID_RETAIL_ANALYTICS_SALES_REPORT_HOURLY
RAPID_RETAIL_ANALYTICS_TRAFFIC_REPORT_HOURLY
REGULATED_INFORMATION_FIELD
REPEAT_PURCHASE_REPORT_MONTHLY
REPEAT_PURCHASE_REPORT_QUARTERLY
SALES_AND_TRAFFIC_BUSINESS_REPORT_DAILY
SALES_AND_TRAFFIC_BUSINESS_REPORT_MONTHLY
SEARCH_TERMS_REPORT_DAILY
SEARCH_TERMS_REPORT_MONTHLY
SEARCH_TERMS_REPORT_QUARTERLY
VENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_DAILY
VENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_MONTHLY
VENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_QUARTERLY
VENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_DAILY
VENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_MONTHLY
VENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_QUARTERLY
VENDOR_INVENTORY_SOURCING_FRESH_REPORT_DAILY
VENDOR_INVENTORY_SOURCING_FRESH_REPORT_MONTHLY
VENDOR_INVENTORY_SOURCING_FRESH_REPORT_QUARTERLY
VENDOR_INVENTORY_SOURCING_RETAIL_REPORT_DAILY
VENDOR_INVENTORY_SOURCING_RETAIL_REPORT_MONTHLY
VENDOR_INVENTORY_SOURCING_RETAIL_REPORT_QUARTERLY
VENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_DAILY
VENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_MONTHLY
VENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_QUARTERLY
VENDOR_SALES_MANUFACTURING_FRESH_REPORT_DAILY
VENDOR_SALES_MANUFACTURING_FRESH_REPORT_MONTHLY
VENDOR_SALES_MANUFACTURING_FRESH_REPORT_QUARTERLY
VENDOR_SALES_MANUFACTURING_RETAIL_REPORT_DAILY
VENDOR_SALES_MANUFACTURING_RETAIL_REPORT_MONTHLY
VENDOR_SALES_MANUFACTURING_RETAIL_REPORT_QUARTERLY
VENDOR_SALES_SOURCING_BUSINESS_REPORT_DAILY
VENDOR_SALES_SOURCING_BUSINESS_REPORT_MONTHLY
VENDOR_SALES_SOURCING_BUSINESS_REPORT_QUARTERLY
VENDOR_SALES_SOURCING_FRESH_REPORT_DAILY
VENDOR_SALES_SOURCING_FRESH_REPORT_MONTHLY
VENDOR_SALES_SOURCING_FRESH_REPORT_QUARTERLY
VENDOR_SALES_SOURCING_RETAIL_REPORT_DAILY
VENDOR_SALES_SOURCING_RETAIL_REPORT_MONTHLY
VENDOR_SALES_SOURCING_RETAIL_REPORT_QUARTERLY
VENDOR_TRAFFIC_REPORT_DAILY
VENDOR_TRAFFIC_REPORT_MONTHLY
VENDOR_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:
ORDERS
SHIPPING
For the vendor connector, we can sync the reports only for the marketplace ID you've registered.