Upload scheduled exports to Amazon S3 or S3-compatible storage
On this page
A scheduled export can upload its file to a bucket on Amazon S3, or on a service that works like it, such as Cloudflare R2, Wasabi, Backblaze B2 or MinIO. Data teams and ERP imports often read files from there. The file lands in the bucket every few hours, every day, week or month, or a few minutes after each new order. This is part of the Pro plan.
Before you start
Create an access key that may write objects in the bucket, and delete them so the test object of each check is removed again (on Amazon S3, the s3:PutObject and s3:DeleteObject permissions for that bucket). Keep the key for Columna only, so you can remove it any time.
Set it up
- In the app, open Settings and pick Scheduled email exports, then click Add scheduled export (or open an existing one).
- In File, enter a name and choose the template and file format.
- In Delivery, choose Amazon S3 or S3-compatible storage under Deliver to.
- Endpoint: leave it empty for Amazon S3. For another service, enter its HTTPS endpoint host without a path, for example
<account id>.r2.cloudflarestorage.comfor Cloudflare R2 ors3.eu-central-1.wasabisys.comfor Wasabi. - Region: the bucket’s region, such as
eu-central-1. Leave it empty forus-east-1. Cloudflare R2 usesauto. - Enter the Bucket, the Access key ID and the Secret access key.
- Folder (key prefix) is optional, for example
exports/daily. Files go under that prefix. - Tick Use path-style URLs for MinIO and other services that do not accept the bucket name in the host.
- If the bucket policy allows only some addresses, allow the address shown there (“Columna connects from …”).
- Click Test connection to check the settings before saving.
- 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 writes a small test object to the bucket and deletes it again. Connections always use HTTPS with a verified certificate.
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 appears in the bucket within a few minutes.
- The list of scheduled exports shows “S3:” and the bucket for this export.
Files are named after the export and the period, such as exports/daily/daily-orders-2026-10-23.csv, and never repeat, so no upload overwrites an earlier one. When there were no orders, nothing is uploaded.
Change the bucket or key
The secret access key is never shown again after saving. To keep it, leave Secret access key empty. If you change the endpoint or the access key ID, enter the secret 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 service that cannot be reached is tried again a few minutes later.
Troubleshooting
“The service refused the access key.” Check the access key ID and secret, and that the key may write objects in the bucket. A deleted or disabled key gives the same message.
“The bucket is in another region.” Enter the bucket’s region. On Cloudflare R2 use auto.
“The bucket was not found.” Check the bucket name and, for another service than Amazon S3, the endpoint.
“That endpoint is private or reserved.” The app can only reach services on the public internet. Enter the service’s public endpoint.
“The endpoint’s TLS certificate could not be verified.” Check the endpoint. Self-hosted MinIO needs a certificate from a public authority.
“The storage account has no space left for the file.” Free some space or raise the quota, then use Send now.