Shopify to FTP: Daily Orders CSV Drop Template

A scheduled Spojit workflow that lists the day's Shopify orders, converts them to a CSV file, and uploads that file to an FTP server for a 3PL or accounting system.

What It Builds

A Schedule trigger fires once a day on the cron and timezone you set. A Connector node on shopify lists the orders created in the last 24 hours, a Connector node on the csv connector turns that order list into a CSV file, and a final Connector node on ftp uploads the file to a destination folder. The result is a fresh dated orders file waiting for your fulfillment or finance partner each morning, with no manual export.

The Prompt

Paste this into Miraxa and it builds the workflow, connecting the tools for you:

Build a workflow that runs every day at 6am Australia/Sydney on a Schedule trigger, lists all Shopify orders created in the last 24 hours, converts that order list into a CSV file with the order number, customer name, email, total, and created date as columns, and uploads the file to my FTP server in the /orders folder named orders-{{ scheduledAt }}.csv.

Connectors Used

• Schedule trigger - runs the workflow daily on a cron schedule and timezone.
• shopify - lists the day's orders with list-orders.
• csv - builds the file from the order list with from-json.
• ftp - uploads the file to your server with upload-file.

Customize It

Change the cron time and timezone for your warehouse hours, swap the FTP folder path or filename pattern, and edit the column list in the prompt to match what your 3PL or accounting system expects. To filter to paid or unfulfilled orders only, name that condition in the prompt before you run it.

Tips

• Use Direct mode on each Connector node here: the steps are predictable single-tool calls, so you avoid AI credit cost.
• Add the scheduledAt date to the filename so each day's drop is unique and never overwrites the last.
• Confirm your FTP connection with verify-connection before the first scheduled run.

Related

• Want the step-by-step? See How to Export Orders to CSV via FTP.
• How to Schedule a Daily Inventory Sync.
• Setting Up a Schedule Trigger.