WooCommerce

WooCommerce is the most popular open-source ecommerce plugin for WordPress, powering millions of online stores worldwide. With Coupler.io, you can automatically pull your WooCommerce store data — orders, products, customers, coupons, and more — into your destination of choice without writing a single line of code.

Why connect WooCommerce to Coupler.io?

• Centralize your store data in Google Sheets, Excel, BigQuery, Looker Studio, or AI tools like ChatGPT, Claude, or Gemini

• Automate reporting on sales, top sellers, coupon usage, and customer behavior on a schedule you control

• Combine multiple entities using Join or Append transformations — for example, join Orders with Customers, or append data from multiple WooCommerce stores

• Export historical data by filtering orders, products, and coupons by date range

Prerequisites

Before connecting, make sure you have:

• A live WooCommerce store with a public-facing URL (not localhost)

• Admin access to generate WooCommerce REST API keys

• WooCommerce REST API enabled (it's on by default in WooCommerce 2.6+)

• If your site uses Cloudflare or another WAF, you may need to whitelist Coupler.io's IP addresses — see Common Issues for details

Quick start

If you want a ready-made report, check whether a WooCommerce template is available in Coupler.io — it can set up your data flow and dashboard in one click.

How to connect

1

Generate your WooCommerce API keys. In your WordPress admin, go to WooCommerce → Settings → Advanced → REST API. Click Add key, set the permissions to Read, and click Generate API key. Copy both the Consumer Key and Consumer Secret — you'll need them in the next step.

2

Create a new data flow in Coupler.io. Go to your Coupler.io account, click Add data flow, and select WooCommerce as the source.

3

Enter your store credentials. Paste your WooCommerce store URL (e.g., https://yourstore.com), Consumer Key, and Consumer Secret into the connection fields, then click Connect.

4

Select an entity. Choose which data you want to export — for example, Orders, Products, or Report: Sales report. Configure any available filters such as date range or order status.

5

Choose your destination. Select where you want your data to land — Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination like ChatGPT or Claude.

6

Run your data flow. Click Run to execute a manual sync. Once it completes successfully, your data will appear in the destination.

Available entities

Entity	Description
Orders	All orders with status, totals, customer info, and metadata
Orders with line items	Orders expanded to one row per line item — ideal for product-level analysis
Products	Full product catalog including prices, stock, and categories
Customers	Registered customer profiles and contact details
Coupons	Coupon codes, discount types, usage counts, and expiry dates
Product categories	Category hierarchy and metadata
Product attributes	Attribute names and terms (e.g., size, color)
Product tags	Tags assigned to products
Product reviews	Review text, ratings, and reviewer details
Product shipping classes	Shipping class names and slugs
Shipping zones	Configured shipping zones
Tax classes / Tax rates	Tax configuration data
Currencies / Countries / Continents	Store localization reference data
Report: Sales report	Aggregated sales metrics for a selected period
Report: Top sellers report	Best-selling products by quantity sold
Report: Order totals	Order count breakdown by status
Report: Product totals	Total product and variation counts
Report: Customer totals	Customer count breakdown
Report: Coupon totals	Coupon usage summary
Report: Review totals	Review count by status