Help CenterContact support
All Columna: Order Export & Sheets articles

How do I upload scheduled exports to an FTP or FTPS server?

Updated

On this page
  1. Set it up
  2. Verify it worked
  3. Change the server or password
  4. If an export keeps failing
  5. Troubleshooting

A scheduled export can upload its file to an FTP server instead of emailing it, for example to a warehouse, 3PL or ERP that only offers FTP. The file lands in a folder on that server every few hours, every day, week or month, or a few minutes after each new order. This is part of the Pro plan. If your server also offers SFTP, prefer SFTP (see “How do I upload scheduled exports to an SFTP server?”).

Set it up

  1. In the app, open Settings and pick Scheduled email exports, then click Add scheduled export (or open an existing one).
  2. In File, enter a name and choose the template and file format.
  3. In Delivery, choose FTP or FTPS server under Deliver to.
  4. Choose the Encryption:
    • FTPS with explicit TLS (recommended): the usual FTPS, on port 21.
    • FTPS with implicit TLS: older FTPS servers, usually on port 990.
    • None (plain FTP): the password and the orders travel unencrypted. Use it only when the server offers nothing else.
  5. Enter the Host (for example ftp.warehouse.example, without ftp://) and the Username and Password of the FTP user. Leave Port empty to use the usual port of the encryption you chose.
  6. In Folder, enter the folder the file goes to, such as /inbound. Leave it empty to use the folder the user logs in to.
  7. If your server only accepts known addresses, allow the address shown under the folder (“Columna connects from …”).
  8. Click Test connection to check the settings before saving.
  9. Choose the schedule and the orders to include, then click Save in the bar at the top of the page.

When you test or save, the app logs in, writes a small test file to the folder and deletes it again. Columna always connects in passive mode and checks the server’s TLS certificate, which must come from a public authority and match the host name. A self-signed certificate is refused.

Verify it worked

  • After Test connection you see “Connection works. Columna can write files there.”
  • After saving you see “Settings saved”. Click Send now in Status: the file arrives in the folder within a few minutes.
  • The list of scheduled exports shows “FTP:” and the host for this export.

Files are named like the SFTP uploads, such as daily-orders-2026-10-23.csv, and never repeat. Each file is first written as .part and renamed when complete, so your system never picks up half a file. When there were no orders, nothing is uploaded.

Change the server or password

The password is never shown again after saving. To keep it, leave Password empty. If you change the host, port or username, enter the password again.

If an export keeps failing

While a scheduled export is failing, a red banner on the app’s Home and in Settings names it; click Open export to see the error. Your store’s contact email also gets one email about it, with what to check and a button that opens the export, a reminder every 24 hours while it lasts, and one more email when it works again. A server that cannot be reached is tried again a few minutes later.

Troubleshooting

“The server refused the username or password.” Check the username and password of the FTP user.

“Columna could not connect to the server.” Check the host and port, and that the address shown under the folder is allowed in your firewall.

“The server does not offer the chosen encryption.” The server has no FTPS, or uses the other kind. Try FTPS with explicit TLS on port 21 and FTPS with implicit TLS on port 990.

“The server’s TLS certificate could not be verified.” The certificate is self-signed, expired or made for another name. Ask your provider for a certificate from a public authority, and enter the host name the certificate is made for.

“That address is private or reserved.” The app can only reach servers on the public internet. Enter the server’s public address.

“Columna could not write to that folder.” Check that the folder exists and that this user can write and rename files in it.

“The server has no space left for the file.” Free some space on the server, then use Send now.

Built and supported by StoreFleet, Shopify app developers since 2021.