Magento 2.x – Import customers csv with encrypted passwords
Hi there,
If you are trying to import customers with an assigned password, or just modify a customer password trough the Magento csv import tool, you will have to bear in mind, that Magento uses the SHA2 encryption type, so, you will have to set the password value encrypted.
For instance, if you want to set up a password like “Happy2022!” you will need to put this in your csv password_hash column: “bf2bfd4cef27cbd8a1d73f76d0f32284589417dd5abcdfe6601b80dab6ac7240:xxxxxxxx:1”
You can use as example, the following csv file:
|
1 2 3 |
email,_website,_store,confirmation,created_at,created_in,disable_auto_group_change,dob,firstname,gender,group_id,lastname,middlename,password_hash,prefix,rp_token,rp_token_created_at,store_id,suffix,taxvat,updated_at,website_id jondoe5@example.com,base,base,,2015-10-30 12:49:47,Main Website,0,,Jon,,7,Doe,,bf2bfd4cef27cbd8a1d73f76d0f32284589417dd5abcdfe6601b80dab6ac7240:xxxxxxxx:1,,07e71459c137f4da15292134ff459cba,2015-10-30 12:49:48,1,,,2015-10-30 12:49:48,1 jondoe6@example.com,base,base,,2015-10-30 12:49:47,Main Website,0,,Juan,,7,Perez,,bf2bfd4cef27cbd8a1d73f76d0f32284589417dd5abcdfe6601b80dab6ac7240:xxxxxxxx:1,,07e71459c137f4da15292134ff459cba,2015-10-30 12:49:48,1,,,2015-10-30 12:49:48,1 |
Hope it helps.
Enjoy.!