Help CenterContact support
All Columna: Order Export & Sheets articles

Upload scheduled exports to Amazon S3 or S3-compatible storage

Updated

On this page
  1. Before you start
  2. Set it up
  3. Verify it worked
  4. Change the bucket or key
  5. If an export keeps failing
  6. Troubleshooting

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

  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 Amazon S3 or S3-compatible storage under Deliver to.
  4. Endpoint: leave it empty for Amazon S3. For another service, enter its HTTPS endpoint host without a path, for example <account id>.r2.cloudflarestorage.com for Cloudflare R2 or s3.eu-central-1.wasabisys.com for Wasabi.
  5. Region: the bucket’s region, such as eu-central-1. Leave it empty for us-east-1. Cloudflare R2 uses auto.
  6. Enter the Bucket, the Access key ID and the Secret access key.
  7. Folder (key prefix) is optional, for example exports/daily. Files go under that prefix.
  8. Tick Use path-style URLs for MinIO and other services that do not accept the bucket name in the host.
  9. If the bucket policy allows only some addresses, allow the address shown there (“Columna connects from …”).
  10. Click Test connection to check the settings before saving.
  11. 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.

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