WooCommerce has no official Looker Studio connector. But unlike Shopify, its nature as a self-hosted WordPress plugin opens a route that SaaS platforms can’t offer: you own the database, and you can connect to it directly.

This guide covers the three available methods, their real tradeoffs, and the WooCommerce-specific quirks that will skew your reports if you ignore them.

Method 1: Direct MySQL access

This is WooCommerce’s structural advantage. Looker Studio has a free native MySQL connector — and your order data lives in a MySQL database you control.

What you need for this to work:

  • Hosting that allows remote MySQL connections (many shared hosts block them by default)
  • Looker Studio’s IP ranges allowed through your host’s firewall
  • A dedicated read-only MySQL user, never your main one

Advantages: free, real-time, complete access with no API limits.

Real limits: WooCommerce’s base schema is awkward. Orders historically live in WordPress’s posts and postmeta tables, with the data scattered across key-value pairs, which makes SQL queries unintuitive. WooCommerce introduced dedicated order storage (HPOS, High-Performance Order Storage) that simplifies this considerably, but not every store has it enabled. Check which storage mode your installation uses before writing any queries — it determines how complex they’ll be.

A security note: opening your database to external connections is never trivial. Restrict allowed IPs strictly, use a read-only account, and enable SSL for MySQL connections if your host supports it.

Method 2: The WooCommerce REST API

WooCommerce exposes a complete REST API, enabled from the settings with generated API keys.

Advantages: safer than direct database access, stable across updates, and aligned with WooCommerce’s business logic — an order returned by the API arrives cleanly assembled, unlike raw database rows.

Limits: Looker Studio doesn’t natively connect to arbitrary REST APIs. You’ll need either a third-party connector supporting WooCommerce, or an intermediary — typically a script that queries the API and feeds Google Sheets or BigQuery.

Method 3: Third-party connectors

Some services (Supermetrics, Windsor.ai, Coefficient and similar) offer WooCommerce connectors, but the market is noticeably thinner than for Shopify — WooCommerce installations are more fragmented and technically heterogeneous.

Expect pricing similar to Shopify connectors (roughly $20-40/month at entry level), and verify before paying that the connector handles WooCommerce’s refunds and order statuses properly, since these are more numerous and more customizable than on Shopify.

The WooCommerce-specific pitfalls

Custom order statuses. WooCommerce lets you create custom statuses, and many extensions add their own. A query counting “completed” orders can miss orders that were genuinely paid but sit in a custom status. List the statuses actually in use on your store before building any filters.

Test orders and drafts. The pending, failed and checkout-draft statuses, plus orders generated during testing, easily pollute totals if you don’t explicitly exclude them.

Tax. Depending on configuration, stored amounts may be inclusive or exclusive of tax. Verify which before comparing your Looker Studio figures to your accounting — a classic source of discrepancy, easy to fix once identified.

Timezone. WordPress has its own timezone setting, separate from GA4’s and your ad platforms’. If they disagree, daily comparisons never line up — the same problem we cover for Shopify in our revenue discrepancy checklist.

Crossing WooCommerce with your other sources

As with any store, WooCommerce data is your accounting source of truth, and GA4 is for comparing acquisition channels against each other — not for establishing revenue. WooCommerce revenue will systematically exceed what GA4 reports, for the usual structural reasons: blockers, consent refusal, and orders placed outside the standard checkout.

The target architecture for complete reporting is the same as for Shopify: store orders, GA4 sessions and ad spend in one report, each figure labeled with its source — following the structure in our Looker Studio dashboard guide.

FAQ

Is there a free WooCommerce connector for Looker Studio? No official connector exists, but WooCommerce has one advantage over Shopify: direct access to the MySQL database. If your hosting allows remote connections, Looker Studio’s native MySQL connector can read it without any paid third-party service.

Should I use the REST API or direct database access? The REST API is safer and more stable — it survives WooCommerce updates — but slower and more limited in volume. Direct MySQL access is faster and more complete, but exposes you to schema changes on update and requires careful network configuration.

Is GA4 enough to track a WooCommerce store? For behavior and acquisition, yes. For actual revenue, no — GA4 structurally undercounts sales due to blockers, consent refusal, and orders placed outside the standard checkout. WooCommerce data remains your accounting source of truth; GA4 is for comparing channels against each other.