How can I use Zapier Loop to format an itemized order?
I am trying to post new shopify orders to Monday.com via Zapier. For each new order, Monday.com will create an item in the board. However, when I try to use Zapier Loop for each item in the order, unformatted result come out.
What I expect the result should be like:
iterate 1:
name: Selena Modular…
quantity: 1
SKU: m710…
Price: 3499.00
Variant: Fabric/….
Properties:
iterate 2:
name: xxxx
quantity: 1
SKU: xx…
Price: 3499.00
Variant: xxx
Properties:
Here is what I get from test:
Page 1 / 1
Hi @harveysun
Good question.
You need separate fields for each data point you are trying to use in the line items to Loop.
Thanks for follow up, here is what I got after I followed your instruction. I declared five values, I did get five values, but one value was missing and it generated another one:”Item Name_Chaise” and “Item Name_weeks”.
When I try to use the data generated by the Loop to create a subitem inside Monday.com’s Board.
This is the test result from creating a subitem. I think the result is not quite right. And I only recieve one subitem.
@harveysun
Help article that will explain the issue related to how some of the line item data values are formatted which is resulting in Named Variables:
@harveysun
NOTE: Line Items are split based on comma delimiters, so if a Line Item Parameter Value includes a comma you can encounter unexpected results with the number of Line Items returned from the Looping app.