Amazon Vendor Central
Amazon Vendor Central is Amazon's invite-only platform for manufacturers and distributors who sell products directly to Amazon. Through the Selling Partner APIs, Weld syncs vendor-specific reports including sales, inventory, traffic, forecasting, and margin data.
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 Vendor Central 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 marketplace your account is registered at.
Step 3 - Connect
Click connect, and authorize Weld to your Amazon Vendor Central account.
Authentication with Weld
Step 1 - Set up connection in Weld App
Choose the marketplace where you would like to authenticate. After this click Authorize and follow the instructions.
Sync setup
Step 1 - 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 2 - 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 Vendor Central account.
Data Retention & Limitations
If you perform a full re-sync (resetting the table), any data older than the retention periods listed below will be permanently lost, as Weld can only retrieve what is currently available via Amazon's API. Proceed with caution when resetting these tables.
Amazon limits the availability of historical data for certain reports.
| Report Name | Data Retention Period |
|---|---|
| Real-time Sales Report | 29 days |
| Real-time Inventory Report | 29 days |
| Real-time Traffic Report | 29 days |
| Vendor Forecasting Report | Current (No history) |
All other reports (Sales, Inventory, Traffic, Net Pure Product Margin) retain up to 4 years of data.
Available Reports
| Report Name | Description |
|---|---|
| Vendor Sales (Manufacturing/Retail) | Sales data from the manufacturing distributor view for the retail program |
| Vendor Sales (Manufacturing/Business) | Sales data from the manufacturing distributor view for the business program |
| Vendor Sales (Sourcing/Retail) | Sales data from the sourcing distributor view for the retail program |
| Vendor Sales (Sourcing/Business) | Sales data from the sourcing distributor view for the business program |
| Vendor Inventory (Manufacturing/Retail) | Inventory data from the manufacturing distributor view |
| Vendor Inventory (Sourcing/Retail) | Inventory data from the sourcing distributor view |
| Vendor Traffic Report | Glance views (page views) per ASIN |
| Vendor Forecasting Report | Amazon's demand forecast per ASIN |
| Vendor Net Pure Product Margin Report | Net pure product margin per ASIN |
| Vendor Real-time Sales Report | Near real-time ordered units and revenue per ASIN |
| Vendor Real-time Inventory Report | Near real-time highly available inventory per ASIN |
| Vendor Real-time Traffic Report | Near real-time glance views per ASIN |
Real-time reports have a 2-hour delay — data is available up to 2 hours before the current time.