Prerequisites

To connect your Amazon Selling Partner account to Fivetran, you need an active Amazon Seller Central or Vendor Central account with Admin access.
If you do not have a Develop Apps access in Seller Central or have a current accessible app make sure to register as a Developer
- Log into Amazon Seller Central.
- Go to Settings -> User Permissions -> Developer Permissions OR Apps & Services ->Develop Apps
- Click Register as a developer
- Complete the registration form (company name, contact info, website, etc.), select "Private"
- Choose the necessary roles from list provided in Fivetran Documentation
- Submit and wait for approval (Amazon can approve immediately or could take 24 hours)
If you have not created an Selling Partner App, do as follows:
- Go to Apps & Services -> Develop Apps
- Click Add new app client
- Choose: SP-API and Production
- Provide: App name, Description and Redirect URL
- Click Save
- Your Client ID and Client Secret will be in the LWA column in "View"
If you have not Authorized the App, do as follows:
- Go to Apps & Services -> Manage Your Apps
- Find the newly created app
- Click Authorize
- Approve access to: Orders, Sales, and Reports

Setup Instructions

In your Amazon Selling account, go to Settings > Account Info.
Click Merchant Token.
Make a note of the token. You will need it to configure Fivetran.
In the Merchant ID field, enter the Merchant Token you found.
If you have a Vendor account, enable the Vendor Account toggle.
Select the Region where your Seller or Vendor account is active.
Click Authorize. This action redirects your browser to the Amazon authorization page.
In Amazon's Seller Central or Vendor Central authorization page, click Sign-In.
To grant access to the Amazon application, select Allow. This action redirects you to the connector setup form.
Click Save & Test. Fivetran will take it from here and sync your data from your Amazon Selling Partner account.