Question

Separate ShipStation orders to Google Sheets by line item

  • 6 January 2022
  • 1 reply
  • 27 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

Userlevel 7
Badge +14

Hi @it-mwk 

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