Export orders and customers to CSV or Excel
Updated November 5, 2026
Export Data in indiVend lets you download orders or customers as a CSV or Excel file. Choose the records, columns and—when exporting orders—the level of detail you need, then reuse your field selection with a saved preset.
Open Manage → Export Data. Use this page for order and customer reports; it is separate from the product Import / Export tool.
On this page
Start with the question you need to answer
Choose Orders when you need transactions, payment information, fulfillment status or items sold. Choose Customers when you need customer details and information about their relationship with your store.
For example, use an order export to review last month's delivery orders. Use a customer export to work with a customer list and its recorded consent fields.
The available filters and columns change with your selection. Invoice transactions are managed separately in Invoices; order exports exclude them.
Filter the records
For Orders, filter by date range, product type, status, channel, payment method and whether the order was refunded.
The default range is Last 30 days. Other choices are Last 7 days, Today, Yesterday, All time and Custom range.
For Customers, filter by date range and source. Customer dates refer to the last purchase, or the date they joined if they have never bought. With Last 30 days selected, older customer records whose last purchase falls outside that range are excluded. Choose All time for the full customer list.
Active filters appear as chips. The date chip appears when you choose a range other than Last 30 days; its × restores Last 30 days. Other chips' × buttons clear their filters.
The matching row count under Export settings updates as you filter. Generate export is disabled when zero rows match.
Choose one row per order or one row per item
Export layout applies to order exports: One row per order or One row per item.
| Layout | What it gives you | When to use it |
|---|---|---|
| One row per order | One line for the order, with its items summarized. | Reviewing transactions, payment methods or order-level totals. |
| One row per item | Separate lines for the items in each order. | Reviewing what sold or preparing item-level reconciliation. |
One row per order
What it gives you
One line for the order, with its items summarized.
When to use it
Reviewing transactions, payment methods or order-level totals.
One row per item
What it gives you
Separate lines for the items in each order.
When to use it
Reviewing what sold or preparing item-level reconciliation.
An order with two different items is one line in the first layout and has item-level lines in the second. “Per item” describes the detail of the export; it is not a promise that every unit of a multi-quantity line becomes a separate row.
Choose the layout before building spreadsheet calculations. In item-level exports, the whole Money and Refund groups repeat on each item row, along with order, date and contact fields. For example, an order with three item rows repeats its order totals three times. Count those totals once per order, using the order number, rather than adding every repeated value.
Select the columns you need
Open Included fields to select groups or individual columns.
Order groups are Order, Dates, Contact, Items — summary or Items — line according to the layout, Money, Refund, Appointment, Group Booking, Rentals and Access, Attribution, Checkout questions and Accountant. Money is selected as a whole group.
Customer groups are Identity, Lifetime, 3Rs, Behavior and Consent. 3Rs covers rewards, referrals and reviews. Customer files finish with a Guest / walk-in summary row, included in the row count.
Order number is always included for orders; Email and Phone stay included for customers.
For repeated work, choose a built-in preset—All fields, Marketing list or Accounting—or select your fields and use Save current fields as preset. Accounting switches the layout to one row per item.
Your saved preset belongs to you for this store and data type. Select it under Column preset, or delete it under Saved presets. Review filters, layout and format each time you export.
Generate and download the file
- 1Confirm whether you are exporting Orders or Customers.
- 2Review the filters and matching row count.
- 3Choose the order layout, if applicable.
- 4Select your columns or a preset.
- 5Choose CSV or Excel. Excel is selected initially.
- 6Select Generate export. The file downloads immediately.
CSV starts with five information lines before the column headers: generation time, report, preset, filters and row count. Remove those five lines before importing into a tool that expects column headers on the first row.
Excel includes the data and three supporting sheets: Column dictionary, Formulas and Export info. Use them to understand the columns, calculations and export settings.
Recent exports records the last five exports made by anyone in the store, including type, format, rows, preset, filters, who generated it and when. To obtain a file again, select the settings you need and generate another export.
If the file does not contain what you expected
Start with the selected data type and date range, then check the active filters. A payment-method or status filter can exclude orders even when the dates are correct.
Next, check Included fields and the column preset. A missing column can result from the saved field selection rather than missing records.
For order details that need investigation, return to Order History. For a particular person's contact information, membership or reward history, open Customers & Members.
Connected features
- Order History: inspect the transactions behind an order export.
- Customers & Members: maintain the records behind a customer export.
- Physical Products: understand the products and options represented in sales.
- Refunds: understand the refund activity you are reviewing.
Was this helpful?