Amazon Selling Partner

Amazon Selling Partner is one of the world's largest online marketplaces. Amazon provides a platform for sellers to showcase and offer their products to a vast customer base, spanning across various categories and regions. Their Selling Partner APIs provide access to a wide range of data, including orders, inventory, and reports.

Features

Feature name	Supported
Column Hashing	True	Field level
Blocking	True	Field level
Incremental	True
Custom data	False
History	False
ReSync	True	Table level
Templates	False

---

Data Schema

---

Setup Guide

Authentication with Private app

Step 1 - Credentials from your Amazon Account

Login to your Amazon Selling Partner Account, and register a private application (find out more here: Amazon Developer Docs - Register your application). You can also read more about self authorization here If you already have an application for APIs, feel free to use it.

From this application, you get access to:

• Refresh token
• App client ID
• App client Secret

Step 2 - Add credentials to Weld App

Register the credentials generated for the app. Furthermore, you need to specify the region you account is registered at.

Step 3 - Connect

Click connect, and authorize Weld to your Amazon Selling Partner account.

---

Authentication with Weld

Step 1 - Set up connection in Weld App

Choose the region where you would like to authenticate After this click Authorize and follow the instructions

---

Sync setup

Step 1 - Data To Sync

1. Select the pre-built reports you wish to include in the sync.
   You can view the schema, remove columns or hash sensitive information.

Step 2 - Configure Sync

1. Select how often you would like the data to sync.
2. Provide a unique destination table name.

Weld will take over from here and commence syncing data from your Amazon Selling account.

---

Data Retention & Limitations

Amazon limits the availability of historical data for certain reports.

Report Name	Data Retention Period
Settlement Report	89 days
Search Query Performance	15 months
FBA SNS Performance	4 weeks
FBA SNS Forecast	Current Week (No history)

---

Migration to Private app authentication

Weld is updating the authentication method for the Amazon Selling Partner connector. Instead of authenticating through Weld's shared OAuth application, connections must now authenticate using credentials from your own Selling Partner API (SP-API) application.

Who needs to migrate

You must migrate if your existing Amazon Selling Partner connection authenticates using Weld's shared OAuth.

Connections that already authenticate using a private SP-API application do not require migration.

Prerequisites

Before starting the migration, make sure you have:

1. A registered SP-API application -- Register a private application in Amazon Seller Central if you don't already have one.
2. Client ID and Client Secret -- Available from your SP-API application's credentials page.
3. Refresh Token -- Generated by completing the self-authorization flow for your application.

Step-by-step migration

1. Log in to your Weld workspace and go to Settings → Connectors.
2. Select the Amazon Selling Partner connection.
3. Click Configuration.
4. Select Authenticate with Private app as the authentication method.
5. Enter the Refresh Token, App Client ID, and App Client Secret from your SP-API application.
6. Select the Region your Amazon account is registered in.
7. Click Authorize to reauthenticate the connection.
8. Trigger a test sync to confirm everything is working correctly.