WooCommerce & Catchr: How to connect your data

How to connect WooCommerce to Catchr?

Connecting WooCommerce to Catchr is the best way to make your E-commerce data accessible from any of our destinations.

Once linked, you can find your data on Looker Studio, Google Sheets, PowerBI, Tableau, and BigQuery or create a CSV or JSON feed.

To connect your account to Catchr, you must have:

• You store URL.
• You Consumer Key and Consumer Secret.

If you cannot create an API Key like the one explained in the first step of this tutorial, please ask an administrator to give you the highest level of access and create the Keys for you.

Find your store URL, consumer secret, and consumer key in Woocommerce.

WooCommerce Store URL

Open your Woocommerce Store. Your Store URL is everything before "/wp-admin" in the URL.

For Catchr, it looks like this: https://catchr-ecom.io/

You must create a new API Key for each store if you have multiple stores.

And the URL for each store will look like this: https://catchr-ecom.io/fr

Consumer Key and Consumer Secret

Go to the menu WooCommerce -> Settings -> Advanced -> RestAPI:

• Here, click Add Key. 
• In Description, name your key. In User, indicate the owner of this key (it should be you if you are creating it).
• In Permissions, choose Read.

Click Generate API Key.

Copy and paste your consumer key and secret. WooCommerce won't show it to you again, and you will have to create a new one if you lost them.

Create your Catchr Source

Login to Catchr and go to Source -> Add a new Source.

Select the WoocCommerce Integration under the Ecommerce menu:

Then name your Catchr Source and click Connect my account:

• Paste your Store URL.
• Paste your Consumer Secret
• Paste your Consumer Key

Click next. If everything went fine, you can see your store name in your Catchr Source, like this:

Click save. You can now find your WooCommerce data in every destination Catchr can connect to.

Starting with Looker Studio:

Go to our WooCommerce connector for Looker Studio, go through the authorization steps and select you account in the dropdown. Then click connect.

The next page shows the available field in this WooCommerce data source. You can click Create Report to start creating a report.

Starting with Google Sheet:

Start by installing our Google Sheets add-on. Then, go to :

• Extensions -> Catchr - Data connector -> Launch.

‍

From here, you can access all account linked to Catchr and generate a request that will import data for you (and schedule your request to be launched automatically).

You'll find here a complete tutorial to use Google Sheets with WooCommerce.

Starting with PowerBI, BigQuery, and CSV or JSON format:

Go to the API menu on Catchr. Here is your interface for creating a new request.

First, select your format. Then, build your request. This will generate a web URL.

You can then copy and paste this URL wherever you need it.

Here's a complete tutorial on creating a request for PowerBI (it will work the same way for Tableau).