Hi. How can we help?

Customer column titles

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 E-Mail 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

 The minimum required columns in a worksheet for a successful import.

Copy this table and paste it into your worksheet:
Firstname Lastname Email
  • 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.

Copy this table and paste it into your worksheet:
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

Customer details

Import customer details when you want to add/edit personal details like phone numbers and birthdate.

Copy this table and paste it into your worksheet:
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.
  • 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.

Copy this table and paste it into your worksheet:
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.

Copy this table and paste it into your worksheet:
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.

Copy this table and paste it into your worksheet:
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.

Was this article helpful?

1 out of 1 found this helpful