Before you connect
The following are required:- A WooCommerce shop account.
- HTTPS enabled on the site, which is required to transmit credentials safely.
- The shop URL — the WordPress site’s public URL, for example
https://myshopname.com. - A WooCommerce REST API Consumer Key and Consumer Secret with Read permission, generated from the WooCommerce admin. See the official WooCommerce REST API documentation for how to generate API keys.
Connect WooCommerce
1
Select WooCommerce
On the Data Sources page, search for WooCommerce and select it.
2
Enter the API credentials and shop URL
Fill in the required fields. Enter the Consumer Key and Consumer Secret generated in the WooCommerce admin, then enter the Shop URL (for example
https://myshopname.com). Only the Read permission is required on the key.3
Name the data source
Enter a Name for the data source as it will appear in the connections list. Use a readable, distinguishable name.
4
Submit
Click Submit to complete the connection. The initial sync runs in the background — data typically becomes available within one to three business days.
What gets imported
The connector imports the product catalog and orders for the connected store. Orders, gross and net revenue, refunds, tax, shipping, discounts, payment method, order source, and product-level performance are all exposed. Order status, currency, and revenue follow the store’s WooCommerce configuration. For the complete list of metrics, breakdowns, and refresh behavior, see the WooCommerce data reference.Troubleshooting
Authentication fails with a credentials error
Authentication fails with a credentials error
WooCommerce REST API authentication requires HTTPS. Stores still running on HTTP cannot transmit consumer keys safely and will reject the connection. Enable HTTPS on the WordPress host — most providers include free Let’s Encrypt certificates — then retry the connection.
Revenue figures include refunded orders
Revenue figures include refunded orders
WooCommerce surfaces refunds through two metrics. Order refund amount holds the positive refund total tied to an order, while order net sales reflects order total minus shipping and tax for active orders, zero for cancelled or on-hold orders, and a negative value on refund rows. Use net sales for true net revenue reporting.
Product-level metrics exclude orders for deleted products
Product-level metrics exclude orders for deleted products
Product order metrics link orders to products that are currently active in the catalog. Orders for products that have since been deleted may not appear in product-filtered reports. Reserve product order metrics for product-level breakdowns rather than top-line revenue.
Related
WooCommerce data reference
Metrics, breakdowns, and refresh behavior for WooCommerce.
WooCommerce FAQs
Common questions and expected behaviors for the WooCommerce data source.
How to connect Shopify
Connect an alternative direct-to-consumer commerce platform.
