---
title: "WooCommerce connection guide"
slug: "woocommerce-connection-guide"
description: "Connect your WooCommerce data to Supermetrics with essential permissions, consumer key, and store URL. Fetch sales and order metrics easily!"
updated: 2026-07-08T11:55:44Z
published: 2026-07-08T11:55:44Z
canonical: "docs.supermetrics.com/woocommerce-connection-guide"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# WooCommerce connection guide

This guide contains all permissions and requirements for connecting your WooCommerce data to Supermetrics.

You can connect to data sources from the [Data sources page on the Supermetrics Hub](https://hub.supermetrics.com/token-management). On the Hub, you can also [share an authentication link](https://docs.supermetrics.com/v1/docs/how-to-connect-to-data-sources-from-supermetrics-hub#share-authentication-link) to connect to a data source you don't have direct access to.

After you connect to the data source on the Hub, you can use the data source connection in [all available destinations](/docs/woocommerce-connection-guide#connection-instructions).

## Required permissions

To pull data from WooCommerce, the Analytics section must be enabled in your web store on the WooCommerce side. A role of **Shop Manager** or higher is required.

To connect Supermetrics to your WooCommerce store, you'll need a consumer key, consumer secret, and store URL.

- The key and secret can be obtained from WooCommerce. Go to **WooCommerce** → **Settings** → **Advanced** → **REST API**. WooCommerce's documentation has [detailed steps to get the key and secret](https://woocommerce.com/document/woocommerce-rest-api/#generate-api-keys).Note that prior to WooCommerce version 3.4, the key generation was located at **WooCommerce** → **Settings** → **API** → **Key/Apps**.
- The store URL can be obtained from the address bar when you log in to Wordpress. The store URL must include `https://` at the beginning. Copy only the first part of the address, for example `https://example.com`, and leave out the rest of the URL.

## Query types

Query types define what sort of metrics and dimensions are available. You need to select one of the following query types when pulling data.

- **Sales overview**: Report the overall sales for the store.
- **Sales by product**: Fetch key sales metrics by product.
- **Orders**: Fetch details of orders for your store in a certain time range.
- **Order items report**: Fetch detailed data of all the order items sold in a certain time range.

> [!NOTE]
> Note
> 
> The Orders and Order items report are not currently available in the Data Studio destination.

## Connection instructions

When connecting to WooCommerce, you need to enter your consumer key, consumer secret, and store URL and select a store and query type when prompted.

1. Select the WooCommerce data source [on the Supermetrics Hub](https://hub.supermetrics.com/token-management) or in the data destination.
2. Insert your consumer key, consumer secret, and store URL.
3. If prompted, choose to make this connection [shared or private](/v1/docs/about-shared-and-private-connections).
4. Click **Start**.
5. In your data destination, select a store to fetch data for and query type to use.

See detailed instructions on [how to connect to a data source from the Supermetrics Hub](https://docs.supermetrics.com/docs/how-to-connect-to-data-sources-from-supermetrics-hub).

You can also connect to WooCommerce from these destinations:

- Google Sheets: [How to connect to a Supermetrics data source in Google Sheets](https://docs.supermetrics.com/docs/how-to-connect-to-a-supermetrics-data-source-in-google-sheets)
- Data Studio: [How to connect data sources to Data Studio](/v1/docs/how-to-connect-data-sources-to-data-studio)
- Excel: [How to connect data sources to Excel with Supermetrics](https://docs.supermetrics.com/docs/how-to-connect-data-sources-to-excel-with-supermetrics)
- Power BI: [How to create your first Supermetrics query for Power BI](https://docs.supermetrics.com/docs/how-to-create-your-first-supermetrics-query-for-power-bi)
- The Supermetrics API: [How to use the Query Manager](https://docs.supermetrics.com/docs/how-to-use-the-query-manager)
- Data warehouse and cloud storage (Hub): [How to create a transfer](https://docs.supermetrics.com/docs/how-to-create-a-transfer)
- BigQuery (marketplace): [How to create a BigQuery (marketplace) transfer](https://docs.supermetrics.com/v1/docs/how-to-create-a-bigquery-marketplace-transfer)

## More information

- [How to reauthenticate a data source connection](/v1/docs/how-to-reauthenticate-a-data-source-connection)
- [How to manage data source connections on the Supermetrics Hub](https://docs.supermetrics.com/docs/how-to-manage-data-source-connections-on-supermetrics-hub)