Import Model: Creating Customers

Importing customer information is a very quick way to get a list of customers into your website. This is especially useful if you have an existing website with customers.*

Contents

Overview

The data that you are going to use to create customers can come from multiple areas. It can be data that is built from scratch as described below or it can be data from an existing database. 

Steps

When using the customers module you will need to first create a spreadsheet indicating all of the values that you would like to display for each customer. Once you have created your spreadsheet and saved it as a CSV file, you can import into WSM. Importing locations is a four step process, 1) Create customer spreadsheet, 2) Save the file as a CSV 3) Copy the global profile and customize if needed, 4) Import the file.

Form Fields Defined

  • Default:The value which is automatically displayed if you have not designated a value on your import file.
  • Values:Indicates how you must enter the text for that particular field category.
  • Delimited: Indicates what you must use for your Multi-Value Delimiter when having multiple cells load into one profile field. This feature is most commonly used when loading product images, as many times clients wish to show multiple product images for each item. If the MVD was a - your VALUES would read as the following: ${column header1}-${column header2}-${column header3}
  • Force Update:Indicates whether a force update must be clicked to have the new data load over the existing data. A force update is needed when an existing field’s information does not automatically update with the new csv file’s data.
  • Character: Either a restriction or recommendation for this field.
  • Special Notes:See special notes section for any additional details that may need to be referenced.


Field Names Defined:
Account StatusDefault: Active
Values: 
active, hold, probation
Delimited: N/A
Force Update: No
Special Notes: Must use one of the provided values. Active: Customer can add to cart and checkout. Probation: Customer can add to cart and checkout. Account Status Message will appear, if provided. Hold: Customer can add to cart but not checkout. Account Status Message will appear, if provided. If they attempt to checkout an additional message will appear.
ActiveDefault: No
Values: 0 or 1
Delimited: N/A
Force Update: No
Character Limit: 
Special Notes: 1=Yes, 0=No.  When set to No the account is set as inactive and the customer will not be able to sign in to their account from the front end of the site. 
Account NumberDefault: Blank
Values: 
Text, No HTML
Delimited: 
N/A
Force Update: 
No
Character Limit: 
255 
Special Notes: 
This number is typically assigned by the client and cannot be changed by the Customer.
Admin NotesDefault: Blank
Values: 
Text, No HTML
Delimited: 
N/A
Force Update: 
No
Character Limit: 2,000,000
Special Notes: Admin-only customer reference material. This information is never displayed to customers.
 Balance DueDefault: 0.00
Values:
 Numberic, two decimal
Delimited:
 N/A
Force Update:
 No
Special Notes: 
Balance due for this customer. When the value is greater than 0.00 the balance due will be displayed on the the My Account screen, when customer is logged into the site.
BirthdateDefault: Blank
Values: Date
Delimited: N/A
Force Update: No
Character Limit: 8
Special Notes: This is not a required field but can be helpful if you want to run a promotion for birthdays or if you require a certain age for someone to access your data.
CreatedDefault: Today's Date
Values: Date & Time, format 2012-01-01 01:01:01
Delimited: N/A
Force Update: No
Character Limit: N/A
Special Notes: Indicate when the customer was created. Non importable, assigned by the data base.
Customer NotesDefault: Blank
Values: Text, HTML
Delimited:
 N/A
Force Update:
 No
Character Limit: 2,000,000
Special Notes: 
When entered, the information will be displayed to the client on the My Account, Cart and Checkout screen.
First NameDefault: Required
Values: Text, No HTML
Delimited: N/A
Force Update: No
Character Limit: 255
Special Notes: The first name of the Customer.
Access Group(s)Default: Blank
Values: Access group ID
Delimited: ;
Force Update: No
Character Limit: N/A
Special Notes: A customer can be assigned to more then one access group. When assigning the CSV file should contain the access group ID.  
Invoice PaymentDefault: No
Values: 0 or 1
Delimited: N/A
Force Update: No 
Character Limit: 
Special Notes: 1=Yes, 0=No. When enabled the only payment option available.
Last AttemptDefault: Blank
Values: A Date & Time, format 2012-01-01 01:01:01
Delimited:
 N/A
Force Update:
 No
Character Limit: 
N/A
Special Notes:
 Typically not import. Last Attempt is logged when a customer failed during log in.
Last LoginDefault: Blank
Values: A Date & Time, format 2012-01-01 01:01:01
Delimited:
 N/A
Force Update:
 No
Character Limit: 
N/A
Special Notes: It will list the last date and time the customer successfully logged in. 
Last NameDefault: Required
Values: Text, No HTML
Delimited: N/A
Force Update: No
Character Limit: 255
Special Notes: The last name of the Customer.
NewsletterDefault: No
Values: 0 or 1
Delimited: N/A
Force Update: No
Character Limit: 1
Special Notes: 1=Yes, 0=No. When set to yes the customers email will be apart of your newsletter data feed.
Block Free ShippingDefault: No
Values: 0 or 1
Delimited: N/A
Force Update: No 
Character Limit: 
Special Notes: 1=Yes, 0=No. When enabled the customer will not be able to use the free shipping methid during checkout. This only applies to the free shipping method set in the system configuration, not the free ground shipping at the product level.
No TaxDefault: No
Values: 0 or 1
Delimited: N/A
Force Update: No 
Character Limit: 
Special Notes: 1=Yes, 0=No. When set to yes the customer will not be charged sales tax during the checkout process. 
PasswordDefault: Required
Values: Text, No HTML
Delimited: N/A
Force Update: No
Character Limit: Minimum of 5 characters
Special Notes: The password must include one upper case and one numeric value, must be a minimum of 5 characters.
Price GroupDefault: Blank
Values: Access group name
Delimited: N/A
Force Update: No
Character Limit: N/A
Special Notes: A customer can only be assigned to one price group. When assigning the CSV file should contain the price group name
EmailDefault: Required
Values: 
Text, No HTML
Delimited: 
N/A
Force Update: 
No
Character Limit: 
255
Special Notes: 
Email address for customer. This is also the username to login. It is required and must be unique accross all customers.

Summary

Once you've successfully imported customers and your site is live, you can email them the new site information with login instructions.

For additional assistance with importing please complete our support request form.

Note: Due to different password requirements from different systems we are not able to import passwords from different sources. Instead we recommend you reset all passwords for your customers and notify them of the change.