Woocommerce detail about product quantity, product name and total

[Nek0ret]

I would like to record all line items name and number from Woocommerce completed orders.

For example:

Order Number: #10000
Order Item:
1x Pen
2x Pencil
4x Paper

Pen is $1 for each
Pencil is $4 for each
Paper is $3 for each

and the Payment fee is $5
in the google sheet will be like

Order ID	Order Detail	Total	Fee
#10000	1x Pen, 2x Pencil, 4x Paper	21	5

I only can do "Line Items 0 Quantity"x "Line Items 0 Name", "Line Items 1 Quantity"x "Line Items 1 Name", "Line Items 2 Quantity"x "Line Items 2 Name"... etc

Is there a way for list up and record all line items and their quantity, name and total for Google sheet?

 

[Pabblymember11]

Hey @Nek0ret

You can try the Line Itemizer action step in your workflow for your concern to arrange the line items in comma separate values.

 

[Nek0ret]

Hey @Nek0ret

You can try the Line Itemizer action step in your workflow for your concern to arrange the line items in comma separate values.

Hello,

The different part is Woocommerce doesn't have the json data. This video might not answer my question.

 

[Fagun Shah]

Hello,

The different part is Woocommerce doesn't have the json data. This video might not answer my question.

Which format you want? Format 1 or Format 2?

 

[Nek0ret]

Which format you want? Format 1 or Format 2?

View attachment 17147

Format 1 Plz

 

[Fagun Shah]

Format 1 Plz

I think that is not possible without custom coding or pabbly team introducing functionality like Zapier's "Line-Item to Text".

But I would still tag @Supreme @Pabbly to confirm it.

 

[Pabblymember11]

Hey @Nek0ret

As of now the feature which you are looking for is not available on the platform but you can post the request to add the feature here -

https://pabbly.hellonext.co/

 

[Nek0ret]

I think that is not possible without custom coding or pabbly team introducing functionality like Zapier's "Line-Item to Text".

But I would still tag @Supreme @Pabbly to confirm it.

Is there a way for format 3, which is something like this:
1, 2, 4, Pen, Pencil, Paper

 

[Fagun Shah]

Is there a way for format 3, which is something like this:
1, 2, 4, Pen, Pencil, Paper

Capture woocommerce data with simple response turned off.

Then use Data Transformer -> Line Itemizer with Line Items array from WC, which will comma separated values,

which you can later map in gsheet field side by side.

 

[Nek0ret]

Capture woocommerce data with simple response turned off.

Then use Data Transformer -> Line Itemizer with Line Items array from WC, which will comma separated values,

which you can later map in gsheet field side by side.

It doesn't have an all Line Items, do I need to array each line item name from Woocommerce?

 

[Nek0ret]

Which format you want? Format 1 or Format 2?

View attachment 17147

Sorry, one more question, how to do format 2