> For the complete documentation index, see [llms.txt](https://docs.coupler.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coupler.io/sources/category/ecommerce/woocommerce.md). # 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](/sources/category/ecommerce/woocommerce/common-issues.md) 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 | --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.coupler.io/sources/category/ecommerce/woocommerce.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.