Skip to main content

Hi all.

I'm trying to get my orders from Woocommerce separated into lines instead of commas.

At the moments, I'm getting a multiple product order separated by comma.
Quantity row:
1,3,2
Product row:
blue shirt, black shirt, yellow shirt

I'd like to have it separated in lines.
Quantity
1
3
2
Product row:
blue shirt
black shirt
yellow shirt

So when I read it, it would look like this:
Client    Quantity    Product
John      1               blue shirt
              3               black shirt
              2               yellow shirt

I've already tried using Line Itemizer, but continue receiving the data with commas.

Hi @fdv 

Options to try…

GSheets: Create Rows

Formatter > Utilities > Line Items: https://zapier.com/help/create/basics/use-line-items-in-zaps

Looping: https://zapier.com/apps/looping/integrations

Code: https://zapier.com/apps/code/help


Hi @fdv , Please use loops by Zapier. That will solve your problem.


Thanks for your suggestions and help.
I've got it sorted.