Vendor Central Accounts
Amazon Vendor Central is an invitation-only platform that Vendors use to sell products directly to Amazon.
In the Setup section, you learned how to connect your Amazon Vendor Central Account. DataHawk allows you to connect an unlimited number of Vendor Central accounts you manage using Amazon's Selling Partner API .
Connecting your Amazon Vendor Central account allows you to automatically collect data on critical metrics, including Sales, Product Margins, Inventory, and Traffic.
DataHawk integration works for Sellers registered in all Amazon regions:
- North America: US, Canada, Mexico, and Brazil.
- Europe: UK, Germany, Italy, France, Spain, Netherlands, UAE, Sweden, and Poland.
- Far East: Japan, Singapore, and Australia.
Tip
Solve Vendor Central's reporting limitations and facilitate data consolidation with DataHawk, a robust data storage solution for your critical business data, giving you full data ownership and advanced reporting capabilities
Datasets
Vendor Central Support on DataHawk is currently on BETA and will be updated with new data and features in the near future.
For now, metrics that result from integrating a Vendor Central account can be accessed in a raw format via Connections. This can notably be used to build dashboards on your favorite BI solution.
Overview
The list below highlights a very high-level summary of the currently available datasets on Connections. For now, these are available for Vendors under the Retail Selling Program. Under the Business and Fresh Selling Programs, vendors are encouraged to forward their requests here.
All of the data listed below is available at both Account-level and ASIN-level.
- Vendor's Revenue (Referred to as "Shipped COGS," as this is COGS from Amazon's perspective)
- Amazon's Revenue (Referred to as "Shipped Sales" or "Ordered Sales," as these are sales from Amazon's perspective)
- Units Sold
- Returns
- Product Margins
- Product Page Views
- Inventory
Connections Datasets
Using DataHawk Connections, your DataHawk-powered Snowflake database contains multiple tables about Vendor data. These tables contain a very exhaustive list of data points as columns and are organized into what are called schemas. While Vendor Central support is in Beta, all data is available under the PREVIEW_RAW_VENDOR schema.
These datasets can notably be used to build dashboards on your favorite BI solution. Due to limitations with Amazon's API, these datasets contain data until 72 hours before the refresh. Data is refreshed daily.
To see an exhaustive view of all columns within these tables, refer to our Table & Column Referential.
| Schema | Table | About |
|---|---|---|
| PREVIEW_RAW_VENDOR | RAW_VENDOR_SALES_MANUFACTURING_RETAIL_DAILY | Sales data from the Manufacturing Distributor View. This includes all products under the Vendor's Brand, including those not sourced directly from their inventory. |
| PREVIEW_RAW_VENDOR | RAW_VENDOR_SALES_SOURCING_RETAIL_DAILY | Sales data from the Sourcing Distributor View. This includes all products sourced directly from the Vendor's inventory. |
| PREVIEW_RAW_VENDOR | RAW_VENDOR_PRODUCT_MARGIN_DAILY | Net Pure Margins per Product |
| PREVIEW_RAW_VENDOR | RAW_VENDOR_TRAFFIC_DAILY | Daily Page Views per Product |
| PREVIEW_RAW_VENDOR | RAW_VENDOR_INVENTORY_MANUFACTURING_RETAIL_WEEKLY | Weekly Inventory Breakdown from the Manufacturing Distributor View. This includes all products under the Vendor's Brand, including those not sourced directly from their inventory. |
| PREVIEW_RAW_VENDOR | RAW_VENDOR_INVENTORY_SOURCING_RETAIL_WEEKLY | Weekly Inventory Breakdown from the Sourcing Distributor View. This includes all products sourced directly from the Vendor's inventory. |
Considerations
History
When you connect a Vendor Central account, Amazon's API allows us to pull a maximum of 4 years of data (except for Inventory data, which only covers the last 7 weeks). DataHawk, on the other hand, exhaustively stores and backs up your data, facilitating better reporting with a more extended history.
DataHawk will continue storing your data over time and allow you to export all of the history we stored.
Refresh Frequency & Data Delay
Data is updated daily. For Vendor Central data, there is a 72-hour delay between the data available and the day the data is retrieved/refreshed, due to limitations with Amazon's API.
Coming Soon
Vendor Central Support at DataHawk is still in development. New features will be released in the near future, such as:
- More refined data, including added layers of intelligence in the context of the Vendor's full Amazon ecosystem (similar to our Seller Central Support).
- Support for Business and Fresh selling programs.
We'd like to hear your input! If you have feedback and/or suggestions regarding Vendor Data, please drop them here:
Updated 26 days ago