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 |
Personally Identifiable Information is not available for Amazon Orders
Data Schema
The table settlement_report syncs data from automatically generated reports
from Amazon. We do not have control over when the reports are generated.
Because of this, there might be days when no new data is synced.
These reports are retained for 90 days, after which they are deleted by
Amazon. Because of this, Weld will not be able to sync data for the
settlement_report table that is older than 90 days.
🔧 Setup Guide
Step 1 - Credentials from your Amazon Account
Login to your Amazon Selling Partner Account, and register an application (find out more here: Amazon Developer Docs - Register your application). 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.
Step 4 - Data To Sync
- Select the pre-built reports you wish to include in the sync.
You can view the schema, remove columns or hash sensitive information.
Step 5 - Configure Sync
- Select how often you would like the data to sync.
- Provide a unique destination table name.
Weld will take over from here and commence syncing data from your Amazon Selling account.
⚠️ Data Retention & Limitations
Please be aware that Amazon limits the availability of historical data for certain reports.
If you decide to perform a full re-sync (resetting the table), any data older than the retention periods listed below will be lost, as Weld can only retrieve what is currently available via Amazon's API. We recommend proceeding with caution when resetting these specific tables.
| 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) |