This table lists all the customer information you can export. This is useful when creating your worksheet for Importing customers.
Col. # | Group | Column name | Suggested column mapping when importing |
04 | Required column | Firstname | Customer - First name |
06 | Required column | Lastname | Customer - Last name |
07 | Required column | Customer - Email address | |
01 | System | Internal ID | Customer - Internal ID |
02 | System | Registered | Customer - Registered at |
03 | Account details | Language | Customer - Language |
05 | Customer details | LastnamePreposition | Customer - Middle name |
08 | Customer details | Phone | Customer - Phone |
09 | Customer details | Mobile | Customer - Mobile |
10 | Account details | Customer type | Customer - Type |
11 | Business details | Company | Customer - Company name |
12 | Business details | Coc number | Customer - COC number |
13 | Business details | Vat number | Customer - Tax number |
14 | Billing details | Attn | Customer - Billing attention |
15 | Billing details | Streetname | Customer - Billing address 1 |
16 | Billing details | Address 2 | Customer - Billing address 2 |
17 | Billing details | Number | Customer - Billing house number |
18 | Billing details | Extension | Customer - Billing extension |
19 | Billing details | Zipcode | Customer - Billing zip code |
20 | Billing details | City | Customer - Billing city |
21 | Billing details | Region | Customer - Billing region |
22 | Billing details | Country | Customer - Billing country |
23 | Shipping details | Shipping Attn | Customer - Shipping attention |
24 | Shipping details | Shipping company | Customer - Shipping company |
25 | Shipping details | Shipping Streetname | Customer - Shipping address 1 |
26 | Shipping details | Shipping Address 2 | Customer - Shipping address 2 |
27 | Shipping details | Shipping Number | Customer - Shipping house number |
28 | Shipping details | Shipping Extension | Customer - Shipping extension |
29 | Shipping details | Shipping Zipcode | Customer - Shipping zip code |
30 | Shipping details | Shipping City | Customer - Shipping city |
31 | Shipping details | Shipping Region | Customer - Shipping region |
32 | Shipping details | Shipping Country | Customer - Shipping country |
33 | Account details | Groups | Customer - Groups |
34 | Customer details | Birthdate | Customer - Birthdate |
35 | Customer details | Gender | Customer - Gender |
36 | Account details | Confirmed | Customer - Confirmed |
Column title descriptions
The column title descriptions have been grouped by similarity for ease of understanding. Optionally, if you intend on importing one of the column titles in a group, consider importing the rest of the group as well, as the information is related.
- Required columns
- Account details
- Customer details
- Business details
- Billing information
- Shipping information
- System
Required columns
The minimum required columns in a worksheet for a successful import.
Firstname | Lastname |
- First name
Firstname
- The first name of your customer.- No limit to length
- Last name
Lastname
- The last name of your customer.- No limit to length
- Email
E-mail
- The email address of your customer.- Must be formatted as an email, including the @ symbol.
- The email will also be username of the customer.
- Used by Lightspeed eCom to identify which customer should be updated when importing.
- The email cannot be updated by importing. Attempting to edit it via import will result in a new customer being created.
Account details
Import account details to control parts of the customer's account.
Language | Customer type | Groups | Confirmed |
- Language
Language
The language abbreviation used by the customer.- Must be enabled in the eCom Back Office > Settings > Store country before you import a new language to a customer.
- To know which abbreviation to use, see the Language table.
- Customer type
Customer type
- Whether the customer is a Private or Business customer.- If a Business customer, select: Company
- Otherwise, the it will be as a Private customer.
- Groups
Groups
- The customer group that is assigned to a customer.- Existing groups can be found in your eCom Back Office > Customers > Customer Groups.
- Format: You can enter any group name in your import file, exactly as shown. If the group doesn't exist in Lightspeed eCom, a new customer group will be created automatically.
- Confirmed
Confirmed
- Whether the customer is allowed to login to their customer account.- The format of the contents of the cell are:
- To confirm the customer, type: Yes
- To unconfirm the customer, type: No
- The format of the contents of the cell are:
Customer details
Import customer details when you want to add/edit personal details like phone numbers and birthdate.
LastnamePreposition | Phone | Mobile | Birthdate | Gender |
- Middle name or Preposition
LastnamePreposition
- The middle name of your customer.- For Dutch names, where the last name prefix of van or van der may be entered. For example, Amber van der Bijl:
- Amber would be entered in the first name column
- van der would be entered in the proposition column
- Bijl would be added in the last name column.
- For Dutch names, where the last name prefix of van or van der may be entered. For example, Amber van der Bijl:
- Phone number
Phone
- The customer's main phone number. - Mobile phone number
Mobile
- The customer's mobile phone number.- Enter a numeric value
- Birthday
Birthdate
- The birthdate of the customer. - Gender
Gender
- The gender of a customer.
Company information
Import company information when you have business-to-business (B2B) customers.
Company | Coc number | Vat number |
- Company
Company
- The name of the customer's company.- When a company is entered, this is in the billing address.
- Coc number
Coc number
- The customer's Chamber of commerce number.- For European customers only
- Vat number
Vat number
- The customer's value added tax (VAT) number- For European customers only
Billing information
Import billing information for your customer's account to simplify the checkout process once a customer logs in to their account.
Attn | Streetname | Address 2 | Number | Extension | Zipcode | City | Region | Country |
- Attn
Attn
- The person or office to which the package is directed. - Streetname
Streetname
The street number and street name.- In North America, the building number appears before the street name. For example, 123 N Cannon Dr.
- In Europe, only enter the street name.
- Address 2
Address 2
Additional information required for the billing address.- For example, P.O. Box 123
- Number
Number
- The house or building number that should appear after the street name in the billing address.- If the customer selects a North American country, this field will not appear.
- For some European countries, the building number appears after the street name.
- For example, Surinamestraat 27
- Extension
Extension
- Some postal codes have an extension, this number is entered here. - Zipcode
Zipcode
- The zip or postal code. - City
City
- The city of the billing address - Region
Region
- The province, state or region of the billing address. - Country
Country
- The country of the billing address
Shipping information
Import shipping information for your customer's account to simplify the checkout process once a customer logs in to their account.
Shipping Attn | Shipping company | Shipping Streetname | Shipping Address 2 | Shipping Number | Shipping Extension | Shipping Zipcode | Shipping City | Shipping Region | Shipping Country |
- Shipping Attn
Shipping Attn
- The person or office to which the package is directed. - Shipping company
Shipping company
- The name of the company to which the shipping address is addressed. - Shipping Streetname
Shipping Streetname
- The street number and street name.- In North America, the building number appears before the street name. For example, 123 N Cannon Dr.
- In Europe, only enter the street name.
- Shipping Address 2
Shipping Address 2
- Additional information required for the shipping address.- For example, P.O. Box 123
- Shipping Number
Shipping Number
- The house or building number that should appear after the street name in the billing address.- If the customer selects a North American country, this field will not appear.
- For some European countries, the building number appears after the street name.
- For example, Surinamestraat 27
- Shipping Extension
Shipping Extension
- - Some postal codes have an extension, this number is entered here.
- Shipping Zipcode
Shipping Zipcode
- The zip or postal code. - Shipping City
Shipping City
- The city of the shipping address - Shipping Region
Shipping Region
- The province, state or region of the shipping address - Shipping country
Shipping Country
- The country of the shipping address
System
Information used by the system that appears on an export.
There is no reason to copy these fields into your worksheet when importing.
- Internal ID
Firstname
- A permanent, unique number used by Lightspeed eCom for the customer page.- Unlike products, not a required field when importing. The import tool uses the email to locate a unique customer, not the Internal ID.
- Cannot be edited when importing
- Will appear as a number after /admin/customers/ in your eCom Back office.
For example, if the internal ID is 123456 a customer's web page may be: https://www.yourdomain.com/admin/customers/123456
- Registered
Firstname
- The date and time the customer account was created.- Cannot be updated by manually or by import.