Forum Discussion

exceldoktor's avatar
exceldoktor
New Member
5 years ago

WooCommerce Rest API

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

Need Help
Show and Tell

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

    • Histos's avatar
      Histos
      New Member
      5 years ago

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

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

      • CoderZen08's avatar
        CoderZen08
        Icon for Helper V rankHelper V
        2 years ago

        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

  • exceldoktor's avatar
    exceldoktor
    New Member
    5 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

    • exceldoktor's avatar
      exceldoktor
      New Member
      4 years ago

      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

       

  • BrandonSingh's avatar
    BrandonSingh
    New Member
    1 year ago

    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.