Schema Information for Amazon Vendor Central

Need help with something?

Talk to data expert

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

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.

Snapshot Reports- Amazon Vendor Central

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

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

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.
data amazon

Related Articles

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