Skip to main content

Hi all,


I am working in a board which populates per Shopify order, using a Zap from Zapier. All the information I need from Shopify is successfully getting into my board, and it’s populating the board one order per item line. When there are multiple line items, though, they populate in the following format:


SKU: “SKU-001,SKU-002,SKU-003”

Price: “100.00,88.00,15.99”

Currency: “USD,USD,USD”

Name:“BlueShirt,RedShirt,GreenShirt”


Ultimately, I need to split these line items into separate values so that I can create invoices and track values individually. I feel as though this probably should be done via subitems, but I’m open to other solutions. This feels like an issue that would be encountered in any integration with a NoSQL data set, so I’m surprised there isn’t an existing solution. Is there an easy way to break these into individual components without adding dozens of columns with formulas that break it up using “mid” or “search” functions?

Hello there @mpwolner and welcome to the community!


I hope you like it here 💪


If I understand correctly, you have a board which has at least 4 columns: SKU, Price, Currency and Name.


Then you have items coming via Zapier that look like this:


SKU: “SKU-001”

Price: “100.00”

Currency: “USD”

Name:“BlueShirt”

But sometimes you have multiple items together such as:


SKU: “SKU-001,SKU-002,SKU-003”

Price: “100.00,88.00,15.99”

Currency: “USD,USD,USD”

Name:“BlueShirt,RedShirt,GreenShirt”

And you want to know how to divide it into three separate items.


I believe in this case, the best way to do so could be to use “code” action in Zapier when you have multiple items together, and to create a script that divides it into multiple items, and then sends it to the action that populate the monday board.


But if anyone else has been in this situation and has another solution, it would be great to hear about it!


Cheers,

Matias

I faced something similar with my own board setup using Zapier and Shopify. When I pulled in multiple line items, everything came in as a big lump too, and it was a hassle to sort out.What worked for me was reaching out to the team at refinedcommerce.com for some tips. They suggested using a custom code step in Zapier to split the line items before they got to my board. It made a huge difference! You can write a simple JavaScript function to take those concatenated strings and break them into separate arrays for SKU, price, and name.Once it’s split up, you can create subitems or just make it easier to generate invoices. If you need help with the code, there are tons of resources online, or you could ask the community here for specifics.

Reply


Terms & ConditionsCookie settings