Skip to content
master
Switch branches/tags
Code

Latest commit

Files

Permalink
Failed to load latest commit information.

Power BI Custom Connector for WooCommerce

This is a simple Power BI Custom Connector for Wordpress' WooCommerce. It currently only connects to the Orders endpoint to retrieve all the orders information from the WooCommerce tables.

WooCommerce Custom Connector

Requirements:

  • Wordpress instace with WooCommerce 2.6.x or later
  • API Key and Secret key with Read Access

Optional:

  • WooCommerce Subscriptions plug in

For complete information on how to get the credentials (REST API key and secret) for your connection, you can get the full walkthrough from this page http://woocommerce.github.io/woocommerce-rest-api-docs/#authentication

Configuring the Connector for your site

  1. Enable the WooCommerce API on your site from Settings Menu of the WooCommerce plugin as shown in the next image:

WooCommerce API enabled

  1. Download the WooCommerce.mez file from this repo
  2. Follow the instructions on https://github.com/Microsoft/DataConnectors#quickstart on where to store that .mez file
  3. Load Power BI Desktop and navigate to the connector. Is good to go!

Our Testing Environment

If you'd like to give this custom connector a try, we encourage you to try it first against our testing environment. It is a low budget wordpress site hosted on Azure, but it does provide the necessary protocols and backend/frontend to make the connector work.

Here's the data of our testing environment:

  • Url for the Store: https://powerquery.shop
  • API Version: v3
  • API_username: ck_5a76a7e5b8747552b0cbb87e8a9992cff9ec6f3b
  • API_password: cs_dfc407ce96c79d4538641362d810a2f31d54efc4

Go ahead and place some orders on the online store of our testing environment! Tweet me a screenshot of the order confirmation on Twitter :)
Note: Please beware of posting sensitive information on the order as it'll be visible to everyone.

Submit your feedback, suggestions and more on the Issues section of this Repo!

Special thanks to Miguel Llopis and Marco Russo for coming up with the request/idea for this Custom Connector.

About

A Power BI Custom Connector for WooCommerce

Topics

Resources

License

Releases

No releases published

Packages

No packages published