---
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-05-06T11:44:23Z
published: 2026-05-06T13:26:01Z
---

> ## 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](/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](/v1/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 instructions on [how to connect to a data source from the Supermetrics Hub](/v1/docs/how-to-connect-to-data-sources-from-supermetrics-hub).

You can also connect to WooCommerce from these destinations:

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

## More information

- [How to reauthenticate a data source in Google Sheets, Looker Studio, Excel, or Power BI](/v1/docs/how-to-reauthenticate-a-data-source-connection-in-google-sheets-looker-studio-excel-power-bi-and-supermetrics-hub)
- [How to reauthenticate a data source in data warehouse, API, or cloud storage platform](/v1/docs/how-to-reauthenticate-a-data-source-connection-in-data-warehouse-destinations-or-the-supermetrics-api)
- [How to manage data source connections on the Supermetrics Hub](/v1/docs/how-to-manage-data-source-connections-on-supermetrics-hub)