Import Customers

Customer Manager

Import Customers

File Format

First row of the CSV file should be the column name. Name of the column should follow the naming convention as stated below.
Column Name Type Description
Username Optional User name that customer will use to login to your website. Leaving this blank will default to email address.
First Name Required
Last Name Optional
Email Required Email address will be used as default password
Phone Optional
DOB Optional ISO 8601 Format (YYYY-MM-DD)
Company Optional
Address 1 Optional
Address 2 Optional
City Optional
Postal Code Optional
State Optional
Country Optional English Shortname or ISO 3166-1 Alpha-2 or ISO 3166-1 Alpha-3 Code. Refer here for more details.
User Group Optional
Reward Points Optional
Membership Tier Optional Value is 1, 2 or 3 indicating the account membership tier.
Membership Expiry Optional ISO 8601 Format (YYYY-MM-DD)
Membership Accumulation Optional
Accumulation Date Optional ISO 8601 Format (YYYY-MM-DD)
Accept Marketing Optional Yes/No