Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi There,

I am really struggling with the shopify new order trigger and line items. Probably just a me problem but hoping someone can square my head around the issue.  The trigger has line item suport but i dont understand why some line items seem to “work” (as in actually put data into a spreadsheet line by line as expected) and some seem to just puke all their data into a single cell.

My example: Processing this using the Create Spreadsheet Row(s) in Google Sheets action

 

Results in the tax lines price being put in its entirety into every row, rather than one per item as it should be:

 

I see that its in square brackets and the other line item fields are not, but i have been unable to find any help as to what that means. Sorry if this is a very basic question!

 

Thanks.

Hey! It’s not a basic question - You’re getting into the advanced Zapier concepts here.

Square brackets means that it’s an array of data, so if you need this on a separate line, you will need to break this array up, because as you can see -

  • Your other line items are arrays
  • But your tax line is an array of arrays

The problem is I’m not sure why it’s coming through like that from Shopify, but in to solve this you will need to find a way to turn this array of arrays  into an array of numbers

I would start simple here and use Zapier’s Transform features, perhaps just to see if you can remove the “ “ and “]” from the line -  But if that doesn’t work this might need a bit of code

Hope that helps!

 

 

Hi @Darock999, welcome to the Community! 

 

@Saastronomical is right that what you’re seeing is an array - sort of like a line item of line items.

 

There is a way that you can process the data to get it back a single set of line items (like the other data from Shopify). It’s likely that this can be done with a code step, though you can also do it using a couple of Formatter steps.

 

First, use "Line-item to text" to turn the array Shopify into a text string:

 

This will completely ‘flatten’ the array and convert the whole thing into a text string, with items separated by commas.

Then take the result of this step and run it through "Text to line-item"

 

This takes the text and turns it back into line items, that you can use in the next step. I hope that helps!

Terms & Conditions