• 3 Minutes to read
  • Dark


  • Dark

Article Summary

Available Endpoints

Currently, these datasets are available in Dataddo:

  • Coupons
  • Customers
  • Orders
  • Product Variations
  • Products
  • Subscriptions

All available endpoints from the WooCommerce API are listed here.

WooCommerce Consumer Key and a Consumer Secret

When configuring the WooCommerce connector you need to generate a Consumer Key and a Consumer Secret.

  1. Log in to your WooCommerce account. Go to Settings, click on the Advanced tab, and select REST API.

  2. Select the option Add Key, which will take you to the Key Details screen.
    WooCommerce- API key 1

  3. Add a Description to the Key, select the User you would like to generate an account, select the type of Permission for the API key (Read, Write or Read/Write). Click on Generate API Key.
    WooCommerce- API key 2

  4. Copy the Consumer Key and the Consumer Secret, and insert them into Dataddo.
    WooCommerce- API key 3

How to create a WooCommerce Source

  1. Sign in to your Dataddo account and click on Sources at the top of the page.

  2. Click on Create Source in the top right corner.

  3. Select the connector from the list of sources. You can type the name of the connector into the search bar to find it faster.
    Data sources - choose connectors

  4. First, select the required Dataset and click on Next.

    • NOTE: If you are not sure which Dataset you need, but you know which Metrics and Attributes you are looking for, you can use the Search by Name or Attribute function or you can browse through all the possible Attributes and Metrics for each Dataset by clicking on the specific Dataset.
      WooCommerce - dataset
  5. From the drop-down menu, choose your Account connected to Dataddo, Analytics Account, Property, and View. Click on Next to continue with the setup.

    1. Didn't find your account?
      If you want to connect a new account that is not on the list, click on Add New Account at the bottom of the drop-down. You will be redirected to the authorization/sign-in page to confirm the right account.

      • NOTE: To generate your Consumer Key and Consumer Secret, follow these steps.
        The Domain is the link used to access your account, for example, www.yourdomain.com.
    2. Authorize Your Account
      If you have not authorized your Account with Dataddo, click on Add New Account and you will be redirected to the authorization/sign-in page.
      WooCommerce - authorization

    3. After you log in and give Dataddo the necessary permissions to access your data, you will be redirected back to the connector.

  6. Choose a Name for your Data Source, and select the Metrics and Attributes. To continue to the next page, click Next.

    • NOTE: The Metrics and Attributes depend on the Dataset you selected in the previous step. If you need different Metrics and Attributes, go back two steps and change the Dataset.
      WooCommerce - metrics
  7. Configure your snapshotting preferences by choosing your Sync frequency. Under Advanced setting,s you can select the exact Time, of synchronization. Confirm your setup by clicking on Next.
    If the Data range is available to select, you can load historical data. Read more in our guide.

  8. Before saving the source, you can see a preview of your data by clicking on the Preview button. you can adjust the date range to a more specific view.

    • Also, you can see the full list of the metrics you selected by clicking on Show all Metrics and attributes, in the left navigation.
      Data source - create - preview
  9. Click on Save and your new Data Source is ready.

Congratulations, your new Data Source is ready!

Broken View / Error Message

If you cannot see a preview of your data, go back a few steps and check your setup. The most common causes are:

* Date range - we recommend a smaller date range. If you need to load historical data, check our guide.
* Invalid metrics, attributes or breakdowns, or their combination - you may not have any values for them.
Data source -create- error

Need assistance?

Feel free to contact us and we will help you with the setup. To speed the process of resolving your issue, make sure you provide us with sufficient information.

Was this article helpful?

What's Next