Skip to main content
Question

Separate ShipStation orders to Google Sheets by line item

  • January 6, 2022
  • 1 reply
  • 55 views

When multi item orders come through to google sheets from shipstation the (Item - Name, Item - Price, Item - Qty and Item - SKU) fields show all the skus from the order on one row as comma separated values.

How do I make it so they each show on individual rows with all of the other corresponding order information as well. ie: Order Number, Shipping Address etc? When I directly export a line item report from shipstation all skus have their own line as shown below. 

 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 6, 2022

Hi @it-mwk 

Try using GSheets - Create Row(s) to handle the line items: