How do I split comma-separated ShipStation order data into separate Monday.com columns using Zapier?

Question

Hello!

I am trying to inherit order data from Shipstation to a monday.com board.

On orders with multiple line items - Shipstation adds them but as comma-separated values. It does this on the product name, part number, and quantity. I was able to format and split the text in the Formatter by Zapier - but when I send it all to Monday.com it gets sent as one Item (Column) and doesn't know to split those fields into multiple columns.

For clarity - right now it’s outputting:

Order number - Quantity, 1,1,1, Product Code, 1234,4567,2736, and product name (Soap, Shampoo, Conditioner) all into one Monday board/item instead of splitting the quantity - product code, and product name into multiple Monday boards/items.

Troy Tessalone · Answer

Hi @benihana242The data is likely output from ShipStation as an array of line items, so you may not need to use a Formatter step to split the data.You can iterate thru each line item using this Zap action: Looping - Create Loop from Line ItemHelp with Looping: https://zapier.com/apps/looping/help

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded