Woocommerce Order Data --> Google Sheets Prefixed columns

[kennethbong]

Hi, I am wondering whether it is possible to export my Woocommerce order data into prefixed columns of my google sheet?

We use this sheet as a template to pack our goods and it's important for the SKUs to be in order

This is a sample of how the final sheet should look like

Pabbly Connect Test

docs.google.com

I'm going to subscribe to Pabbly just for this, hope this can be done!

Thanks!
Kenneth

 

[Pabblymember11]

Hey @kennethbong

It seems like you need to use Data Transformers' Line Itemizer to separate the values of the particular item. And then you can separate the values of the SKU with the help of Text Formatter. Next, you can simply map the separated values directly to the Google Sheets.

Moreover, please give it a try at your end and let us know if get stuck at any place.