Download a CSV of your orders

How to export orders by date range and customer as a CSV spreadsheet

The Export Orders page takes the orders on your store and hands you back a .csv file — a spreadsheet you can open in Excel, Google Sheets, Numbers, or any spreadsheet tool. You pick the date range and optionally one or more specific customers, click Export Orders, and your browser downloads the file. A monthly bookkeeping dump, a customer-history attachment for a support ticket, or a shipping-tool import all come from this one page.

What is this for?

The Export Orders page is your spreadsheet lifeline for orders. Its job is to hand you a .csv file with one row per matching order so you can hand it off to an accountant, import it into a third-party tool, or analyze it in a spreadsheet. You reach for it at month-end for bookkeeping, whenever a customer asks for a history of their orders to attach to an email, and whenever you need to bulk-process orders outside SGEN (feeding a shipping tool, reconciling against a bank statement, importing into a CRM).

The file you get contains ten columns: Order ID, Name, Phone, Email, Address, Items, Payment Method, Status, Total, and Order Date. One row per order, oldest first. The filename is order_export_<from>_to_<to>.csv — so order_export_2026-04-01_to_2026-04-30.csv for an April export.

Good use cases

Example 1: Month-end bookkeeping dump. It is the first of the month and your accountant needs every order from the previous month. Open Export Orders, click the date-range field, pick 2026-04-01 - 2026-04-30, leave the customer picker empty (to include every customer), click Export Orders. Your browser downloads order_export_2026-04-01_to_2026-04-30.csv. Email it to your accountant or drop it into your bookkeeping folder.

Example 2: Customer history for a support ticket. A customer emails asking for a history of every order they have placed. Open Export Orders, widen the date range to cover their entire time as a customer (for example 2024-01-01 - 2026-04-24), open the customer picker, find their record, pick only them, click Export Orders. You get a CSV with just their orders. Attach it to your reply.

Example 3: Shipping tool import. Every Friday you feed the last week's Completed orders into your 3PL shipping tool. Set the date range to the last seven days, leave the customer picker empty, click Export Orders. Open the CSV, filter on the Status column to just Completed, paste those rows into your shipping tool's import template.

Example 4: Top-customer list. You want to identify which customers bought most often this quarter. Set the date range to cover the quarter, leave the customer picker empty, export the CSV, then pivot on the Name column in your spreadsheet tool to get a count and total per customer.

What NOT to use this for

• Do not use the export for real-time syncing. This is a one-shot download — it does not update automatically, it does not push to an external system on every new order. If you need a continuously-updating feed, that is a separate integration.
• Do not use the export to make changes. The CSV is read-only — editing it does not change anything on your store. Changes to orders happen in the admin on the order detail page (or in bulk from the Orders list). Spreadsheet edits stay in the spreadsheet.
• Do not export more than 100 days at a time. The date window is capped at 100 days — if you pick a range wider than that, the end date is silently shortened so the export stays fast. For a full year, run four exports (Jan-Mar, Apr-Jun, Jul-Sep, Oct-Dec) and concatenate them in your spreadsheet tool.
• Do not use the export for customer-facing communications. The Email, Phone, and Address columns are for your own records and tooling. Sending that CSV to a non-secure recipient exposes customer contact details — treat it like any other personal-data export.
• Do not rely on the export to include future orders. Only orders whose Order Date falls inside the selected date range are included. A wider window, not this page, is the answer if you are missing recent orders.

How this connects to other features

• Ecommerce → Orders list — the Export Orders button at the top right of the Orders list is the primary entry point to this page. If you filtered the list by date before clicking, those filters are a reminder of what to set on the export form but are not carried over — you still pick the range on the export page itself.
• Users — the customer picker on this form is populated from your full Users list. Every user account (Administrator, Site Owner, Customer, Editor) shows up as an option, but in practice you pick from customer accounts.
• Ecommerce → Configuration → Currency — the Total column in the exported CSV uses your store's configured currency. Switching currency afterward does not rewrite past exports.
• Ecommerce → Coupons — if you want a spreadsheet of coupon redemptions, the order CSV is not where you go — the Coupons list's Total Amount column aggregates that per-coupon. Use this export for order-level data; use the Coupons list for coupon-level data.

Before you start

• You are signed in to SGEN as an Administrator or Site Owner.
• At least one order exists inside the date window you plan to pick. If you export with no matching orders, you get a valid CSV with just the column header and no data rows — which might be useful as an empty template, but probably not what you wanted.
• Your browser is set up to allow file downloads from your SGEN admin domain. Most browsers allow downloads by default.

Where to go

1. Open Store Management → Orders → All Orders.
2. Click the Export Orders button in the top-right of the list. The Export Orders form opens.

You can also jump direct to /sg-admin/ecommerce/orders/export.

Steps

1. Pick the date range

Click the Select a Dates field. A calendar appears. Pick a start date and end date; click Apply (or the equivalent in the picker). The field shows the chosen range like 2026-04-01 - 2026-04-30.

The default range is the last 2 weeks plus 2 days ahead (so same-day orders are included without the current day being a boundary). The maximum range is 100 days; picking a wider window quietly shortens it so the export stays fast.

2. Optionally, pick specific customers

Click the Select Customer/s picker. A multi-select of every user account appears. Each option shows the user's name and email. Hold Ctrl (or Cmd on Mac) and click to pick more than one.

To export every customer's orders, leave the picker empty. Picking zero customers is the same as "include all customers".

3. Click Export Orders

Click the red Export Orders button in the bottom right of the card. The page does not visibly refresh — instead, your browser triggers a file download. The file lands in your browser's default downloads folder.

4. Open the CSV

Double-click the downloaded file to open it in your default spreadsheet tool. You should see a header row of ten columns and one data row per matching order, oldest first.

Here is what a typical April-2026 export looks like opened in a spreadsheet tool — 4 orders from Acme Coffee Roasters' first week after the Spring sale:

If you prefer to see the raw file as your text editor displays it (before you open it in a spreadsheet), it looks like this:

"Order ID",Name,Phone,Email,Address,Items,"Payment Method",Status,Total,"Order Date"
1008,"Katherine Johnson","+1 757 555 0188",katherine@example.com,"4200 Langley Blvd Hampton, VA, US 23681","Barista T-Shirt","Credit Card",completed,24.99,"2026-04-02 09:03:12"
1009,"Margaret Hamilton","+1 617 555 0144",margaret@example.com,"77 Massachusetts Ave Cambridge, MA, US 02139","Canvas Tote Bag",Stripe,refunded,30.00,"2026-04-05 14:22:48"
1011,"Grace Hopper","+1 202 555 0133",grace@example.com,"1 Navy Yard Rd Washington, DC, US 20374","Barista T-Shirt, Coffee Sticker Pack",Stripe,shipped,29.00,"2026-04-08 11:18:06"
1012,"Ada Lovelace","+44 20 7946 0000",ada@example.com,"10 Analytical Ave Apt 2 London, LN, GB SW1A 1AA","Canvas Tote Bag",Stripe,completed,25.00,"2026-04-12 16:47:33"

Notice the Status column is lowercase (completed / shipped / refunded) rather than the Title Case that appears in the admin. That is the raw status key — your spreadsheet tool's Filter / Pivot on this column works as long as you're consistent.

What success looks like

• Clicking Export Orders triggers a browser download within a second or two.
• The downloaded file is named order_export_<from>_to_<to>.csv with your chosen dates — so order_export_2026-04-01_to_2026-04-30.csv for an April export.
• Opening the file shows ten columns: Order ID, Name, Phone, Email, Address, Items, Payment Method, Status, Total, Order Date.
• The number of data rows matches the number of orders in your selected window and customer filter.
• Orders are sorted oldest first so the earliest order is on row 2 of the spreadsheet.

What to do if it does not work

• The download did not start. Your browser might have blocked it. Check the address bar or notification tray for a "Download blocked" prompt and click to allow. Chrome, Firefox, Safari, and Edge all allow explicit allow-listing of downloads per site.
• The file downloaded but it only has a header row and no data rows. No orders fell inside your chosen date range and customer filter. Widen the date range or clear the customer picker and try again.
• The file downloaded but my month's worth of orders is not all there. Check that your date range covers the full month. If you picked 2026-04-01 - 2026-04-30 but your store is on a time zone where orders placed at midnight fall into the next day, you may have missed the last day's orders — widen the end date by a day.
• I only see a few customers in the Customer picker. The picker shows every user account on your site. If you expected more, check that those customers actually have accounts (as opposed to being guest checkouts). Guest orders have no user account, so they appear in exports where the Customer picker is empty, but not when you filter to specific customers.
• The Address column looks ragged with extra spaces. The address is concatenated from several fields (line 1, line 2, city, state, country, postal code). If your billing form has empty fields, the output has double spaces. Clean up in your spreadsheet tool with a find-and-replace.
• I asked for a 6-month range and only got 100 days. The date window is capped at 100 days. Run the export in multiple chunks and concatenate them in your spreadsheet.
• I cannot find the Export Orders button on the Orders list. It sits in the top-right corner of the Orders list, next to the page heading. If you are on a narrow screen the button may be hidden behind a menu — scroll up to the very top of the list.

Next step

• View and manage your orders — the list you came from.
• View an individual order's details — open a single order from the list to see its full details.
• Configure store general settings — set your store currency before exporting; the Total column follows your configured currency.