How do I email a weekly orders CSV from Shopify automatically?
Updated 2026-10-21. Checked against Shopify's own documentation; links are under Sources.
Shopify's order export is a manual step: its help page describes no way to schedule it. You can export orders by date whenever you like, and Shopify emails you the file. To get a file every week with no clicks, you need either a Shopify Flow workflow, which can email order details in the body of the message but can't attach a file, or an app that sends the file for you.
The manual way: export last week's orders
- In your Shopify admin, go to Orders.
- Click Export.
- Choose Orders by date and set the start and end dates (for example, last Monday to Sunday).
- Choose Export orders (all order data) rather than Export transaction histories, then pick the CSV format.
- Click Export orders.
From Shopify's help: "If you select to export more than 51 orders or to export orders by date, then the CSV file is emailed to you." The file goes to your own account email, not your accountant or warehouse. You still forward it yourself each week.
Shopify's help page doesn't mention a way to schedule this export, so it's a weekly reminder in your calendar, every week.
The Shopify Flow way: order details in an email body
Shopify Flow is free and has the three building blocks you need:
- Scheduled time trigger: "starts a workflow at a time and date that you specify," repeating every so many days, weeks or months.
- Get order data action: fetches orders that match a query. "You can return up to 100 at a time."
- Send internal email action: an email address, a subject and a message, "best used to send emails to staff."
- Open the Shopify Flow app and create a workflow.
- Choose the Scheduled time trigger, set it to repeat every week, and pick a day and time.
- Add Get order data with a query for orders created in the last 7 days.
- Add Send internal email. In the message, use a Liquid loop over the returned orders to write one line per order, with commas between fields so it pastes into a spreadsheet. There's a sketch of the loop here.
- Turn the workflow on, then run it once and check the email.
Limits of the Flow approach
- No attachment. The send email action has only an address, a subject and a message. The orders arrive as text, and someone has to copy them into a spreadsheet.
- Up to 100 orders per Get order data. A busy week can go over that.
- Fixed recipient. "You can't use variables to customize the email address," and the action is meant for staff, not outside recipients.
- Getting the fields right. You choose each field in Liquid, and amounts, dates and commas inside product names need care.
For a small store that just wants a weekly list in the inbox, this is often enough. If your bookkeeper or warehouse needs an actual CSV or Excel file, you need a different tool.
Tips whichever way you choose
- Agree what "a week" means. Pick Monday to Sunday or Sunday to Saturday, and use your store's time zone, so totals match your reports.
- Use the same columns every time. Whoever receives the file usually has a spreadsheet or import that expects them.
- Keep customer details out unless you need them. Order files with names and addresses are personal data. Send them only to people who need them.
- Check it against Shopify. For the first few weeks, compare the order count and total in the file with Orders filtered to the same dates.