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

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.

Seller modules

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

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 the FINANCIAL_CHARGE_COMPONENT table have the following values:

  • linked_to: SHIPMENT_EVENT

  • linked_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_ITEM

  • linked_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

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:

• MERCHANT FULFILLMENT
• ORDERS
• SHIPPING

For the vendor connector, we can sync the reports only for the marketplace ID you've registered.