Amazon Vendor Central

Amazon Vendor Central connector from Daton is to provide all reports and raw data available from Amazon's SP-API that can be availed by registered Vendors.

How to make an Amazon Vendor Central Integration in Daton?

1. Log in to Daton. Or sign up.

2. Assuming you have configured your destination, search "Amazon Vendor Central" in the search bar and click configure on the connector that appears. If not, configure your data warehouse first. Daton supports several data destinations.

3. Provide Integration Name, Replication Frequency, History, and Marketplace. Integration name would be used while creating tables on the warehouse and cannot be changed later. See general guidelines if you are unsure of which option to pick.

4. Click the 'Authenticate' button. You will be taken to Amazon's Vendor Central login page to authorize Daton to access data from Amazon's SP-API. Allow Daton to access the required scopes and authorize the Daton app.

5. If you prefer to not use the primary account, you will need to give access to a set of permissions on Amazon in order to authorize Daton. Contact [e-mail] to learn more.

6. After authentication, you will be prompted to choose from the list of available tables. Select the required tables and columns.

7. Submit the integration. You can now view the tables being created in your data destination by the name given to your integration.

What happens next?

1. Click on your integration in the 'Sources' page to see the status of each table.

2. Click on a table to see its status. The jobs would be in pending state initially and then will be moved to Active state once data starts flowing into the destination.

3. Job status can be viewed at any time. You can also edit the integration to change frequency and history.

General guidelines for configuring Amazon Vendor Central Connector on Daton

• Select frequency as 1 hour. This will ensure fastest replication of historical data.

• Historical data replication happens in batches and it will take a few jobs for the data to be replicated up until current day

• Select the duration of history based on availability of data, i.e. for the period the business has been active. If you select a larger period of history, data may be delayed as we will try to fetch data for dates where the vendor was inactive.

• Reach out to [e-mail] for any guidance with the setup and optimization.

Changelog

Affected entities	Release date	Update
MonthlyVendorInventoryReportByManufacturing, MonthlyVendorInventoryReportBySourcing	2023-10-25	Changed timestamp to UTC to avoid 400 errors.
All daily reports	2023-09-07	Fixed a bug that caused less than 1% records to be pulled twice.
VendorRealTimeSalesReport, VendorRealTimeTrafficReport, VendorRealTimeInventoryReport	2023-08-28	New tables
File upload UI	2023-06-07	Upload csv file from the UI to access CatalogItems data.
DailyVendorInventoryReportByManufacturing, DailyVendorInventoryReportBySourcing	2023-05-15	New tables.
CatalogItems	2023-04-19	New table. File upload required to add CatalogItems table.
PromotionsPerformanceReport	2023-02-17	API calls now start with 00:00
RetailProcurementOrdersStatus, MarketBasketAnalysisReport, RepeatPurchaseBehaviourReport	2022-12-19	New tables
Source	2022-11-22	New Belgium marketplace added
APlusContentDocument	2022-11-09	New table
PromotionsPerformanceReport	2022-11-09	New table