# 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](https://docs.coupler.io/sources/category/ecommerce/woocommerce/common-issues) for details

## Quick start

{% hint style="success" %}
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.
{% endhint %}

### How to connect

{% stepper %}
{% step %}
**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.
{% endstep %}

{% step %}
**Create a new data flow in Coupler.io.** Go to your Coupler.io account, click **Add data flow**, and select **WooCommerce** as the source.
{% endstep %}

{% step %}
**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**.
{% endstep %}

{% step %}
**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.
{% endstep %}

{% step %}
**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.
{% endstep %}

{% step %}
**Run your data flow.** Click **Run** to execute a manual sync. Once it completes successfully, your data will appear in the destination.
{% endstep %}
{% endstepper %}

## 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                                                      |