Customers > Exporting Customers
Exporting Customers
To access the Customers section, select Customers from the side menu.
To export customers, follow these steps:
-
On the Customers page, select the customers you want to export by selecting them individually. To export all customers, select Export without selecting any individual records.
-
After selecting the customers to export, select Export. The customers are exported in CSV format, which you can open with Excel, Google Sheets, or other spreadsheet software.
-
In the confirmation dialog, select Export Customers.
-
The export file begins processing. When complete, it downloads automatically. Select the green tick icon to download the file manually.
-
Select Done to close the window.
The CSV export file contains the following columns:
| Header | Description |
|---|---|
| The email address of the customer | |
| name | Full name of the customer |
| accepts_marketing | Whether the customer has consented to receive marketing emails |
| verified_email | Whether the customer's email address has been confirmed |
| is_disposable_email | Whether the customer's email address appears suspicious |
| tax_exempt | Whether the customer is marked as tax-exempt |
| group | Name of the customer group the customer belongs to |
| s_name | The recipient name (shipping address) |
| s_address1 | Street address (shipping address) |
| s_address2 | Additional address line (shipping address) |
| s_city | City (shipping address) |
| s_company | Company name (shipping address) |
| s_phone | Phone number (shipping address) |
| s_country | Two-letter country code (shipping address) |
| s_province | Two-letter province or state code (shipping address) |
| s_zip | Zip or postal code (shipping address) |
| b_name | The recipient name (billing address) |
| b_address1 | Street address (billing address) |
| b_address2 | Additional address line (billing address) |
| b_city | City (billing address) |
| b_company | Company name (billing address) |
| b_phone | Phone number (billing address) |
| b_country | Two-letter country code (billing address) |
| b_province | Two-letter province or state code (billing address) |
| b_zip | Zip or postal code (billing address) |