Overview
Most list pages and reports in Commerce include an Export CSV button that downloads the currently filtered dataset as a CSV file. Exports are generated on demand — there is no scheduled export or FTP delivery.
Available Exports
| Export | Triggered From | What It Contains |
|---|---|---|
| Clients | Admin → Clients → Export CSV | All client account records |
| Invoices | Admin → Billing → Invoices → Export CSV or Reports → Invoices | Invoices matching current filter |
| Services | Admin → Services → Export CSV or Reports → Services | Service records matching current filter |
| Domains | Admin → Domains → Export CSV | Domain registration records |
Exports respect whatever filters are currently active on the page. If you have filtered the client list by country, the export contains only clients from that country.
Clients Export Columns
| Column | Notes |
|---|---|
| id | Internal client ID |
| first_name, last_name | |
| Primary email address | |
| company | Company name (if set) |
| country | ISO 3166-1 alpha-2 country code |
| status | Active / Suspended / Cancelled |
| created_at | Account registration date |
Invoices Export Columns
| Column | Notes |
|---|---|
| id | Internal invoice ID |
| invoice_number | Formatted invoice number |
| client_id | Linked client ID |
| client_email | |
| issued_date | Date invoice was generated |
| due_date | Payment due date |
| total | Invoice total |
| status | Paid / Unpaid / Overdue / Cancelled |
| gateway | Payment gateway used |
| paid_at | Date payment was recorded (if paid) |
Services Export Columns
| Column | Notes |
|---|---|
| id | Internal service ID |
| client_id | |
| client_email | |
| product_name | Product the service is based on |
| domain | Primary domain or identifier for the service |
| status | Active / Suspended / Cancelled / Pending |
| billing_cycle | Monthly / Annual / etc. |
| amount | Recurring price |
| next_due_date | Next renewal date |
| created_at | Service provisioning date |
Domains Export Columns
| Column | Notes |
|---|---|
| id | Internal domain ID |
| client_id | |
| domain | Full domain name |
| registrar | Registrar module used |
| status | Active / Expired / Pending Transfer |
| registration_date | |
| expiry_date | |
| auto_renew | true / false |
Character Encoding
All CSV exports are encoded as UTF-8 with BOM (byte order mark). The BOM causes Excel on Windows to correctly detect the UTF-8 encoding and render special characters (accented names, non-Latin company names) properly.
[!TIP] When opening a CSV in Excel on Windows, double-clicking the file should render it correctly thanks to the BOM. If characters still appear garbled, use Data → From Text/CSV in Excel and explicitly select UTF-8 encoding during the import wizard.
Opening in Excel Without Encoding Issues
- Open Excel.
- Go to Data → Get Data → From File → From Text/CSV.
- Select the downloaded CSV file.
- In the import wizard, confirm File Origin is set to
65001: Unicode (UTF-8). - Click Load.
This method is more reliable than double-clicking, especially for files with non-ASCII content.
Large Exports
Exports are generated synchronously — the browser waits while the server queries and streams the file. Very large exports (tens of thousands of records) may take several seconds. Do not close the browser tab while the download is in progress.
[!WARNING] There is no row limit on exports, but exporting more than ~50,000 rows at once may cause a request timeout on servers with a short PHP or web server timeout. If you need to export very large datasets, apply filters to split the export into smaller batches.