Help CenterContact support
All Columna: Order Export & Sheets articles

How do I upload scheduled exports to an SFTP 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 SFTP server instead of emailing it, for example to your warehouse, 3PL or ERP. 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.

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 SFTP server under Deliver to.
  4. Enter the Host (for example sftp.warehouse.example, without sftp://), the Port (22 unless your server uses another one) and the Username.
  5. Choose the Login method:
    • Password: enter the password of that user.
    • SSH key: copy the line in Columna public key and add it to the authorized_keys file of that user on your server.
  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. Choose the schedule and the orders to include, then click Save in the bar at the top of the page.

When you save, the app logs in and checks that the folder exists. It writes nothing during this check.

Verify it worked

  • After saving you see “Settings saved” and “Server key: SHA256:…”. This is your server’s fingerprint; the app only uploads to a server that shows the same key.
  • Click Send now in Status. You see “Upload requested”, and the file arrives in the folder within a few minutes.
  • The list of scheduled exports shows “SFTP:” and the host for this export.

Each file is named after the export and the day, such as daily-orders-2026-10-23.csv. With Every hour(s) the name also has the hour the period starts, such as warehouse-picks-2026-10-23-1300.csv; with Every new order it has the time the batch ends, to the second, such as new-orders-2026-10-23-131245.csv. File names never repeat, so no upload overwrites an earlier one. On the night the clocks go back, a name in the repeated hour also carries the UTC offset, such as -023000+0100. The extension follows the File format: .csv, .xlsx, .tsv, .json or .xml, and .txt for pipe-separated files or when Save delimited files as .txt is ticked in Settings › File format. It 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.

With Every new order, the orders placed close together go into one file a few minutes after they are placed, and each order is uploaded once, as it was when it was placed. An order that matches your filters only later, for example one that is paid later, is not uploaded; use Every hour(s) for that. See “How do I get an order export by email every day, week or month?” for which orders each schedule includes.

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, as soon as the export needs a fix from you or after two failed sends in a row, with the error, what to check and a button that opens the export. A reminder follows every 24 hours while it lasts, and one more email says when it works again. A period with no orders is not a failure. The usual causes are a changed password or key, a firewall that no longer allows Columna’s address, or a moved server; the troubleshooting below says what to do for each.

Troubleshooting

“The server refused the username, password or key.” Check the username and password, or that the Columna public key is in authorized_keys of that 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.

“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 use that folder.” Check that the folder exists and that this user can write to it.

“The server’s key changed since it was saved.” If you moved or reinstalled the server, enter the password again and save to trust the new key; with SSH key login, delete the export and add it again. If you did not change the server, contact your server provider first.

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