📘
Using New Customer modeling?
Due to a recent change in Amazon's Selling Partner API, customers who rely on New Customer modeling need to supply new customer data through our data patch process. This applies to both new and existing connectors. See Data Patching for New Customer Modeling for details and the patch template.

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.

FAQ

Do you use net or gross revenue in Amazon Selling Partner modeling?

It is gross revenue — calculated from the OrderTotal field across all orders in Unshipped, PartiallyShipped, and Shipped statuses. Unlike Shopify modeling (which uses net merchandise revenue), Amazon revenue includes sales tax and shipping collected at checkout and is measured prior to refunds, returns, or post-order adjustments.

Why is my Amazon revenue higher in Prescient than in Seller Central settlement reports?

Seller Central settlement reports reflect net payouts (after deducting returns, fees, and cancellations) on the date payouts settle. Prescient attributes revenue on the date the order is confirmed and records the full gross order total. To perform an accurate comparison, reconcile Prescient against Ordered Product Sales in Seller Central rather than settlement or payout reports.

Are Amazon subscription sales included in modeling?

Yes. While Shopify subscription revenue is excluded from D2C modeling, Amazon Subscription Revenue is included in Prescient’s Amazon revenue totals and model attribution. This is because there is no delineation of these values in the reports of ASP API.

Why do I see a discrepancy for international storefronts (EUR / GBP)?

Ensure your internal reporting and Prescient views are evaluated in the same currency. Ingesting raw local platform values without matching currency display settings can cause an apparent mismatch (for example, evaluating USD figures against EUR internal totals).