Skip to main content

Bulk Customer Import

Find out how to import, export and edit your customers.

Bulk Import

On the customer list page, tap then Download CSV template to download the customer template.

Within the template, 2 sample rows of data have been provided; these can be deleted.

Input customer data ensuring there are no duplicate email addresses. The CSV file must remain as a CSV file when saving.

Tap then Import to import the customers. The import will fail if there are duplicate email addresses or errors in the CSV. A list of reasons why the template failed to import will be displayed with the option to retry once the errors are rectified.

👀 Tip - Ensure spreadsheet column formatting remains as text. Watch out for this in Excel.


Export and edit customers

Tap then Export to export the current customer list view. Only the current filtered view will be exported.

From here you can edit the following customer information then reimport.

Row Type : Customer

  • First Name

  • Last Name

  • Company

  • Email

  • Phone

  • Mobile

  • Marketing - Y/N

  • Group - Add/remove a pre-existing customer group

  • Date of Birth

  • Loyalty Enabled - Y/N

  • Job Title

  • Website

  • Notes

  • Credit Limit

  • Invoice Country Code

  • Account Number

  • Company Reg No

  • Company Tax No

  • EORI Number

  • Price List - Assign a pre-exiting price list

  • Delete

Row Type : Address

  • Address Line 1

  • Address Line 2

  • Town

  • County

  • Postcode

  • Country

  • Latitude

  • Longitude

The following rows must not be edited

  • Row Type

  • Customer ID

  • Address ID

  • Address Type

  • Source


Add a customer

For guidance on manually adding a customer, please refer to the Customers section of the help centre.

Did this answer your question?