Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Schema Information for Amazon Vendor Central

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      • Saras IQ

        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:

        • Setup Instructions for Amazon Vendor Central
        • Essential Attributes, All Report Types and Tables for Amazon Vendor Central

        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.


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

        Was this article helpful?

        Yes
        No
        Give feedback about this article

        Related Articles

        • Essential Attributes, All Report Types and Tables for Amazon Vendor Central
        • Setup Instructions for Amazon Vendor Central
        • Amazon Brand Analytics Search Terms Report
        • Amazon Vendor Central Permissions

        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

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Experts
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Follow Us

        Linkedin Youtube

        Company

        • Customers
        • Partner With Us
        • Contact Us

        Culture

        • About
        • People
        • Careers

        Offerings

        • Daton
        • For Brands
        • For Agencies

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA

        Follow Us

        Linkedin Youtube

        DISCLAIMER: Various trademarks are held by their respective owners

        © 2023 sarasanalytics.com

        Sitemap

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Sales
        DISCLAIMER: Trademarks are held by their respective owners
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Company

        • Customers
        • Partners
        • About
        • People
        • Careers
        • Contact Us

        Offerings

        • Daton
        • Solution for Brands
        • Solution for Agencies
        • Dashboards
        • Founder's Note
        • Status

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA
        • Sitemap

        © 2023 sarasanalytics.com

        Linkedin Youtube

        Knowledge Base Software powered by Helpjuice

        Expand