Essential Attributes, All Report Types and Tables for Amazon Vendor Central
Essential Attributes, All Report Types and Tables for Amazon Vendor Central
About Amazon Vendor Central
Amazon Vendor Central is a platform that enables businesses to sell their products directly to Amazon as a vendor. This allows vendors to access a larger customer base, leverage Amazon's distribution network, and benefit from streamlined order fulfilment and payment processes.
Amazon Vendor Central as a connector in Daton facilitates the seamless integration of data from Amazon Vendor Central into your data warehouse. It enables businesses to extract, transform, and load (ETL) data, providing a unified and centralized view of their operations.
Key benefits of using the connector include:
- Efficient Data Transfer: Daton's connector ensures smooth and efficient data transfer from Amazon Vendor Central to your data warehouse.
- Real-time Insights: Gain real-time insights into your vendor operations, inventory, and order management.
- Streamlined Analytics: Utilize the power of analytics by consolidating Amazon Vendor Central data with other business data sources in your warehouse.
Integrating Amazon Vendor Central as a source connector in Daton empowers businesses with a comprehensive understanding of their vendor operations on the Amazon platform. By leveraging this connector, users can harness the full potential of their data to drive informed decision-making and enhance overall business performance.
In this article, we will look at the essential attributes and tables supported by the Amazon Vendor Central connector.
Find the links to other articles related to Amazon Vendor Central below:
Essential Attributes
Features |
Details |
|---|---|
Connector Status |
Stable |
API Version |
v2 |
Custom Scheduling |
NA |
Templates |
NA |
Authentication Parameters |
Amazon Seller Username and Password |
Replication Type |
Key Based Incremental |
Replication Key |
Date |
All Report Types and Tables
This section helps you with detailed data categorization in Amazon Vendor Central, providing in-depth information for efficient navigation and analysis. Explore individual table schemas for a comprehensive understanding of underlying data structures.
To explore the list of Amazon Vendor Central APIs currently offered by Daton with detailed schema information see, Amazon Vendor Central Schema Detail.
To discover the extensivity of Amazon's Vendor Central Reports see, Vendor Retail Analytics Reports & Vendor Retail Reports Attributes.
Categorization of Tables in Vendor Central
Click on each of the categories to expand.
Real-Time Reports
| VendorRealTimeSalesReport |
| VendorRealTimeTrafficReport |
| VendorRealTimeInventoryReport |
Daily Reports
The list of Daily Report Tables available for Amazon Vendor Central in Daton is as follows:
| MarketBasketAnalysisReport |
| NetPureProductMarginReport |
| VendorTrafficReport |
| DailyVendorInventoryReportByManufacturing |
| DailyVendorInventoryReportBySourcing |
| VendorBusinessSalesReportByManufacturing |
| VendorBusinessSalesReportBySourcing |
| VendorFreshSalesReportBySourcing |
| VendorFreshSalesReportByManufacturing |
| PromotionsPerformanceReport |
| VendorSalesReportByManufacturing |
| VendorSalesReportBySourcing |
Weekly Reports
The list of Weekly Report Tables available for Amazon Vendor Central in Daton is as follows:
| VendorInventoryReportByManufacturing |
| VendorFreshInventoryReportByManufacturing |
| RepeatPurchaseBehaviourReport |
| VendorFreshInventoryReportBySourcing |
| VendorInventoryReportBySourcing |
Monthly Reports
The list of Monthly Report Tables available for Amazon Vendor Central in Daton is as follows:
| MonthlyVendorInventoryReportByManufacturing |
| MonthlyVendorInventoryReportBySourcing |
Raw Tables
The list of Raw Tables available for Amazon Vendor Central in Daton is as follows:
| RetailProcurementOrdersStatus |
| APlusContentDocument |
| RetailProcurementOrders |
| CatalogItems |
The list of Snapshot Report Tables available for Amazon Vendor Central in Daton is as follows:
| VendorForecastingReport |
| VendorFreshForecastingReport |
A few enhancements have been made to the Amazon Vendor Central connector. These updates include the implementation of look back logic, attribution incremental split, and periodic attribution. These upgrades enable users to correct historical data and get incremental data quicker.
Look back logics
The default is a 'look back until' value of 7 days, i.e., jobs fetch data for the last seven days every day.
Look back after
Daton's enhanced look back logic feature enables users to correct past data.
Users can access data for specific dates by specifying multiple integers like 5, 10, or 15. For instance, on May 15, one can retrieve the current day's data (May 15) along with the data from the previous days, including April 30, May 5, and May 10.
This configuration on the backend is concocted to give Daton users greater flexibility to accommodate changes in historical data. 'look back after' is turned off and 'look back until' is the default mechanism.
Look back until
With look back until, Daton enables you to obtain historical data within a specified timeframe.
As an example, if today is May 15, by setting a single integer, such as 7, the system automatically fetches data from May 8 to May 15. The number can be increased or decreased as per data requirements. The default value for Vendor sales reports is a look back until value of 7 days.
Reach out to our support team to enable this feature.
Attribution Incremental Split
Even if the current day's data is not immediately available for certain tables, our system makes separate attempts to fetch it.
Considering today is May 15 and data from May 12 onwards is missing, Daton makes separate API calls to fetch data for May 13, May 14, and May 15. This ensures that one can retrieve data whenever it is available beyond the SLA given by the SP-API. The SLA for most Vendor reports is 72 hours from the current time.
Periodic Attribution
This can be used when a pattern of changing data is observed over a certain time span.
Periodic attribution operates by running the past x days of data every y days. One can specify the number of days desired, to re-fetch the data, along with the frequency of this re-fetch.
Most customers prefer fetching the last 90 days of data every 30 days because there are minor changes in sales data over the previous three months. By default, this is turned off.
Contact our support team if you have additional questions or want to enable these features in your integrations.