---
title: Exporting orders
id: orders.import-export
description: "Download quotes, sales orders or purchase orders, or their lines, as a CSV file."
lastUpdated: 2026-10-24
order: 16
---

Who can do this: team leaders, administrators and owners.

## What it does

Use Export to save the orders you choose as a CSV file for a spreadsheet. It is in the Actions menu beside the create button on each orders list.

| File | One row per | Lists |
| --- | --- | --- |
| Orders | Order | Every orders list |
| Order Lines | Line | Every orders list |
| Payments | Payment, refund or chargeback | Sales Orders and Purchase Orders |
| Fulfilments | Line of each fulfilment, or of each receipt on a purchase order | Sales Orders and Purchase Orders |
| Notes | Note on the orders you chose, oldest first within each order | Every orders list |

Lucrii prepares the file in the background. When the file is ready, a message appears. You also get an email with a link to the export in Bulk Activity, where you download it. The email gives the name of the file you chose, such as Payments.

An Orders file's name starts with the list, as in sales_orders. Every other file adds its own name, as in sales_order_order_lines and sales_order_payments.

Selected and Everything export in the list's sort. All Matching exports in the list's default order.

The Orders file's columns include the number, status, customer or vendor and their email, team, assignee, watchers, totals and dates. The tables on this page give each column's label. [Importing and exporting contacts](/docs/contacts/import-export.md) explains the headings in the file.

| Column | What it shows |
| --- | --- |
| Assignee, Assignee Email | The person on the order and their email |
| Watcher Emails | The emails of the people watching the order |
| Exchange Rate | The rate to your organisation's currency, 1 for an order with no rate of its own |
| Discount %, Total Discount | The order's discount |
| Base Total | The total in your organisation's currency at the Exchange Rate |
| Net Paid, Amount Owed, Credit Owed | The order's balance, as its page shows it, on sales and purchase orders |
| Fulfilment Status, Received Status | How much of a sales order has shipped, or of a purchase order has arrived |
| Fulfilment Location, Receiving Location | Where a sales order ships from, or a purchase order is received into |
| Payment Terms, Cancel Reason | The stored value, such as due_within_30_days |
| Shipping columns | The shipping address, on quotes and sales orders |
| Linked Orders | The numbers of the orders linked to this one |
| Created At, Created By | When the order was made, and by whom |
| Updated At, Updated By | When it last changed, and by whom |

The Orders file also has Due Date, Expected Date, Terms and Conditions and Tags. A quote has Decided At, and a sales order has Cancelled At. Watcher Emails, Linked Orders and Tags separate their entries with `|`.

The Order Lines file has one row per line. Its columns include the order's number, ID, customer or vendor, created date and status. In the export window, a quote's number and ID columns are named Quote and Quote ID. Other columns hold the item and its SKU, the quantity, the unit price, the tax and its rate, and the line total. On sales and purchase orders, they also hold how much of the line is fulfilled or received, refunded and returned. Amounts Include Tax says whether that line total is before or after tax.

Lucrii writes amounts in each order's own currency, with a Currency column beside them. Each line total is in whole cents, or the smallest unit of the order's currency. Totals and tax are in the same units, as the order shows them. [Line items](/docs/orders/line-items.md) explains how the line totals add up. A unit price keeps every decimal place you entered. So 2.345 stays 2.345.

Every amount, exchange rate and tax rate in a file uses the decimal mark of your organisation's currency. One file has one decimal mark, whatever currency each order is in.

In a Payments file, refunds and chargebacks are negative, and an order's rows add up to its Net Paid. A Fulfilments file has no row for a reversed fulfilment.

A Payments file opens on Payment ID, then the order's number, ID and contact. These follow.

| Column | What it shows |
| --- | --- |
| Type | payment, refund or chargeback |
| Date | When the money moved |
| Amount, Currency | The amount, negative for money that went back |
| Base Amount | The amount in your organisation's currency |
| Source | How the money moved, as the payment form names it |
| Reason, Refund Reason, Discrepancy Reason | The reasons recorded with it, as stored, such as damaged |
| Recorded At | When it was recorded in Lucrii |

A Fulfilments file opens on the fulfilment's ID, then the same order columns. These follow.

| Column | What it shows |
| --- | --- |
| Date | When the goods shipped or arrived |
| Location | Where they shipped from or arrived at |
| Line | The line's number, as the Order Lines file numbers it |
| Item, SKU, Variant, Description | What shipped or arrived |
| Quantity | How many on that line |
| Created By | Who recorded it |

A Notes file has these columns.

| Column | What it shows |
| --- | --- |
| Order ID, Order | The order the note is on, by its ID and its number. In the export window, a quote's columns are named Quote ID and Quote |
| Note ID | The note's own ID |
| Type | default for a note someone wrote, system for one Lucrii added |
| Public | Yes for a public note, No for a private one |
| Author | The member, contact or Hermes who wrote the note |
| Text | The note as plain text, with a mention as @Name |
| Emailed At | When Lucrii emailed the note, blank if it never went |
| Created At, Created By | When the note was written, and by whom |
| Updated At, Updated By | When it was last edited, and by whom |

In the export window, a Notes file from another list names its record with that list's word. Contacts give Contact ID and Contact, and items give Item ID and Item. Locations and tasks follow the same pattern. A Notes file's default columns are the record's ID and name, Author, Text and Created At.

## Before you start

- Exporting is for a team leader or above.
- You can't import orders, order lines, payments, fulfilments or notes from a file.
- You can have three jobs in progress at once, counting bulk actions and exports together. [Quotes, sales orders and purchase orders](/docs/orders/overview.md) says how the limit works.

## How to use it

1. Open Orders and choose Quotes, Sales Orders or Purchase Orders.
2. To export some of the orders, tick them first or narrow the list with filters.
3. Select Actions, then Export.
4. Under Records, choose Selected, All Matching or Everything. Selected takes the orders you ticked. All Matching takes every order your search and filters match. Everything takes every order in the list.
5. Under Shape, choose Orders for one row per order or Order Lines for one row per line. On sales and purchase orders, choose Payments for one row per payment, refund or chargeback, or Fulfilments for one row per fulfilment or receipt line. Choose Notes for one row per note.
6. Under Columns, choose Columns in This View, All Columns, or Choose Columns to pick your own.
7. Select Export, and download the file from the message or Bulk Activity when it is ready.

For Orders, Columns in This View writes the columns the list shows. The number column brings Status with it. The Assignee column brings Team and Assignee. On purchase orders, the list's Received Status column writes the file's Received Status. Total and Net Paid bring Currency. For Order Lines, Payments, Fulfilments and Notes, Columns in This View writes their default columns.

## Troubleshooting

Bulk Activity lists an order as skipped. The order has nothing for the file you chose.

- Payments: "No payments or refunds to export."
- Fulfilments: "Nothing fulfilled or received to export."
- Notes: "No notes to export."

No email came when an export was ready in a demo organisation. Lucrii doesn't send the email when an export is ready in a demo organisation. The file is in Bulk Activity.

## Related

- [Quotes, sales orders and purchase orders](/docs/orders/overview.md): Find your quotes, sales orders and purchase orders, filter each list by status and read its figures.
- [Bulk actions on orders](/docs/orders/bulk-actions.md): Send, fulfil, receive or tag many quotes, sales orders or purchase orders at once.
- [Bulk Activity](/docs/settings/bulk-activity.md): Follow the imports, exports and bulk changes your organisation runs, and see what happened to each record.

## Changes

- [Assignee and an All view on order and task lists](/changelog/2026-10-16#2026-10-16-assignee-and-an-all-view) - 2026-10-16
- [Bulk actions with Hermes](/changelog/2026-10-16#2026-10-16-bulk-actions-with-hermes) - 2026-10-16
- [Export file names and sort order](/changelog/2026-10-16#2026-10-16-export-file-names-and-sort-order) - 2026-10-16
- [Exporting orders](/changelog/2026-10-16#2026-10-16-exporting-orders) - 2026-10-16
- [Exports that import back](/changelog/2026-10-16#2026-10-16-exports-that-import-back) - 2026-10-16
- [Line totals in whole cents](/changelog/2026-10-16#2026-10-16-line-totals-in-whole-cents) - 2026-10-16
- [Notes, payments and fulfilments in exports](/changelog/2026-10-16#2026-10-16-notes-payments-and-fulfilments-in-exports) - 2026-10-16