Shopify Paid order into an excel spreadsheet

Questions
,
1

Looking to take data which comes from a shopify paid order and place that data into a spreadsheet.

The challenge comes in from shopify data coming via an array… one data package which might contain mulitple items in one order.

I can get as far as this code which partly works:

{{ $json[“line_items”][1][“name”] }} Qty:{{ $json[“line_items”][1][“fulfillable_quantity”] }}

This returns the item and quantity of an individual item in the array, in the above code the array item 1.

In this particular order there are 3 items, so 3 items in the array which I want to display all of them not just the one.

So need a loop and a variable in the code which is updated for each item in the array. Is this possible through this section of the tool.

Screenshot 2024-04-29 at 3.24.35 PM
Screenshot 2024-04-29 at 3.24.35 PM2034×1258 163 KB

Information on your n8n setup

  • **n8n version: 1.38.2
  • **Database (default: SQLite)
  • **n8n EXECUTIONS_PROCESS setting (default: own, main)
  • **Running n8n via n8n cloud
  • **Operating system: Mac OSX
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
5

Hey @dft01,

Welcome to the community :raising_hands:

Have you tried using the split out node on the line_items field this will then create one item for each line item so you won’t need to specify the array index.

6

Thanks for this info… that was very helpful