Data out from formatter is not importing to my next step
I am working on integrating Shopify to Monday.com and I need the orders to separate into line items. From reading various threads, I need to use the formatter utility to split the text to line items. I have tried to import to Monday.com and also tried to import first to a Zapier table, it is the same problem either way.
The formatter looks to work correctly, the data output is separated. When I try to import to a zapier table or monday.com it reverts backs to a single line item. What am I doing wrong?
In Step 2, the formatter looks to work correctly and there are separate line items in the data output:
.
In step 3, I import data to tables, I have mapped the formatter output
but the data input seems to revert to the original text again and not individual lines
Page 1 / 1
I have a few guesses, but I’d need to see more complete screenshots of your setup and configuration steps.
Also, you should confirm that Monday and/or Tables support line-items. If they don’t, you’ll have to use a Looping feature too.
Hi @hellothere888!
How are things going on this—were you since able to get this sorted on your own?
If so, we’d love it if you could share some details on what the solution was, for the benefit of others in the Community.
And if not, it could be that the Formatter transform isn’t correct. Usually I’d expect to see line the Text to Line-item transform output fields like this:
Instead of nested like this:
So I think the values you’ve selected from Shopify may already be line items so there’s no need to convert them to line items again using that Formatter action. If you’re wanting all the line item values to go into the same field in a single Tables record then you’d just select the line item field from the Shopify action:
For example:
And if you want to create a new record for each line item then you’ll want to move that Create Record action inside a Loop (use the Create Loop from Line Items action). You can learn more about using loops here: Loop your Zap actions
Can you give that a try let us know how that goes?
Looking forward to hearing from you!
Hi @SamB, thank you this is getting me closer.
I have been able to split the orders using the loop. However, the final export is only the first line item of the order. Ignore the formatting step, it is just splitting a column to two.
My overall zap
In Looping, I selected Create loop from line items
I input my values to loop
and the test comes out showing the separate line items
In step 4 of my zap, I have input the order number from Shopify (as each line has the same line number) and for the fields above, i.e. quantity, I have used the loop output
This doesn’t add all line items to Monday.com it is only adding the first one.
Thanks for your help.
Hi @hellothere888,
Have you published the Zap? Testing the Looping step won’t yield expected results unless the Zap has been published. You can learn more about that here:
