Hello,
I am creating an automation for woocommerce order to google sheet.
The cell in which i import the sku has only one sku that gets imported even for orders that contain several skus. How can i make it so that orders with more than one product have all their sku in the cell of the sheet?
You can use the built-in join function to join an array of values (SKUs) into a single text string.
e.g.:
{{ join(array_of_skus; ", ") }}
But first you need to get all the skus from the line items, so you need to use the map function.
e.g.:
{{ join(map(1.line_items; "sku"); ", ") }}
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
parseDate | Tokens for formatDate