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.
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
- Enable the WooCommerce API on your site from Settings Menu of the WooCommerce plugin as shown in the next image:
- Download the WooCommerce.mez file from this repo
- Follow the instructions on https://github.com/Microsoft/DataConnectors#quickstart on where to store that .mez file
- Load Power BI Desktop and navigate to the connector. Is good to go!
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.
Special thanks to Miguel Llopis and Marco Russo for coming up with the request/idea for this Custom Connector.