Amazon Selling Partner Setup Guide

Follow our setup guide to connect your Amazon Selling Partner account to Fivetran.

Prerequisites

To connect your Amazon Selling Partner account to Fivetran, you need an active Amazon Seller Central or Vendor Central account with Admin access.

Set up only one connection per Amazon Selling Partner account.
Set up only one connection per region. The Amazon Selling Partner API (SP-API) authorizes access at the region level and provides access to all marketplaces within that region. For more information about marketplaces and regions, see Amazon documentation.

This step applies only to Amazon Seller Central accounts.

Log in to your Amazon Seller Central account.
In the top-right corner, click the Settings icon and select Account Info.
On the navigation menu, click Business Information.
Click Your Merchant Token.
Make a note of the Merchant Token associated with the marketplace whose data you want to sync. You will need it to configure Fivetran.

Log in to your Amazon Seller Central or Amazon Vendor Central account.
On the navigation menu, click Apps and Services > Develop Apps.
In the Developer Central console, click + Add new app client.
Enter an App name.
In the API Type drop-down menu, select SP API.
In the Business entities supported section, select the checkbox for your Amazon business entity (Sellers or Vendors).
Based on your Amazon business entity, assign the necessary roles to your app.
- For Sellers business entity, select the checkbox for the following roles:
  - Finance and Accounting
  - Selling Partner Insights
  - Buyer Communication
  - Pricing
  - Inventory and Order Tracking
  - Brand Analytics
  - Amazon Fulfillment
  - Buyer Solicitation
  - Product Listing
- For Vendors business entity, select the checkbox for the following roles:
  - Brand Analytics
  - Amazon Fulfillment
  - Product Listing
In the Restricted Data Token (RDT) section, choose No, I will not delegate access to PII to another developer's application.
Click Save and exit.
Do not specify any OAuth Login URI and Oauth Redirect URI.
In the app list, click View for your app.
Make a note of the Client identifier and Client secret, and then click Done. You will need them to configure Fivetran.

In the Developer Central console, click the drop-down menu for your app and select Authorize.
In the Add Authorizations section, click Authorize app for the marketplace whose data you want to sync.
Make a note of the Refresh Token. You will need it to configure Fivetran.
Amazon displays the refresh token only once. Be sure to copy it as soon as it is generated.

In the connection setup form, enter the Destination schema name of your choice.
(Only for Amazon Vendor Central accounts) Set the Vendor Account toggle to ON.
(Only for Amazon Seller Central accounts) Enter the Merchant Token you found.
In the Region drop-down menu, select the region of the marketplace whose data you want to sync.
Enter the Client ID and Client Secret you found.
Enter the Refresh Token you generated.
Make sure the refresh token is associated with the region you selected in the Region drop-down menu.
In the Historical Sync Time Frame drop-down menu, select the amount of historical data you want to include in your initial sync:
- Select Sync all historical data to sync the available historical data.
- Select Sync data from selected date and choose a date in the Historical Sync Start Date field to limit the historical data for tables. For more information, see our Historical sync time frame documentation.
Click Save & Test. Fivetran will take it from here and sync your Amazon Selling Partner data.