Last updated
Was this helpful?
Last updated
Was this helpful?
The Daasity integration for Amazon Vendor Central provides daily insights into sales, traffic, and inventory at the product level ("ASIN"), and provides comprehensive analysis of product performance on Amazon.
Availability: all Enterprise merchants
Refresh Cadence: daily
Dashboards
Omnichannel Sales Dashboard
Amazon Vendor Central Dashboard
Explores
Amazon Vendor Central Sales Explore
Amazon Vendor Central Traffic Explore
Amazon Vendor Central Inventory Explore
Entity Relationship Diagram (ERD)
The integration leverages multiple source tables that are interconnected within Daasity’s data model. The ERD for this integration illustrates how sales, traffic, and inventory data are joined by ASIN and date keys across different reports.
Click here to view the ERD for Amazon Vendor Central Integration
These tables are available through the Amazon Vendor Central API, extracted daily.
Sales, COGS, and return metrics by product ASIN and date.
Update Method: UPSERT
Table Name: [amazon_vendor_central.get_vendor_sales_report]
Consumer web traffic to product pages at the ASIN and day-level, measuring consumer interest (number of views) and the effectiveness of the product listing (conversion rate of views > transactions).
Update Method: UPSERT
Table Name: [amazon_vendor_central.get_vendor_traffic_report]
Provides inventory metrics by product and date, detailing stock levels, aging inventory, lead times, sell-through rates, and unhealthy inventory. The data is organized by ASIN and distributor view.
Update Method: UPSERT
Table Name: [amazon_vendor_central.get_vendor_inventory_report]
Endpoint:
Endpoint:
Endpoint:
start_date
start_date
asin
asin
distributor_view
distributor_view
customer_returns
customer_returns
end_date
end_date
ordered_revenue_amount
ordered_revenue_amount
ordered_revenue_currency_code
ordered_revenue_currency_code
ordered_units
ordered_units
report_run_date
report_run_date
selling_program
selling_program
shipped_cogs_amount
shipped_cogs_amount
shipped_cogs_currency_code
shipped_cogs_currency_code
shipped_revenue_amount
shipped_revenue_amount
shipped_revenue_currency_code
shipped_revenue_currency_code
shipped_units
shipped_units
start_date
start_date
asin
asin
end_date
end_date
glance_views
glance_views
report_run_date
report_run_date
start_date
start_date
asin
asin
distributor_view
distributor_view
selling_program
selling_program
aged_90_plus_days_sellable_inventory_cost_amount
aged_90_plus_days_sellable_inventory_cost_amount
aged_90_plus_days_sellable_inventory_cost_currency_code
aged_90_plus_days_sellable_inventory_cost_currency_code
aged_90_plus_days_sellable_inventory_units
aged_90_plus_days_sellable_inventory_units
average_vendor_lead_time_days
average_vendor_lead_time_days
end_date
end_date
net_received_inventory_cost_amount
net_received_inventory_cost_amount
net_received_inventory_cost_currency_code
net_received_inventory_cost_currency_code
net_received_inventory_units
net_received_inventory_units
open_purchase_order_units
open_purchase_order_units
procurable_product_out_of_stock_rate
procurable_product_out_of_stock_rate
report_run_date
report_run_date
sell_through_rate
sell_through_rate
sellable_on_hand_inventory_cost_amount
sellable_on_hand_inventory_cost_amount
sellable_on_hand_inventory_cost_currency_code
sellable_on_hand_inventory_cost_currency_code
sellable_on_hand_inventory_units
sellable_on_hand_inventory_units
unfilled_customer_ordered_units
unfilled_customer_ordered_units
unhealthy_inventory_cost_amount
unhealthy_inventory_cost_amount
unhealthy_inventory_cost_currency_code
unhealthy_inventory_cost_currency_code
unhealthy_inventory_units
unhealthy_inventory_units
unsellable_on_hand_inventory_cost_amount
unsellable_on_hand_inventory_cost_amount
unsellable_on_hand_inventory_cost_currency_code
unsellable_on_hand_inventory_cost_currency_code
unsellable_on_hand_inventory_units
unsellable_on_hand_inventory_units
vendor_confirmation_rate
vendor_confirmation_rate
This page will help you learn about the Amazon Vendor Central integration and provide technical specifications for working with the Amazon Vendor Central source tables and Daasity data models.