I have a website with Woocommerce.
When I have a new order, I receive a feed to N8N.
In all of the actions that are carried out I would like to send an email to different users detailing what is contained in the order.
The problem being that the number of products is not always the same and therefore I do not see how to combine the different products of the order in an email.
I do not know if I am clear in my request.
Do you have any idea how I might do this?
Best regards
Lionel
Can you post the data you receive so we can play with it?
You should be able to just loop over the array “line_items” and create a row for every entry, using the data you want to display (name, quantity, total?).
Yes quite. But I must admit that I have never performed this type of operation.
It is for this reason that I ask for some advice 
Post the data you have as screenshot as text in a
Blockquote
so it’s easy to copy and use. Or do you expect people to write it down by themselves from the screenshot? 
Probably also good to just read through the docs if you haven’t checked them yet!
Sorry
[
{
“order_details”: [
{
“id”: 3,
“name”: “Sac”,
“product_id”: 220,
“variation_id”: 0,
“quantity”: 1,
“tax_class”: “”,
“subtotal”: “37.19”,
“subtotal_tax”: “0.00”,
“total”: “37.19”,
“total_tax”: “0.00”,
“taxes”: [
],
“meta_data”: [
{
“id”: 39,
“key”: “_reduced_stock”,
“value”: “1”,
“display_key”: “_reduced_stock”,
“display_value”: “1”
}
],
“sku”: “”,
“price”: 37.19,
“parent_name”: null
},
{
“id”: 4,
“name”: “Veste”,
“product_id”: 214,
“variation_id”: 0,
“quantity”: 1,
“tax_class”: “”,
“subtotal”: “150.03”,
“subtotal_tax”: “0.00”,
“total”: “150.03”,
“total_tax”: “0.00”,
“taxes”: [
],
“meta_data”: [
{
“id”: 40,
“key”: “_reduced_stock”,
“value”: “1”,
“display_key”: “_reduced_stock”,
“display_value”: “1”
}
],
“sku”: “”,
“price”: 150.03,
“parent_name”: null
}
]
}
]
Many thanks for sharing @Lyoto!
I’ve put a quick example workflow together that uses your example data and writes it into a single string field (which you can then send out via email). It uses some JavaScript logic:
message.And this is the resulting email:
Is this what you had in mind?
Edit: This would work fine while your workflow only processes a single cart at a time. If there are multiple carts we might need to adjust our logic slightly. It would actually become simpler, since we could just iterate over each line item directly and wouldn’t need to convert the line items into n8n items beforehand (but the data structure would be harder to read).
Thank you, this is the solution!
I’m looking at how I know how to implement this in my system.
A big thanks
Awesome, glad to hear this works for you, thanks so much for confirming
Have a nice day and please do let us know if you run into any trouble down the line!
I just tried to implement this in my workflow but I’m stuck on one last element.
How do I get the data I have in a set to automatically fit into function.
I have a SET with a STRING which has the name order_details.
Sorry, definitely a silly question 
So the Function node can access items through the $item() method or the items array.
So if you set order_details in a workflow like this:
You could refer to order_details in your Function node using items[0].json.order_details.
Perfect, thanks for taking over @MutedJam !
And now I know the preformatted text is better than the blockquote for sharing code.
Ah yes, I think that might have been some mixup earlier
I definitely prefer the preformatted text as it will prevent all formatting from being applied. Either using this button or by manually putting three backticks ``` before and after my code:
