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

  • 13 May 2024
  • 1 reply



I am trying to inherit order data from Shipstation to a 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 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.

1 reply

Userlevel 7
Badge +14

Hi @benihana242 

The 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 Item

Help with Looping: