WooCommerce Data Connector User Guide

WooCommerce Data Connector User Guide

Our WooCommerce connector provides a wide range of data that can make reporting easy. This article will tell you everything you need to know about how to get the most out of your WooCommerce reports.



Available Data

  1. Performance KPIs - Total sales, net sales, orders, average order value, gross sales, items sold, shipping, returns, discounted orders, net discount amount, order tax, shipping tax, and total tax.
  2. Breakdowns by order status - Canceled, completed, failed, on hold, pending, processing, refunded, and trash.
  3. Product breakdowns - By SKU, URL, names, items sold and net sales.
  4. Category breakdowns - By items sold and total spend.
  5. Customer vs. Guest - See signup counts and compare order amounts by customers versus guests.
  6. Order breakdowns - By order number, status, payment method, and net sales.
  7. Geographic data - Country and US states.
  8. Inventory Reporting - Stock quantity, type, stock status, categories, SKU, product name, and price. Includes images for more dynamic reports.
  9. Complete List of Fields.

API Limitations

Due to problems with WooCommerce's subscription APIs, we currently don't offer them as a part of the WooCommerce connector. These are the items we do not have because they are only included in the Subscription, Subscription Orders, and Subscription Notes APIs:
  1. Order breakdowns by subscription - quantity, taxes, SKU, etc. ordered by subscription ID.
  2. Subscription geographic details - including location, taxes, and fees paid by subscribers.
  3. Notes - Notes that are applied to subscription accounts.
  4. Multi-store accounts - Woocommerce's API does not support multi-store accounts. You must connect each store individually to your Hub.
  5. Custom fields - Custom fields are not available.

Connection Requirements

WooCommerce requires you to create a REST API key in order to connect with Power My Analytics. To create an API key, open WooCommerce and go to Settings > Advanced > REST API.



Click the Add key button.



Generate a new API key.

Creating a new REST API key

Copy your Consumer ID and Consumer Secret.



To add your WooCommerce account as a data source in your hub, enter your site address, your Consumer ID, and your Consumer Secret. Then click Connect.



Cloudflare Users

If your website uses Cloudflare, you will have to configure Cloudflare to whitelist requests from PMA. Requests will originate from the IP address 2600:1900:2000:9::1:600.

How To Connect

The order information we receive from WooCommerce's API includes many possible order statuses. If you would like your reports to match what appears on WooCommerce's dashboard, you must choose only Completed, Pending, and Processing. There are three ways to filter order statuses:

Choose order statuses on the connector configuration screen.

You can choose one or several order statuses from the drop-down box. Select "Allow 'Optional - Order Status Filter' to be modified in reports." if you would like the ability to add or remove order statuses in different charts within your report.



Add a control to your page

In Looker Studio, select Add a control then Drop-down list. Use Order Status for the control field and Order ID for the metric. This control will apply to the entire page.



Create a filter

With your chart selected, click Add a filter in the data menu on the right.



Name your filter, then select:
  1. Include
  2. Order Status
  3. Equal to (=)
  4. Completed, Pending, Processing
Then click Save. This filter will apply only to the chart you had selected.



Backfilling

Power My Analytics will automatically backfill 13 months of data when you first create a report. To get up to 2 years of data, run a manual backfill from your Hub.

Troubleshooting

Not seeing any data?

If you see data in your WooCommerce UI, but not in your report, it may be due to an incompatible plug-in. Contact WooCommerce support to resolve issues with incompatible plug-ins.

All other concerns

Follow the instructions in our Basic Troubleshooting guide to get your reports working again.

    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • eBay Data Connector User Guide

        The following is a guide to automating reports with your eBay Seller connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your eBay Seller reports. To begin creating reports ...

      • BigCommerce Data Connector User Guide

        The following article is a guide to automating reports with your BigCommerce connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your BigCommerce reports. To begin creating ...

      • PayPal Data Connector User Guide

        The following article is a guide to automating reports with your PayPal connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your PayPal reports. To begin creating reports ...

      • Walmart Data Connector User Guide

        The following article is a guide to automating reports with your Walmart connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Walmart reports. To begin creating reports ...

      • Mailchimp Data Connector User Guide

        The following article is a guide to automating reports with your Mailchimp connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Mailchimp reports. To begin creating ...