Orders CSV List Exporter

Orders CSV List Exporter — Documentation

Exports a clean, filtered spreadsheet of your orders in seconds — filterable by date range, order status, and payment method, with full control over which columns appear in the output. Choosing the CSV separator (comma, semicolon, or tab) and character encoding (UTF-8 or Windows-1252) means the file opens correctly in Excel, Google Sheets, or any accounting package without format issues. Handles large order volumes without timeouts, making it equally useful for a quick weekly report or a full annual sales data pull.

Orders CSV List Exporter

Stop copying order data by hand. Orders CSV List Exporter lets you pull a clean spreadsheet of your orders in seconds, filtered exactly the way you need — by date, status, or payment method. Whether you are preparing a weekly sales report, reconciling payments with your accountant, or handing data off to a logistics partner, this module gives you a reliable export with exactly the columns you want.

How It Works

You open the export tool from your Back Office, choose a date range and any filters you need, then select which columns to include in the file. The module queries your order database and streams a properly formatted CSV that opens directly in Excel, Google Sheets, or any accounting software. The file is ready in moments even for stores with thousands of orders.

Installation

  1. In your Back Office, go to Modules → Module Manager
  2. Click Upload a module and select the ZIP file
  3. Once installed, click Configure

Configuration

Date Range — Set a start and end date to limit which orders appear in the export. Leave both blank to export all orders.

Order Status Filter — Choose one or more order statuses (e.g. Delivered, Payment Accepted) to export only orders in those states.

Payment Method Filter — Restrict the export to orders paid through a specific payment provider, useful when reconciling a single payment gateway.

Column Selection — Tick the columns you want in the output: order reference, date, customer name, email, total, tax amount, shipping cost, payment method, status, and more. Unticked columns are omitted from the file.

CSV Separator — Choose between comma, semicolon, or tab to match the format expected by your spreadsheet or accounting tool.

Character Encoding — Select UTF-8 or Windows-1252 (ANSI) depending on what your software requires. Use Windows-1252 if Excel on Windows shows garbled characters.

Tips

  • Export by payment method before your monthly bank reconciliation to match gateway statements row by row.
  • If your accountant uses a specific column order, save your column selection as the default so every export is consistent.
  • Use the date range filter to create quarterly reports — export once per quarter and drop the file straight into your spreadsheet template.
  • For large stores, filter by a single order status at a time rather than exporting everything at once; smaller files open faster and are easier to audit.
  • Always select the order reference column — it is the key that links back to the original order in your Back Office if a discrepancy needs investigating.

Frequently Asked Questions

Can I export orders from a specific date range only? Yes. The date range fields let you set any start and end date. Only orders placed within that window will appear in the export.

Will the export include all order statuses by default? Yes, if you leave the status filter empty the module exports orders in every status. Apply the filter when you only need a subset such as paid or shipped orders.

My file shows strange characters when I open it in Excel. What should I do? Switch the character encoding setting to Windows-1252 and re-export. Alternatively, import the UTF-8 file into Excel using the Data → From Text/CSV wizard and select UTF-8 encoding there.

How many orders can I export at once? The module can handle large order volumes. For very high-traffic stores with tens of thousands of orders, filtering by date range or status keeps the file manageable and the export fast.

Can I choose which columns appear in the CSV? Yes. The column selection setting lets you include or exclude any available field so the output matches exactly what you or your partners need.

Back to top