Hi,
It's great to see that you now have an excel option available for automation. Thanks for adding this function!
I followed the video tutorial
and was able to successfully replicate all the steps using a brand new spreadsheet.
However, my situation is a bit different and I have two separate issues / questions.
1 - The spreadsheet where I want to input the data from my Woocommerce orders is complex and I'm trying to target a specific Column & Row where to start to output each new order. In other words, the data imported is not Cell A2, B2 and so on, but rather starts on Column L42 and so on... Is there a way to target that specific Column and Row to output the data there ?
2- How do you transform the data from Woocommerce to output something different in the spreadsheet ? For example, the date in Woocommerce orders is in this format: 2022-08-28T06:40:09 and I would like it display as 28/08/22 in my spreadsheet. Another example is what If I have data from Woocommerce that says "2% Manual Bank Transfer" and I just want to ouput in my spreadsheet the words "Bank transfer" or another completely set of words ?
thanks!
Christian
It's great to see that you now have an excel option available for automation. Thanks for adding this function!
I followed the video tutorial
However, my situation is a bit different and I have two separate issues / questions.
1 - The spreadsheet where I want to input the data from my Woocommerce orders is complex and I'm trying to target a specific Column & Row where to start to output each new order. In other words, the data imported is not Cell A2, B2 and so on, but rather starts on Column L42 and so on... Is there a way to target that specific Column and Row to output the data there ?
2- How do you transform the data from Woocommerce to output something different in the spreadsheet ? For example, the date in Woocommerce orders is in this format: 2022-08-28T06:40:09 and I would like it display as 28/08/22 in my spreadsheet. Another example is what If I have data from Woocommerce that says "2% Manual Bank Transfer" and I just want to ouput in my spreadsheet the words "Bank transfer" or another completely set of words ?
thanks!
Christian