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.

Create the connection using your browser's incognito mode.
Create only one connection per Amazon Selling Partner account.
Create only one connection for all marketplaces in the same region. The Amazon Selling Partner API (SP-API) authorizes the connection for a specific region and provides us access to all marketplaces in this region. For more information about marketplaces and regions, see the Amazon SP-API documentation.

In the connection setup form, enter your chosen Destination schema name.
(Optional for Vendor Central accounts) Set the Vendor Account toggle to ON.
Select the Region where your Seller or Vendor account is active.
Click Authorize to allow Fivetran to access your Amazon Selling Partner account. You will be redirected to your Amazon Selling Partner account to authorize Fivetran's access.
Log in to your Amazon Selling Partner account and click Allow to grant access. Once you have finished, you will be redirected back to Fivetran.
The Merchant ID field is only applicable for Seller accounts and is automatically populated.
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 data from your Amazon Selling Partner account.