What if you need to transfer customer data to Magento 2? You can use the default import tool to do that. However, it doesn’t let you move all the prospect-related information to your database. For instance, it is impossible to migrate customer passwords from external systems. Attempts to address this problem have been made utilizing numerous approaches. Below, we describe two of them.
You will find out how to import passwords to Magento 2 from external systems by manually editing your data files. Alternatively, we describe how to import the existing customer data including passwords to your e-commerce website on the basis of the Improved Import & Export extension.
The problem is that the new platform version utilizes an updated algorithm for storing passwords. Hence, users claim that after migrating to Magento 2 from Magento 1, registered prospects have to re-enter their passwords on a new website.
‘
If editing passwords manually fixes the problem caused by Magento versions discrepancy, Improved Import & Export dramatically extends the sphere of application for customer data import. The module lets you transfer information about registered buyers from any external platform automatically with any number of unsupported attributes. For further useful tips, check our Cookbook.
Table of contents
Joe describes the issue here: How to import MD5 password to Magento 2. The author tries to import customer info into Magento 2. However, his old website uses MD5 to store passwords. Therefore, Joe asks how to import the corresponding data correctly.
According to mzzl, the solution is quite simple but may take a decent amount of time, depending on the number of your customers. The author says that no extra code is necessary to support the MD5 hash in Magento 2. It is only required to add “:0” after the raw password.
Mzzl also says that Magento 2 utilizes numerous versions to hash passwords. As for version 0, it is MD5. Magento 1 uses it.
The author also compares the formats of how passwords are stored in both Magento 1 and Magento 2. In the case of the first version, you have to deal with the following structure:
|
{password hash}:{salt} |
When it comes to Magento 2, passwords are formatted as follows:
|
{password hash}:{salt}:{hash version} |
When importing customer passwords to Magento 2, you have to add the missing part to the password_hash field.
The more customers you have, the more time you will spend editing a CSV file. Luckily, there is a more efficient solution.
A user-friendly approach to import customer passwords to Magento 2
You can import customer passwords to Magento 2 along with other data in a more efficient way without editing anything. Meet the Improved Import & Export Magento 2 extension – your number one time-saver when it comes to data transfers to and from your e-commerce websites. Together with the Free Magento 1 to Magento 2 Migration add-on, it will help you import customer passwords to Magento 2 automatically. Let’s see how to do that.
First of all, you have to go to System->Improved Import/Export->Import Jobs and hit the “Add New Job” button there.
In General Settings, enable your new job, type its title, choose the manual run frequency (if you want to transfer customer passwords on a regular basis), select a language (locale), and enable/disable a few more features.
Next, proceed to the Import Settings section. Here, you can enable/disable API, choose Customers & Addresses as your import entity, and select a platform to import data from.
In Import Behavior, choose Add/Update from the dropdown, select a validation strategy, set a limit on the number of errors, and specify separators.
In Import Source, select an import file type. If we talk about the migration from Magento 1, it is usually a CSV format. Next, specify your import source: a server, Dropbox account, URL, or direct upload.
To import customer passwords to Magento 2, hit “Save & Run” in the top right corner of the screen. For further information about how to do that, follow the link below and contact our support:
Get Improved Import & Export Magento 2 Extension
If you need to transfer not only customers and their passwords but also other information, pay attention to the add-on since it simplifies transfers even more. It offers a similar approach to the one we’ve just described. Therefore, you only have to navigate to the Migration section, specify the path to your Magento 2 root folder, choose an entity you want to migrate, and hit ‘Run.’ That’s it! Our plugin transfers the data with no downtime!
Some of the add-on’s features include:
- Intuitive admin interface – no programming skills are required to migrate your Magento 1 data and import customer passwords to Magento 2;
- CLI commands – alternatively, you can rely on intuitive CLI commands that follow the same pattern;
- Selective migration – the following entities are supported: products, categories, customers, orders, price rules, tier prices, etc. Additional entities include reviews and ratings, catalog rules, credit memos, invoices, and URL rewrites;
- No downtime – due to the selective entity migration, the add-on allows avoiding store downtime, relying on reindex only;
- Custom XML filter – you can filter customer and product attributes via custom XML commands. It may simplify the way you import passwords to Magento 2.
- Magento 2 to Magento 2 migration – you can freely move data from one store to another or even merge two stores.
Get Free Magento 1 to Magento 2 Migration add-on
Firebear Magento migration service
In addition to the extension and add-on, the Firebear team offers a full-specter migration service. Thus, we can import customer passwords along with all entities you want to Magento 2. You provide us with access to your Magento 1 store and Magento 2 instance, and we migrate all the data you need.
It is the best option if you are not sure that you can perform the migration yourself. If you want to save time, leave it to the certified specialists how have done it a dozen times. Follow the link below to reach our support center:
Discuss the migration
Magento 2 Customer Password Import & Export FAQ
Let’s take a look at other nuances of importing and exporting customer passwords in Magento 2 with the help of the Improved Import & Export Magento 2 extension.
How to import and export customer passwords to Magento 2 automatically?
If you need to move customers, including customer passwords, between Magento 2 and third-parties or other Magento 2 websites on a regular basis, you can use the Improved Import & Export extension since it utilizes a cron scheduler for automating all data transfers. Thus, it lets you import and export customer passwords between Magento 2 and external destinations automatically, following a schedule of updates.
How to import customer passwords with third-party attributes to Magento 2?
While Magento 2 blocks the import of unsupported data that doesn’t follow its inner requirements, such as third-party customer attributes and values, the Improved Import & Export extension can easily do that with the help of a simple trick. The module lets you create a mapping scheme where you match third-party attributes and their values to ones used within the system. Consequently, any external data is automatically adapted to the native standards of your e-commerce website every time the plugin runs a transfer. Note that you can also apply mapping to export processes to generate the output your partners require.
How to import and export customer passwords to Magento 2 via API?
With the Improved Import & Export Magento 2 extension, you can create API connections to transfer not only customer data, including passwords, but all other entities, freely moving any information between Magento 2 and external systems. There is a section in every import/export job where you can specify the parameters necessary to sync the two systems. You can create a bi-directional API connection, exchanging customer data between the two systems. As for unsupported attributes, the plugin lets you leverage its mapping functionality described above.
How to import and export customer passwords to Magento 2 via ODS files?
Improved Import & Export lets you move customer passwords along with other customer data records stored in ODS files. You no longer need to convert them to CSV to fit the Magento 2 requirements. You can also export data using this file format.
How to import and export customer passwords to Magento 2 via XLSX files?
In addition to ODS, Improved Import & Export lets you move customer passwords along with other customer data records stored in XLSX files. You no longer need to convert them to CSV to fit the Magento 2 requirements. You can also export data using this file format.
How to import and export customer passwords to Magento 2 via JSON files?
If customer passwords are stored in a JSON file, you no longer need to convert the file to CSV to fit the Magento 2 requirements. With the Improved Import & Export Magento 2 extension, it is possible to import JSON files to your ecommerce website without any necessity to run the conversion. You can also export data using this file format.
How to import data to Magento 2 via compressed files?
If your files with customer passwords are compressed, you can also transfer them to Magento 2 with the help of the Improved Import & Export extension. Remember that file archives should be saved as ZIP or TAR. The module works with compressed CSV, XML, ODS, JSON, and XLSX files.
How to import data to Magento 2 from Google Sheets?
If customer passwords are stored in Google Sheets along with other customer data records, it is no longer a problem. There is no need to export them from the service, convert the output to CSV, and then transfer the file to Magento 2. The Improved Import & Export lets you move the corresponding information straight from Google Sheets, updating your database.
How to import and export customer passwords to Magento 2 from Dropbox?
In addition to Google Sheets, the Improved Import & Export module lets you transfer customer records including passwords to Magento 2 from Dropbox. You can store them there in CSV, JSON, XML, ODS, or XLSX files or ZIP and TAR archives. You can also use this file storage as your export destination.
How to import and export customer passwords to Magento 2 from Google Drive?
In addition to Dropbox and Google Sheets, the Improved Import & Export module supports another file source. The extension lets you transfer customer passwords to Magento 2 from Google Drive. You can store them there in CSV, JSON, XML, ODS, or XLSX files or ZIP and TAR archives. You can also use this file storage as your export destination.
‘
