Export orders CSV — download your store orders as a spreadsheet

In short. Go to Store Management → Orders → All Orders, click Export Orders in the top-right, pick a date range (up to 100 days), optionally filter by customer, and click Export Orders again. Your browser downloads order_export__to_.csv — ten columns, one row per order, oldest first. Open it in Excel, Google Sheets, or any spreadsheet tool. That is the whole operation.

On this page: What the export contains · Good use cases · Limits and what not to use it for · Step-by-step · Troubleshooting · Tips

How to export orders CSV

The Export Orders page lets you export orders CSV files directly from your SGEN store. Pick a date range, optionally filter by one or more customers, click Export Orders, and your browser downloads a .csv file. Open it in Excel, Google Sheets, Numbers, or any spreadsheet tool. 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 store 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, and whenever you need to bulk-process orders outside SGEN — feeding a shipping tool, reconciling against a bank statement, or 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__to_.csv — so order_export_2026-04-01_to_2026-04-30.csv for an April export.

Before you export, glance at the order-status breakdown on the Orders list. The counts tell you what is in scope for your chosen date window — you can then decide whether to export all statuses or plan to filter the Status column after download:

The export form itself is straightforward — a date-range field, an optional customer picker, and one button:

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.

Opened in a spreadsheet, the April export for your business looks like this — one row per order, oldest first:

The raw file — exactly as SGEN writes it, before you open it in a spreadsheet — looks like this:

``csv "Order ID",Name,Phone,Email,Address,Items,"Payment Method",Status,Total,"Order Date" 1008,"an analyst","+1 757 555 0188",analyst@yourdomain.com,"4200 Langley Blvd Hampton, VA, US 23681","Barista T-Shirt","Credit Card",completed,24.99,"2026-04-02 09:03:12" 1009,"an admin","+1 617 555 0144",admin@yourdomain.com,"77 Massachusetts Ave Cambridge, MA, US 02139","Canvas Tote Bag",Stripe,refunded,30.00,"2026-04-05 14:22:48" 1011,"a teammate","+1 202 555 0133",teammate@yourdomain.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,"an editor","+44 20 7946 0000",editor@yourdomain.com,"10 Analytical Ave Apt 2 London, LN, GB SW1A 1AA","Canvas Tote Bag",Stripe,completed,25.00,"2026-04-12 16:47:33" 1015,"a developer","+1 408 555 0177",developer@yourdomain.com,"42 Computation Lane San Jose, CA, US 95101","your detailed content piece",Stripe,completed,9.00,"2026-04-18 10:22:05" ``

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

Example 2: Customer history for a support ticket. A customer emails asking for a complete 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-30), 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.

The customer-filtered order history for a teammate's lifetime account at your business:

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. The Address and Items columns have everything a label generator needs.

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

Example 5: Empty-export as a column template. If you export with no matching orders in the selected window, you get a valid CSV with the header row and zero data rows. That header-only file is a clean template you can use to understand the exact column structure before building an import mapping for a third-party tool.

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, and 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. See View and manage your orders for the list page.

• 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.

• Ecommerce → Order detail — to review a single order before exporting, see View an individual order's details.

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 is 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 navigate 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 — four orders from your business during the first two weeks after the Spring sale:

To see the full ten-column layout as SGEN outputs it — including Phone and the full concatenated Address — here is one row expanded for readability:

What success looks like

• Clicking Export Orders triggers a browser download within a second or two.
• The downloaded file is named order_export__to_.csv with your chosen dates — 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 orders are not all there.

Check that your date range covers the full month. If your store is on a time zone where orders placed at midnight fall into the next day, 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 have user accounts — guest checkouts have no user account, so they appear in exports with the Customer picker 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). Empty fields produce double spaces. Clean up in your spreadsheet tool with 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. On a narrow screen the button may be hidden — scroll up to the very top of the list.

Tips for keeping exports useful

A few habits make your order history exports easier to reuse over time.

Name your downloads on save. The filename SGEN sends — order_export_2026-04-01_to_2026-04-30.csv — is already descriptive, but adding the purpose on save (yourstore-april-bookkeeping.csv) makes the file meaningful three months from now when you find it on your shared drive.

Run four quarterly exports for a full year. The 100-day cap means you need four passes to cover a calendar year: Jan–Mar, Apr–Jun, Jul–Sep, Oct–Dec. Open each in your spreadsheet, paste the data rows (not the header) from passes 2–4 below pass 1, and you have a twelve-month master file.

Filter on Status after export, not before. The export form does not filter by status — it always includes all statuses in your chosen window. Add a Status column filter in your spreadsheet after download: filter to completed for fulfilled orders, refunded for reconciliation, pending for follow-up.

Export before you bulk-edit. If you are about to update a batch of orders in the admin (status changes, refunds), export the current CSV first. An exported CSV is your insurance if an admin action goes wrong — changes to orders do not reverse automatically.

Use Entry ID as your join key when loading into another tool. Order ID is stable across exports. Email is not unique — a customer can place multiple orders. When you load an orders CSV into a CRM or accounting tool, map Order ID as the external identifier so re-importing the same export later does not create duplicates.

Scope

The Export Orders tool covers orders placed within a selected date range — it exports one row per order, not one row per line item. Filters by customer name or email narrow the exported set. The export always reflects the current order status at the time of download; historical status snapshots are not available.

The CSV does not include payment gateway tokens, card numbers, or raw authentication data — only the ten order and customer fields described above (Order ID, Name, Phone, Email, Address, Items, Payment Method, Status, Total, Order Date).

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.