We are a Shopify Ecommerce Store.
We work with a small International shipping service that creates shipping labels manually for us whenever we update the order information in a shared Google Sheets.
I have a process for orders with 1 item, no problem.
But if an order has multiple items, I need to figure out a way to condense a specific detail of the order’s line items into one cell.
For example, an International customer buys 3 items, quantity 1 of each: A Shirt, A Hat, and Glasses.
Shopify sends the line items separately in an array within the overall order information. I need to figure out how to put the product titles of each item in one google sheets cell separated by commas. I also need the Qty of each separated by commas.
So cell A2 is Shirt, Hat, Glasses
Cell B2 is 1,1,1
I know I can iterate. And I know there’s an array aggregator tool, but not sure how that works or if that will work for my use case.
Any and all help is appreciated in advanced!