Text Aggregator does not output line item data in final file – nothing is passed through
Hi everyone,
I’m working on an integration between Shopify and FTP using Make. The goal is to:
-
Watch orders from Shopify
-
Filter only those with a specific product or metafield (e.g., “zeitfracht”)
-
Generate a custom .edi file
-
Include dynamic order and line item data (like SKU, title, quantity, and price)
-
Upload the file to FTP
I use a Text Aggregator module (Module [4]) after iterating over the line items (via Iterator [3]). Inside the Text Aggregator, I format each line like:
LIN+++{{sku}} EN’
IMD+A++:::{{title}}’
QTY+21:{{quantity}}:PCE’
PRI+AAA:{{price}}::LBL:1:PCE’
However, in the final file that gets generated and uploaded, the placeholder {{4.text}} is either empty or not included at all – no line item information shows up, even though everything seems mapped correctly.
I’ve tried:
-
Referencing {{4}}, {{4.text}}, {{4[1].text}}, etc. – nothing works
-
Checking the output of the Text Aggregator manually – it does contain data
-
Switching Source Module in the Text Aggregator (required field)
-
Confirming that the Iterator and Text Aggregator run successfully with content
Still, the line item section in the final .edi file is always missing.
Does anyone have an idea why the output of the Text Aggregator isn’t passed on properly in the next module (Text/Dropbox)? Is there a known bug or workaround for this?
Thanks!!
Hey there,
do you mind sharing a screenshot of the final module setup so we can see what it looks like?
Could you have a look already to the screenshots?
Can you show a screenshot of the scenario it self and what the output and input bundles look like? The configuration looks OK so far.
This is the output file. But there is missing the information of the product. SKU , Title, Quantity and discounted price.
And the selection before with the filter also doesn’t work correctly.
Hello, could you have the time to have a look? Thanks!!
Sorry but can you show some overall pictures of what the scenario looks like, what the output and input bundles are and what is getting processed where?
Looks like you have a bunch of text aggregators, but some of them are getting data from iterators, some from shopify modules, there is a set variables module feeding data as well.
Most likely the data you are looking for is getting lost somewhere between the different aggregations.
Hello Stoyan, here is an overall picture. What do you mean with output and input bundles?
Of the modules.
I see you are aggregating twice, which is not a good idea. Generally you do one aggregation per array. Are you aggregating different things here? Or trying to restructure the first aggregation?
Yes different things. On module 4 SKU, Title, etc. And Modul 5 the rest of the information. But Modul 4 doesn’t work - because it should show the information in Modul 5. Have a look at the screenshots.
Put a router after the shopify module and do each aggregation separately. Then after the first aggregation, add a set variables module to store the output and after the second aggregation use a get variables module to get the output from the first one.
Im Not sure what do you mean? Because how to bring the file / input together for the edi. file? Is it possible to have a short meeting with you? Would be awesome!
That is what the Set and Get variable modules are doing.
Set the source module of your second aggregator to the Iterator as well and built your second text string.
Then have the rest of your scenario after the Get Variables module.
Hello Stoyan, it still doesn’t work. Modul 4 doesn’t create an output. So it cannot be sourced in the final file…
This is the output of Modul 5:
UNA:+.? ’
- UNB+UNOY:4+4012345678901:14+4026725000077:14+251031:1158 +10687683035404’
- UNH+10687683035404+ORDERS:D:01B:UN:EAN010’
- BGM+220+ #2486+9’
- DTM+137:20251031:102’
- NAD+BY+4012345678901::9’
- NAD+IV+4012345678901::9’
- NAD+SU+4026725000077::9’
- NAD+DP+++:Felix+Scharf+Hochallee 113+20149+Hamburg+DE’
- RFF+IT:#2486’
- CUX+2:EUR:9’
- UNS+S’
- UNT+18+ 10687683035404’
- UNZ+1+10687683035404’
The Part of Modul 4 is still missing.
In the screenshot the filter blocked it, it didn’t execute at all.
Hello Stoyan,
now it works. Her is the output. But I would like to set the filter. Because it should upload only specific edi. files. How can I filter it? I tried it with metafield in shopify. But then it blocked.
UNA:+.? ’
UNB+UNOY:4+4012345678901:14+4026725000077:14+251031:1245 +10687810797836’
UNH+10687810797836+ORDERS:D:01B:UN:EAN010’
BGM+220+ #2498+9’
DTM+137:20251031:102’
NAD+BY+4012345678901::9’
NAD+IV+4012345678901::9’
NAD+SU+4026725000077::9’
NAD+DP+++:Röttinger+Eugen+Robert-Dick-Weg 5+89077+Ulm+DE’
RFF+IT:#2498’
CUX+2:EUR:9’
LIN+++EM-L1045:EN’
QTY+21:1:PCE’
PRI+AAA:{“amount”:“30.0”,“currencyCode”:“EUR”}::LBL:1:PCE’
UNS+S’
UNT+18+ 10687810797836’
UNZ+1+10687810797836’
What are you trying to filter for? Maybe you can check before the aggregation happens?
