Schema Information for Amazon Vendor Central

In this article, we will look at the steps to integrate Amazon Vendor Central with Daton.

Find the links to other articles related to Amazon Vendor Central below:

Real Time Reports- Amazon Vendor Central

Real Time Reports within Vendor Central offer data with an hourly granularity, and there is a delay of 60 to 120 minutes before the data becomes accessible. For optimal utilization of real-time reports, it is advised to configure the frequency for these tables to 1 hour. These tables specifically correspond to the Rapid Retail Analytics reports available for vendors.

To know more about the schema of each report table, see Amazon Vendor Central API Schemas.

Table Name	Description	Availability Constraints	History	Incremental Data
`VendorRealTimeSalesReport`	This report shares sales data (ordered revenue and ordered units) at an ASIN level, aggregated to an hourly granularity.	All marketplaces	30 days	last run time to T-65 minutes
`VendorRealTimeTrafficReport`	This report shares data on the customer traffic to the detail pages of the vendor's items with an hourly granularity.	All marketplaces	30 days	last run time to T-115 minutes
`VendorRealTimeInventoryReport`	This report shares highly available inventory data at an ASIN level, aggregated to an hourly granularity.	All marketplaces	30 days	last run time to T-65 minutes

Daily Reports- Amazon Vendor Central

The list of Daily Reports in Vendor Central populates data on a daily basis. Typically, these reports can show historical data up to T-7. The most recent data available on the current day corresponds to T-3. In other words, users can access detailed daily insights, with a focus on the last seven days of historical data and the latest available information from three days ago.

To know more about the schema of each report table, see Amazon Vendor Central API Schemas.

Table Name	Description	Availability Constraints	History	Incremental Data
`DailyVendorInventoryReportBySourcing`	Inventory and operational health metrics such as sellable on hand units and vendor confirmation rate. Mutually exclusive from inventory reports of weekly and monthly granularities.	All marketplaces	1460 days	D-7 to D-3
`DailyVendorInventoryReportByManufacturing`	Inventory and operational health metrics such as sellable on hand units and vendor confirmation rate. Mutually exclusive from inventory reports of weekly and monthly granularities.	All marketplaces	1460 days	D-7 to D-3
`VendorTrafficReport`	Key retail traffic metrics such as detail page views.	All marketplaces	1460 days	D-7 to D-3
`VendorSalesReportBySourcing`	Key retail sales metrics such as ordered/shipped revenue and units.	All marketplaces	1460 days	D-7 to D-3
`VendorSalesReportByManufacturing`	Key retail sales metrics such as ordered/shipped revenue and units.	All marketplaces	1460 days	D-7 to D-3
`NetPureProductMarginReport`	Data on Amazon's net pure product margins for selling a vendor's items.	All marketplaces	1460 days	D-7 to D-3
`PromotionsPerformanceReport`	Data from promotion campaigns to help vendors optimize their promotions and adjust their advertising strategies. The report includes sales from promotions, the types of discounts that were offered, the discount amounts, and how many items were sold as a result of the promotions.	All marketplaces	24 months	D-1
`MarketBasketAnalysisReport`	Items that are most commonly purchased in combination with the items in the customer's basket (cart) at checkout.	All marketplaces	365 days	D-2

Weekly Reports- Amazon Vendor Central

Navigating Weekly Reports

The data in these reports is organized on a weekly basis, with each week spanning from Sunday to Saturday. It's noteworthy that the information for a specific week becomes accessible on the Wednesday of the following week. This structure provides a clear timeline for users to understand and retrieve weekly data.

We suggest you to substitute the Weekly Reports- VendorInventoryReportBySourcing and VendorInventoryReportByManufacturing with the Daily Reports- DailyVendorInventoryReportBySourcing and DailyVendorInventoryReportByManufacturing respectively. This adjustment allows for a more granular and flexible approach to managing inventory data.

It's also important to note that you cannot choose both daily and weekly inventory reports simultaneously.

To know more about the schema of each report table, see Amazon Vendor Central API Schemas.

Table Name	Description	Availability Constraints	History	Incremental Data
`VendorInventoryReportByManufacturing`	Inventory and operational health metrics such as sellable on hand units and vendor confirmation rate. By Manufacturing.	Available in all marketplaces	7 weeks	A week starts on Sunday and ends on Saturday.
`VendorInventoryReportBySourcing`	Inventory and operational health metrics such as sellable on hand units and vendor confirmation rate. By Sourcing.	Available in all marketplaces	7 weeks	A week starts on Sunday and ends on Saturday.
`RepeatPurchaseBehaviourReport`	Quantity of repeated purchases of the selling partner's items.	Available in all marketplaces	1 year	A week starts on Sunday and ends on Saturday.

Table Name

Description

Availability Constraints

History

Incremental Data

VendorInventoryReportByManufacturing

Inventory and operational health metrics such as sellable on hand units and vendor confirmation rate. By Manufacturing.

Available in all marketplaces

7 weeks

A week starts on Sunday and ends on Saturday.

VendorInventoryReportBySourcing

Inventory and operational health metrics such as sellable on hand units and vendor confirmation rate. By Sourcing.

Available in all marketplaces

7 weeks

A week starts on Sunday and ends on Saturday.

RepeatPurchaseBehaviourReport

Quantity of repeated purchases of the selling partner's items.

Available in all marketplaces

1 year

A week starts on

Sunday and ends

on Saturday.

Snapshot Reports- Amazon Vendor Central

Navigating Snapshot Reports

Snapshot reports deliver a real-time view of data captured at the exact moment the report is generated. Unlike other reports, they do not come with a date column, making them reflective of the current data state without historical context. Additionally, snapshot reports do not support incremental data loading, providing a singular snapshot without the ability to track changes over time.

To know more about the schema of each report table, see Amazon Vendor Central API Schemas.

Table Name	Description	Availability Constraints
`VendorForecastingReport`	Report with forward looking mean, P70, P80, and P90 weekly customer demand forecasts. Data is reported at the ASIN level for the most recent weekly forecast generation date.	All marketplaces

Monthly Reports- Amazon Vendor Central

Navigating Monthly Reports

Monthly Reports provide a monthly breakdown of data, offering insights into the activities of each month. Typically, the data for a specific month becomes available after the 3rd day of the following month. Daton processes monthly data once a month, and the information from the next month is processed one month later, ensuring a comprehensive and timely overview of monthly activities.

To know more about the schema of each report table, see Amazon Vendor Central API Schemas.

Table Name	Description	Availability Constraints	History	Incremental Data
`MonthlyVendorInventoryReportByManufacturing`	Inventory and operational health metrics such as sellable on hand units and vendor confirmation rate. By Manufacturing.	Available in all marketplaces	36 months	Fetches monthly data post the 3rd of the next month.
`MonthlyVendorInventoryReportBySourcing`	Inventory and operational health metrics such as sellable on hand units and vendor confirmation rate. By Sourcing.	Available in all marketplaces	36 months	Fetches monthly data post the 3rd of the next month.

Raw Tables- Amazon Vendor Central

Navigating Raw Tables

To know more about the schema of each report table, see Amazon Vendor Central API Schemas.

Table Name	Description	Details
`RetailProcurementOrders`	Returns a list of purchase orders created or changed during the time frame	Real time data. Can fetch historical data up to 6 months.
`RetailProcurementOrdersStatus`	Returns purchase orders statuses. Metrics include ordered, accepted and rejected quantity as well as purchase order acknowledgement and receiving status.	Real time data. Can fetch historical data for the last 6 months only.
`APlusContentDocument`	Returns all A+ Content documents assigned to a selling partner.	Content document is fetched using the contentReferenceKey and it might not available for all keys.
`CatalogItems`	Returns items in the Amazon catalog	This table requires the user to upload a csv file containing ASINs so that the ASINs can be used to fetch getCatalogItems data.

Table of Contents

Real Time Reports- Amazon Vendor Central Daily Reports- Amazon Vendor Central Weekly Reports- Amazon Vendor Central Navigating Weekly Reports Snapshot Reports- Amazon Vendor Central Navigating Snapshot Reports Monthly Reports- Amazon Vendor Central Navigating Monthly Reports Raw Tables- Amazon Vendor Central Navigating Raw Tables

Schema Information for Amazon Vendor Central

Saras Pulse

Saras Daton