Help CenterContact support
All Columna: Order Export & Sheets articles

How do I get an order export by email every day, week or month?

Updated

On this page
  1. Before you start
  2. Steps
  3. Verify it worked
  4. Which orders are in the file
  5. Change, pause or delete a scheduled export
  6. If an export keeps failing
  7. Troubleshooting

A scheduled export emails a file from a saved template every few hours, every day, week or month, or for every new order, for example to you, your warehouse or your accountant. Nobody has to export by hand. This is part of the Pro plan.

Before you start

  • You need the Pro plan. On Free, the group shows “Get your orders by email on a schedule” with a button to start Pro (see “What does the Pro plan add?”).
  • Pick or build the template first. The template decides the columns of the file (see “How do I create, edit, duplicate or delete export templates?”).

Steps

  1. In the app, open Settings and pick Scheduled email exports.
  2. Click Add scheduled export.
  3. In File, enter a Name, such as “Weekly orders for accounting”. Choose the Template and the File format: CSV, Excel (XLSX), TSV (tab-separated), Pipe-separated (|), JSON or XML. Quoting and the .txt extension come from Settings › File format (see “How do I change the CSV delimiter and date format of my exports?”).
  4. In Delivery, keep Email under Deliver to. In Send to, type an address and click Add. Repeat for up to 3 addresses.
  5. In Schedule, choose Send: Every hour(s), Every day, Every week, Every month or Every new order. For Every hour(s), choose in Every how many hours: 1, 2, 3, 6 or 12. For a weekly email, choose the Day. For a monthly email, choose the Day of the month: a day from 1 to 28, or Last day of the month. For a daily, weekly or monthly email, choose the hour in Send at. Times are in your shop’s time zone, shown under the fields.
  6. Keep Send this export on schedule ticked. Untick it to pause the email without losing your settings.
  7. In Orders to include, optionally narrow the orders by Payment status, Fulfillment status, Fraud risk, Tagged with, Not tagged with, Payment method, Discount code, POS location, Shipping country, Shipping method and Product type. Tick several statuses or add several values to include orders with any of them. Only orders that match these filters are in the file.
  8. Click Save in the bar at the top of the page.

To upload the file instead of emailing it, choose another destination in step 4: SFTP server (see “How do I upload scheduled exports to an SFTP server?”), FTP or FTPS server (see “How do I upload scheduled exports to an FTP or FTPS server?”), Amazon S3 or S3-compatible storage (see “How do I upload scheduled exports to Amazon S3 or S3-compatible storage?”), Google Drive (see “How do I save scheduled exports to Google Drive?”) or Dropbox (see “How do I save scheduled exports to Dropbox?”). To post it to your own system, choose Webhook (HTTPS POST) (see “How do I send scheduled exports to a webhook?”). To send single orders from a Shopify Flow workflow through the export, see “How do I export an order from a Shopify Flow workflow?”.

Verify it worked

  • After saving you see “Settings saved”. The Status section shows “No email sent yet” and “Next email:” with the date and time. For Every new order it shows “New orders go out a few minutes after they are placed.” instead.
  • Click Send now in Status to get the email right away. You see “Email requested”, and “An email is on its way. It arrives in a few minutes.”
  • After an email goes out, Status shows “Sent” with the number of orders and the period, or “No orders” when nothing matched.
  • Click All scheduled exports to go back. Under Your scheduled exports, the row shows the schedule and the number of recipients, such as “Every 3 hours”, “Every day at” the hour you chose, “Every month on day” with the day and hour, “Last day of every month at” the hour, or “Every new order”, followed by “· 2 recipients”.

Which orders are in the file

  • Every hour(s): the orders placed since the previous email. Emails go out at whole hours counted from midnight, so every 6 hours means at midnight, 6:00, 12:00 and 18:00. When no orders were placed, no email is sent. On the night the clocks go back, one email covers one hour more.
  • Every day: the orders placed the day before.
  • Every week: the orders placed in the seven days before.
  • Every month: the orders placed in the previous calendar month.
  • Every new order: the orders placed since the previous email, a few minutes after they are placed. Orders placed close together arrive in one email, and an export sends at most one email every 15 minutes; your shop can send up to 500 app emails a day in total. When no new order matches, no email is sent. Send now sends the new orders that were not sent yet.

With Every new order, each order is sent once, as it was when it was placed. An order that matches your filters only later, for example one that is paid later while the export includes only paid orders, is not sent. To include such orders, use Every hour(s) instead.

The email subject is the export name, the period and your shop name; for Every hour(s) and Every new order the period includes the hours, such as “October 23, 2026, 13:00–14:00”. The file is attached; a file too large to attach is sent as a download link. When no orders match, the email says so and has no file.

The file contains the columns of your template, which can include customer details. Send it only to people who may see them. Each email ends with an Unsubscribe link for its recipient. To change the sender name or the reply-to address, see “How do I change the sender name and reply-to of the app’s emails?”.

Change, pause or delete a scheduled export

  • Click the export’s name in Your scheduled exports, change it and click Save.
  • To pause it, untick Send this export on schedule and save.
  • To delete it, open it, click Delete and confirm “Delete this scheduled export?”. Your saved template stays.

A shop can keep up to 10 scheduled exports.

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. These emails never go to the export’s recipients.

Troubleshooting

You see “Email is not available yet”. Scheduled email exports are not available yet. Try again later.

You see “Enter at least one email address.” Add an address in Send to.

You see “You have reached the limit of 10 scheduled exports.” Delete a scheduled export you no longer need to add another one.

You see “Save your changes before sending.” Save first. Send now uses your saved settings.

You see “You requested an email a moment ago. Wait a minute and try again.” Wait a minute, then click Send now again.

The row shows “Paused, needs Pro”. The shop is no longer on Pro. The export is kept and starts again when you subscribe again from Plans.

Status shows “Failed” with “It will be tried again in a few minutes”. The email is retried on its own; nothing to do.

Status shows “Failed” with “The email could not be sent. Check the recipient addresses, then use Send now.” Fix the addresses in Send to, save, and click Send now.

Status shows “Failed” with “Every recipient unsubscribed from this export”. Everyone in Send to used the Unsubscribe link. Add an address that should receive the export and save.

Status shows “Failed” with “The export file is larger than …”. Narrow the filters in Orders to include, or choose a template with fewer columns.

The email did not arrive. Check the spam folder, and add the sender address to your contacts.

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