Shopify, NetSuite and FTP: Daily Order Export Template

Each night this Spojit template pulls the day's Shopify and NetSuite orders, builds one combined CSV, and uploads it to an FTP folder your warehouse can pick up.

What It Builds

A Schedule-triggered workflow that runs once a night on a cron expression in your timezone. Connector nodes on the shopify and netsuite connectors list the orders created that day, a Transform node merges them into a single row set, a csv connector node renders the rows as CSV text, and a Connector node on the ftp connector uploads the file to the warehouse drop folder. The result is one dated order file waiting on the FTP server every morning, with no manual export.

The Prompt

Paste this into Miraxa, the intelligent layer across your automation, and it builds the workflow, connecting the tools for you:

Build a workflow that runs every night at 11pm Australia/Sydney time. List today's Shopify orders and today's NetSuite sales orders, combine them into one set of rows with the order number, customer name, date, and total, turn that into a CSV file named with today's date, and upload the file to the /warehouse/orders folder on our FTP server.

Connectors Used

  • Schedule trigger - fires once a night on a 5-field cron expression plus an IANA timezone (for example 0 23 * * * with Australia/Sydney).
  • shopify - list-orders returns the day's online store orders.
  • netsuite - list-sales-orders (or run-suiteql) returns the day's ERP sales orders.
  • csv - from-json renders the combined rows as CSV text.
  • ftp - upload-file writes the dated CSV into your warehouse folder.

Customize It

Change the run time and timezone in the prompt to match your warehouse cut-off, switch the FTP path from /warehouse/orders to your real drop folder, and edit the column list (order number, customer name, date, total) to the exact fields your warehouse expects. You can also narrow the Shopify pull to paid or fulfilled orders only, or point the NetSuite step at a saved search by asking for a run-suiteql query instead of list-sales-orders.

Tips

  • Keep both order-listing steps in Direct mode: the pull is a predictable single tool call per system, so you avoid AI credit cost and get deterministic output.
  • Make sure the shopify and netsuite connections are added under Connections before you run, and that the ftp connection points at the warehouse host with write access to the target folder.
  • Use the date connector to format today's date for both the date filter and the file name (for example orders-{{ today }}.csv) so each night writes a separate, traceable file.

Related

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.