CSV import customers, password encryption

[ItByBart]

Dear forum,

 

I am trying to import customers from PS 1.4 to PS 1.6.

Procedure:

- Export customers from PS 1.4 in to csv file

- Import customers into PS 1.6 via advanced settings, import CSV, customers

- All customers are imported, nice and quickly.

 

But ..... the export file contains encrypted passwords and not working in PS 1.4, how can I import these into PS 1.6 without regenerating passwords.

 

 

Please advise .......

 

 

Grtz,

 

Bart.

 

 

 

[tuk66]

Try to learn from the autoupgrade module, how it upgrades.

[El Patron]

config/settings.inc.php

 

here you will find keys to  1.4 that need to be updated in 1.6 (same file)

in particular you will need the the following key which is used for pwd encrypt

 

define('_RIJNDAEL_KEY_', 'put your 1.4 value into 1.6 file');

 

hope  that helps

[ItByBart]

Thx for your reply's.

As a understand the assword is encryted and it is not done to decrypt it (if possible at all !).

This implies that I will migrate customers and addresses but they need to request their password via the "forgot your password" procedure.

 

Grtz,

Bart

[frank de beer]

bart,

You dont need to decript the passwords. and your customers won't need to change their password.

just use the data in config/settings.inc.php, line define('_RIJNDAEL_KEY_', 'xxx'); 

it's somewhere at the bottom of the file. you can edit it with wordpad of similar

copy the line from your 1.4 site to the config.inc.php file in the 1.6 site.

the characters at the 'xxx' is the key used to encript the passwords

it's what El Patron also tries to tell you

[Kerm]

 

config/settings.inc.php

 

here you will find keys to  1.4 that need to be updated in 1.6 (same file)

in particular you will need the the following key which is used for pwd encrypt

 

define('_RIJNDAEL_KEY_', 'put your 1.4 value into 1.6 file');

 

hope  that helps

 

 

For sure after that he lost his access to back office.

Need also copy ps_employe table and login using login and password from 1.4...

[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 = 2.
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

customers-sample.txt

customers-sample.zip

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