I’m wanting to automate importing order information from my online store into Google sheets. This will mainly be used for a datasheet to keep all sales records listed by order number, buyer, and product.
Currently Make only will import one type of product. It keeps variant information and quantity, but if a buyer purchases multiple products it will only choose one to import into sheets.
I’ve looked through the options for squarespace order and have found nothing, any help?
Hey there,
To include all products purchased in a single order, you need to iterate over each line item within an order and add each as a separate entry in the Google Sheet, or comprise them into a format that would represent all products in a single cell (using text aggregator).
You should use “Iterator” module that goes through each line item in data retrieval.
You could show a screenshot, please. It is not clear to me, and I am in the same situation. A customer buys different products and I need to detail each one in google sheet.
The problem is that only the first product in the list appears in the googlesheets.