Amazon Vendor Central Connector

Amazon Vendor Central Connector, **powered by Windsor.ai**, delivers all your sales, inventory, and purchase order data directly into Snowflake, no pipelines required. Access fully structured, query-ready data for fast, reliable analysis.

**1. Scope & value**

- **Complete, always up-to-date Amazon sales data**Stream sales reports, inventory levels, and purchase order details from Amazon Vendor Central directly into the Snowflake database of your choice.
- **Query-ready on arrival**Fully typed tables (no VARIANT columns) load incrementally, enabling analysts to run sales and inventory analyses with plain SQL seconds after each load.
- **Runs 100% inside your account**The Native App executes in-warehouse, inheriting Snowflake’s security, governance, and role-based access controls.
- **Zero maintenance**Windsor.ai automatically handles schema evolution, backfills, retries, and rate limits so you can focus entirely on insights.

**2. Sample tables & schemas**

- **AVC_SALES_REPORTS**(grain: date, ASIN) – Sample fields: report_date, asin, product_title, shipped_units, shipped_cogs, customer_returns, _load_timestamp.
- **AVC_INVENTORY_REPORTS**(grain: date, ASIN) – Sample fields: report_date, asin, product_title, sellable_on_hand_units, unsellable_on_hand_units, aged_90_plus_days_units.
- **AVC_PURCHASE_ORDERS**(grain: PO number, ASIN) – Sample fields: po_number, po_date, expected_delivery_date, asin, product_title, ordered_quantity, accepted_quantity, received_quantity, _load_timestamp.

**3. Expected workflow for data consumers**

1. Install the Amazon Vendor Central Connector.
2. Authenticate with Amazon Vendor Central.
3. Pick your vendor group.
4. Choose your destination database/schema (tables are created automatically).
5. Query and share – join with other business data, feed dashboards, or securely share downstream via Snowflake Secure Share.

原始信息汇总

Amazon Vendor Central Connector 数据集概述

数据集基本信息

• 提供商: Windsor.ai
• 访问权限: 免费
• 访问模式: Unlimited Access
• 数据刷新频率: Static Data

数据集价值与范围

1. 完整且实时更新的亚马逊销售数据

   • 直接从Amazon Vendor Central获取销售报告、库存水平和采购订单详情。
   • 数据完全结构化，查询就绪，无需VARIANT列。

2. 100%在用户账户内运行

   • 继承Snowflake的安全、治理和基于角色的访问控制。

3. 零维护

   • 自动处理模式演进、回填、重试和速率限制。

示例表结构

• AVC_SALES_REPORTS

  • 粒度: date, ASIN
  • 示例字段: report_date, asin, product_title, shipped_units, shipped_cogs, customer_returns, _load_timestamp

• AVC_INVENTORY_REPORTS

  • 粒度: date, ASIN
  • 示例字段: report_date, asin, product_title, sellable_on_hand_units, unsellable_on_hand_units, aged_90_plus_days_units

• AVC_PURCHASE_ORDERS

  • 粒度: PO number, ASIN
  • 示例字段: po_number, po_date, expected_delivery_date, asin, product_title, ordered_quantity, accepted_quantity, received_quantity, _load_timestamp

业务需求

• 销售绩效分析

  • 跟踪产品销售、地理位置和时间段表现。

• 库存管理

  • 构建需求预测模型，优化库存管理。

• 产品盈利能力分析

  • 结合销售数据和成本数据，分析产品盈利能力。

安全特性

• 安全审查: 已完成Snowflake安全审查。
• 访问控制: 基于Snowflake角色的访问控制。
• 推荐权限: 安装后根据需要授予账户级别权限和对象权限。

提供商其他产品

• Stripe Connector
• Instagram Connector
• Xero Connector
• HubSpot Connector
• LinkedIn Ads Connector
• LinkedIn Pages Connector

云区域可用性

• AWS: Africa (Cape Town), Asia Pacific (Jakarta), Asia Pacific (Mumbai), Asia Pacific (Osaka) 等45个区域。

提供商信息

• 联系方式:
  • 销售: [e-mail]
  • 支持: https://support.windsor.ai/
• 关于: Windsor.ai帮助连接325+个营销、分析、销售和CRM平台，并将数据流式传输到Snowflake。

搜集汇总

背景与挑战

背景概述

该数据集通过Windsor.ai技术将Amazon Vendor Central的销售、库存和采购订单数据直接接入Snowflake，提供开箱即用的结构化数据表。其特点包括自动维护、实时更新、安全内嵌执行，并支持销售报告、库存报告和采购订单三类核心业务数据的分析。