Amazon Selling Partner link
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.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | CATALOG , and PRODUCT PRICING modules. |
Custom data | ||
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | ||
API configurable | check | API configuration |
Priority-first sync | check | FINANCE and ORDERS modules. |
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step Amazon Selling Partner setup guide to connect Amazon Selling Partner with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all Amazon Selling Partner connectors.
To zoom, open the ERD in a new window.Seller moduleslink
The following modules are available for the sellers:
A+ CONTENT MANAGEMENT
CATALOG
EASYSHIP
FBA
FINANCE
FULFILLMENT INBOUND
FULFILLMENT OUTBOUND
LISTED ITEM
MERCHANT FULFILLMENT
ORDERS
PRODUCT PRICING
SERVICES
SHIPPING
FINANCElink
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 moduleslink
The two modules, A+ CONTENT MANAGEMENT
and VENDOR
are available for the vendors.
Report tableslink
We support a set of reports.
Application access scopeslink
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:
Sellerlink
Amazon Fulfillment
Brand Analytics
Buyer Communication
Buyer Solicitation
Finance and Accounting
Inventory and Order Tracking
Pricing
Product Listing
No
Selling Partner Insights
Vendorlink
Amazon Fulfillment
Brand Analytics
Product Listing
No
Limitationslink
We do not sync Personally Identifiable Information (PII) for the following modules as Amazon Selling Partner's APIs do not return PII for them:
MERCHANT FULFILLMENT
ORDERS
SHIPPING