topic Re: WooCommerce Rest API in Developer

WooCommerce Rest API

exceldoktor — Tue, 24 Aug 2021 20:07:23 GMT

Hi Community,

I have a Power BI model, where I on a weekly basis creates a number of csv files from woocommerce, that I import to Power BI.

I would like to automate that process.

I have the possibility to buy a process, that does all of that for me, but for $35 per month and then I can not control anything the way I want it.

Can anyone help with instructions on how to set this up myself.

it seems like an easy thing to do, if you know how to (after all it is just a few csv files that should be connected (as an alternative), but it would be great to know the process as in the future I would like to get my facebook as well as my mailchimp account connected as well.

best regards
Jørgen

Re: WooCommerce Rest API

Anonymous — Wed, 25 Aug 2021 20:14:23 GMT

Jørgen,

One way you could go about this would be to setup a Python script that generates those CSV files for you on a schedule. Just have it update/override the same file, or you can potentially have it email or upload the file to sharepoint and the you can have multiple.

https://pypi.org/project/WooCommerce/

Here's a library for Python that supports connecting to the API for woocommerce. Just make sure that wherever you save the file it is at the same path on the gateway if you are using PBI Service.

Re: WooCommerce Rest API

exceldoktor — Fri, 27 Aug 2021 10:42:48 GMT

I would prefer a dataconnector directly from WooCommerce, but if nothing else shows up, I will be looking seriously into the instructions you did send me.
Hopefully there is a direct solution and I can see that it is possible to create a token in WooCommerce, that I should be able to connect to.
regards
Jørgen

Re: WooCommerce Rest API

Anonymous — Mon, 30 Aug 2021 02:18:32 GMT

Hi @exceldoktor,

I have two ideas to handle with your requirement, you can take a look at the below scenarios if they helped.

#1, Sync data to specify path then use power bi to get data.

1. Create a flow or other type of schedule to sync the woocommerce data to a local device or cloud server(SharePoint/one drive).

2. Use power bi folder connector(local) or web connector(cloud service) to get data from these paths.

Combine files (binaries) in Power BI Desktop - Power BI | Microsoft Docs

Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs

#2, Create a list of key values and use web connector to loop these values with the rest API.

Loop through Multiple Web Pages using Power Query - Adatis

Solved: Pull data from a REST API Authentication - Microsoft Power BI Community

Regards,

Xiaoxin Sheng

Re: WooCommerce Rest API

Rose__123 — Tue, 31 Aug 2021 14:48:44 GMT

Hi Jørgen
Did you find a solution?

Re: WooCommerce Rest API

Histos — Tue, 19 Oct 2021 17:37:14 GMT

Thank you, that sounds very interesting and I will try it.

But is not possible to connect Power BI to the Woocommerce's API??

Re: WooCommerce Rest API

exceldoktor — Wed, 13 Apr 2022 09:33:33 GMT

hi Rose,

I know it is a long time since you asked the question. No I never solved the problem. So far I have been copy and pasting data, which does not work very well.

regards
Jørgen

Re: WooCommerce Rest API

CoderZen08 — Thu, 28 Mar 2024 21:44:42 GMT

Hello @Histos you can export data directly from Woocommerce API to Power BI instead of using CSV files. I connect my Woocommerce data using windsor.ai and I don't need to do any manual or copy/paste work

Re: WooCommerce Rest API

BrandonSingh — Thu, 16 Jan 2025 10:17:08 GMT

You can automate WooCommerce data fetching with its REST API and Power BI’s Web.Contents. For Facebook/Mailchimp later, explore APIs or tools like Skyvia for syncing multiple platforms easily without extra costs.