To add a little context, the products that I am exporting from WooCommerce are entries for an art raffle, and each line will be mail merged onto a ticket.  Therefore, if someone purchases 3 tickets for the same item, I would need three separate lines for each entry.

Thanks!

Luke

Hi @LukeSummers 

Try using the Looping app: https://zapier.com/apps/looping/integrations

Thank you for your response @Troy Tessalone, unfortunately after reading the documentation and trying unsuccessfully I’m really not sure how to use the looper to duplicate rows based on the quantity of item.  

Would you mind elaborating on how the looper function should be used?  Would I use text, number or line item, and how do I set the number of duplicate items to be based on the entry to the quantity field.

Thanks for your patience and assistance.

Luke

@LukeSummers 

Try these Zap steps…

1. Trigger: WooCommerce - Line Item in Order
2. Action: Looping - Numbers (you can map the Qty value to the Loop Iteration Counter End)
3. Action: GSheets - Create Row (set a static value of 1 for the Qty)

Hi @LukeSummers 

This is a bit advanced but since Google Sheets’ Create New Line Items action supports line items, it is significantly more efficient to process your line items with a code step and then pass them forward all at once.. Something similar to this should do the trick. 

var finalOutputLines = e];

let qtys = inputData.qtys.split(",");
let items = inputData.items.split(",");

var i=0;
qtys.forEach(qty => {
  while (qty>=1) {
    finalOutputLines.push({qty: 1, item: itemsii]})
    qty--;
  }
  i++
})

return {finalOutputLines}