WooCommerce Connector

WooCommerce Connector — Snowflake Native App by Windsor.ai

**Sync every order, customer, product and refund from WooCommerce straight into Snowflake — fully typed, auto-refreshing, and secured by Snowflake RBAC.**<br/>The connector streams the entire WooCommerce reporting surface — 71 metrics and 338 dimensions — directly into warehouse tables that analysts can explore with plain SQL, no CSV exports or custom scripts needed.

What the app delivers

- **Order-level facts** – revenue, discounts, taxes, fulfilment status and refund amounts.
- **Customer-360 attributes** – total spent, orders count, first / last order dates and tags.
- **Product & inventory details** – SKU, category, price, stock status and variations.
- **Typed, flat schemas** – every column has a native Snowflake type (no VARIANT).
- **100 % in-warehouse ELT** – the job runs inside Snowflake, inheriting your security policies.
- **Zero maintenance** – OAuth refresh, historical backfills, incremental loads, retries and schema drift are all handled automatically by Windsor.ai.

Setup — up & running in < 5 minutes

1. **Install** “WooCommerce Connector by Windsor.ai” from Snowflake Marketplace.
2. **OAuth** to the store(s) you manage (API key / secret).
3. **Choose** look-back window and refresh cadence (hourly, daily or custom).
4. Data lands in the database / schema you specify; Windsor.ai keeps it continuously fresh.

Sample tables

**WOOCOMMERCE_ORDERS_DAILY** — grain: date × order<br/>order_id, order_created_at, order_status, order_currency, order_total, order_discount_total, order_tax_total, order_shipping_total, order_refunded_total

**WOOCOMMERCE_ORDER_ITEMS** — grain: order × line item<br/>order_id, product_id, product_name, product_sku, item_quantity, item_subtotal, item_total

**WOOCOMMERCE_CUSTOMERS_DAILY** — grain: date × customer<br/>customer_id, customer_email, customer_first_name, customer_last_name, customer_country, customer_total_spent, customer_orders_count

(The connector also exposes product, coupon, refund and tax tables — all using the same typed-column approach.)

原始信息汇总

WooCommerce Connector 数据集概述

数据集基本信息

• 提供方: Windsor.ai
• 访问权限: 免费且无限制访问
• 数据更新频率: 静态数据

数据集内容

核心数据表

• WOOCOMMERCE_ORDERS_DAILY

  • 粒度: 日期 × 订单
  • 包含字段: order_id, order_created_at, order_status, order_currency, order_total, order_discount_total, order_tax_total, order_shipping_total, order_refunded_total

• WOOCOMMERCE_ORDER_ITEMS

  • 粒度: 订单 × 行项目
  • 包含字段: order_id, product_id, product_name, product_sku, item_quantity, item_subtotal, item_total

• WOOCOMMERCE_CUSTOMERS_DAILY

  • 粒度: 日期 × 客户
  • 包含字段: customer_id, customer_email, customer_first_name, customer_last_name, customer_country, customer_total_spent, customer_orders_count

数据范围

• 包含71个指标和338个维度
• 涵盖订单、客户、产品、退款和税务数据
• 采用类型化平面架构，所有列均使用原生Snowflake类型

技术特性

• 100%在仓库内进行ELT处理
• 自动处理OAuth刷新、历史回填、增量加载、重试和架构漂移
• 数据在Snowflake内部运行，继承用户的安全策略

业务应用场景

• 实时收入和平均订单价值跟踪
• 订阅用户获取和保留分析
• 归因分析（可与Google Ads、Meta Ads、TikTok或GA4等300多个数据源混合）

安全特性

• 通过Snowflake安全审查
• 采用基于角色的访问控制(RBAC)保护数据
• 在Snowflake原生应用框架中设计安全

云区域可用性

• AWS: 支持非洲（开普敦）、亚太（雅加达）、亚太（孟买）、亚太（大阪）等49个区域

支持信息

• 销售联系: [e-mail]
• 技术支持: https://support.windsor.ai/

搜集汇总

背景与挑战

背景概述

WooCommerce Connector是一个Snowflake原生应用，可将WooCommerce的71个指标和338个维度数据（包括订单、客户、产品等）自动同步到Snowflake数据仓库，提供类型化表结构并支持SQL直接查询。该应用具备完全在仓库内运行的ELT流程、自动维护功能，并可在5分钟内快速设置，确保数据安全且持续更新。