Skip to main content
Redo can deliver your custom reports as CSV files to a private, read-only SFTP directory on a recurring schedule. This is useful for feeding report data into data warehouses, BI tools, or any system that ingests files.

​
Connection details

Your Store ID is shown in your Redo Dashboard under Settings → Developer → General. The directory is scoped to your store and is read-only — you can list and download files, but not upload or delete them. SSH keys are the best option for automated pipelines: no shared password, and you can register a separate key per system and revoke each one independently.

​
1. Generate a key pair

If you don’t already have a key, generate one on the machine that will connect:
This creates a private key (~/.ssh/redo_sftp) that stays on your machine, and a public key (~/.ssh/redo_sftp.pub) that you register with Redo. Redo accepts ED25519, ECDSA (nistp256/384/521), and RSA public keys.
Only ever share the .pub file. Never upload or send the private key.

​
2. Register the public key in the Redo Dashboard

  1. Copy the public key to your clipboard, e.g. pbcopy < ~/.ssh/redo_sftp.pub (macOS) or cat ~/.ssh/redo_sftp.pub and copy the output
  2. In the Redo Dashboard, go to Settings → Developer
  3. In the SSH Keys card, click Add SSH key
  4. Enter a Name that identifies the system using the key (e.g. “Analytics workstation”)
  5. Paste the public key (one line, starting with ssh-ed25519, ecdsa-sha2-..., or ssh-rsa) and save
You can register up to 10 keys per store. Remove a key from the same card to revoke its access immediately.

​
3. Connect

No password prompt should appear. To make this the default for the host, add an entry to ~/.ssh/config:
Then connect with sftp redo-sftp.

​
Authenticate with an API token

Alternatively, SFTP accepts the same credentials as the Redo API:
  1. In the Redo Dashboard, go to Settings → Developer
  2. Click Add API Client to create an API token if you don’t have one
Your API token is only shown once when created. Store it securely.
Connect and enter the API token when prompted for a password:

​
Schedule a report

  1. In the Redo Dashboard, go to Analytics → Reports
  2. Open the report you want delivered (or create a new one), and save it
  3. In the save dialog, enable the SFTP upload toggle
  4. Choose a delivery schedule
  5. Click Save
You can also enable Email report in the same dialog to send the report to one or more email addresses on the same schedule.

​
File layout

Each scheduled run uploads a new CSV file:
Files from previous runs are kept, so consumers can process files incrementally. Use the timestamp prefix in the file name to identify the latest run.