FAQ

What WooCommerce API key permissions do I need?

You only need Read permissions. When generating the key in WooCommerce → Settings → Advanced → REST API, set the permissions dropdown to Read. Write access is not required and is not recommended for security reasons.

Can I export product variations as individual rows?

Not directly. The WooCommerce REST API returns variations as nested data inside each product record, and Coupler.io does not currently expand them into separate rows. As a workaround, use the Orders with line items entity — it includes the specific variation name and ID for each item purchased.

Can I export WooCommerce Subscriptions data?

WooCommerce Subscriptions is a separate plugin that extends the WooCommerce REST API with its own endpoints. These are not currently supported as a dedicated entity in Coupler.io. If this is a feature you need, reach out to Coupler.io support to register your interest.

How does the Search filter work?

The Search parameter filters results by exact match only. For Orders, you can search by customer name (e.g., SMITH) or by a line item title (e.g., HOODIE WITH LOGO). Partial matches, wildcards, and fuzzy searches are not supported — this is a WooCommerce API limitation.

Can I pull data from multiple WooCommerce stores into one destination?

Yes. Add each store as a separate source within the same data flow, connecting each with its own API credentials. Then use the Append transformation to combine the data into a single table in your destination. You may want to add a custom column to tag each row with the store it came from.

Why am I getting a "non-JSON response" or "line 1 column 1 (char 0)" error?

This almost always means something between Coupler.io and your WooCommerce REST API is returning an HTML page instead of JSON. The most common causes are Cloudflare firewall rules, a wrong store URL (e.g., using HTTP instead of HTTPS), or a redirect loop. See the Connection Issues section for detailed fixes.

Can I export custom fields added by third-party plugins?

Custom meta fields are not included in standard WooCommerce REST API responses unless the plugin explicitly registers them as REST API fields. Coupler.io exports what the WooCommerce API returns, so if a field isn't in the API response, it won't appear in your export.

What's the difference between Orders and Orders with line items?

Orders gives you one row per order, with order-level totals and customer details. Orders with line items expands each order into one row per product purchased, which is what you need for product-level revenue analysis, COGS calculations, or category-level reporting. For most analytical use cases, Orders with line items is the more useful entity.

How do I load historical data without timing out?

Use the After date and Before date filters to break your export into smaller chunks — for example, one export per quarter. You can run these as separate sources in one data flow and use the Append transformation to combine them. Once you have your historical baseline loaded, switch to incremental syncs using the After date filter set to a recent date.

Can I send my WooCommerce data to an AI tool like ChatGPT or Claude?

Yes. Coupler.io supports AI destinations including ChatGPT, Claude, Gemini, Perplexity, Cursor, and OpenClaw. You can send your WooCommerce sales or product data directly to these tools for analysis, summaries, or automated reporting.

For a full breakdown of available fields and metrics, see the Data Overview article. For connection errors and troubleshooting steps, see Common Issues.