Best answer

Create Line Items in Google Spreadsheet from WooCommerce

  • 16 September 2021
  • 3 replies
  • 113 views

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.

icon

Best answer by Troy Tessalone 16 September 2021, 02:07

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +14

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

Userlevel 6
Badge +6

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

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