All connectors/E-commerce & Payments
WooCommerce
§ Connector
WooCommerce

Connect WooCommerce to your Definite lakehouse in minutes.

Native sync with row-level security, CDC where supported, and hourly-or-faster freshness. Query it with SQL, build dashboards, or ask Fi.

§ What you get

Everything WooCommerce exposes, modeled and queryable.

Extracts WooCommerce store data including products (and variations), customers, orders with line items/taxes/shipping, coupons, refunds, subscriptions, order notes, and key store settings. Enables analysis of sales performance and revenue, product and catalog performance, customer behavior, subscription metrics and churn, coupon usage and discounts, refund rates, and operational settings.

Sync cadence
Hourly or faster
CDC
Native where supported
Auth
OAuth / API key
Row-level security
Yes

Tables & streams

7 objects
Product

Catalog items you sell, including variations/SKUs; enables analysis of product and attribute-level performance, pricing, inventory, and merchandising effectiveness.

productrevenue_finance
Order

Ecommerce transactions with line items, taxes, shipping, and payments; supports reporting on gross/net sales, average order value, fulfillment, and order health.

revenue_financecustomer
Refund

Return and refund events linked to orders; used to track refund rates, revenue leakage, and product- or promotion-driven return patterns.

revenue_finance
Subscription

Recurring billing agreements and schedules; enables MRR/ARR, churn and retention analysis, renewal performance, and subscriber cohort trends.

revenue_financecustomer
Customer

Shopper profiles with contact and address details; supports customer segmentation, lifetime value (LTV), repeat purchase behavior, and geographic insights.

customerrevenue_finance
Coupon

Discount codes and rules with usage data; used to evaluate promotion effectiveness, redemption rates, impact on AOV, and discount-driven margin effects.

revenue_financemarketing
Store Settings

Key configuration like currency and base location that contextualize metrics and enable standardized reporting and currency normalization.

operations
Authentication

Uses your WooCommerce API consumer key and secret via HTTP Basic Authentication

Requirements

Requires a WooCommerce account to connect.

Analyze with Fi

Operational data, performance metrics, and business insights.

Domainsrevenue_finance
§ How it works

Three steps. One afternoon.

01
Connect

Authenticate WooCommerce in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.

definite connect woocommerce
02
Sync

We pull every stream into your lakehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.

→ woocommerce.raw (synced hourly)
03
Query

SQL, dashboards, or ask Fi in plain English. Your WooCommerce data lives next to every other source — ready to join.

SELECT * FROM woocommerce.*
*
Don't see yours?
Any API becomes a Definite connector in minutes.

Build your own with the Definite SDK, or ask us — we add new connectors every week.

Request a connector
§ Related connectors

More e-commerce & payments sources.

Browse all 571 →

Your answer engine
is one afternoon away.

Book a 30-minute call. We'll build your first dashboard on the call — or you can stop paying us.