Import Customers - Free Sample Working Csv File [Download]

[Nyla C.]

Hello all. A while back several threads were started about the problems with downloading and importing Prestashop's default customer csv file. After a lot of headache and tweaking, I managed to create one from it that actually works and imported all of my customers from Shopify. 

 

This works with any ecommerce solution you're migrating from. Right now, it involves a lot of copy and paste, however it is still much faster than manually adding your 100s of customers yourself 1 by 1. So I wanted to share and save others a lot of time and frustration. 

 

With the following file, you will be able to import customers and automatically assign:

 

• First Name
• Last Name
• Title
• Newsletter Preference
• Opt In Preference
• Customer ID
• Password
• Email Address
• Customer Group
• And whether or not the customer should be active or disabled by default

 

This will not email your customers you import and let them know they have an account. 

 

The inside of the file looks like this:

"ID";"Social title";"First name";"Last name";"Email address";"Enabled";"Newsletter";"Opt-in";"Password";"Group ID"
"0001";"2";"Jane";"Doe";"[email protected]";"1";"1";"0";"Welcome123";"3"
"0002";"2";"Bob";"Doe";"[email protected]";"1";"1";"0";"Welcome456";"3"
"0003";"2";"Goldie";"Locks";"[email protected]";"1";"1";"0";"Welcome789";"3"

How to use this file:

 

1. Make sure the field titles are on the first row. This is important.
2. Copy and paste or either type your customer's information on a separate line. Be sure the info for each field is in the same order as the first row. 
3. Social Titles, Newsletter/Opt In preferences, and active/disabled preferences is passed to prestashop with a 0, 1 or 2.
   • Mr. = 1. Mrs. = 2. Active = 1. Disabled = 0. Signed up for newsletter = 1. Not signed up = 0. Opt in for partner offers = 1. Not opted in = 0.
4. For example, Jane Doe's ID is 0001. She is a Mrs. With first name Jane, last name Doe and an email address of [email protected]. She is enabled (1), is subscribed to the newsletter (1) but not partner offers (0), her password at login should be Welcome123, and she is in the customer group "Customers (group ID 3)"

 

Important Notes:

 

• Assigning passwords, IDs, newsletter preferences etc. is all optional. Just leave those sections blank but leave the commas to tell Prestashop 'nothing to see here! move to the next field."
• If you want to manually assign your customer IDs, make sure when importing your customers in prestashop, you select "force IDs upon import"

 

To make things easier, a sample file has been included in this post to get you started. Simply edit the file using any plain text editor (notepad++ is my favorite) and insert your customer information where needed. Each customer must go on a separate line. Save your file as a csv, upload to prestashop, follow the prompts and voila! Your customers will now be imported into Prestashop.

 

Note: The sample file is in txt format as Prestashop won't allow uploads of CSV files. But you can unzip the .zip file and find my sample file already saved in .csv format.

 

Please let me know if you need any help!

customers-sample.txt

customers-sample.zip

Edited January 19, 2016 by Milliona (see edit history)