Rating 0 stars - 0 votes

How to Import WooCommerce Users with Pre-Hashed Passwords?

When planning to transfer clients database to another store, you might want to migrate WooCommerce users with pre-hashed passwords. WooCommerce admin does not provide such a possibility, so you may be looking for a way to accomplish such procedure without coding.

Store Manager allows WooCommerce customer migration with pre-hashed passwords to ensure high-level security. The process is executed via Export/ Import Wizard and requires no programming skills. You can check the tutorial below.

How to Migrate WooCommerce Users With Pre-Hashed Passwords via Store Manager?

Export Customers with Passwords

  1. Open 'Store' tab and go to 'Users' section.

  2. Open Store tab and go to Users section

  3. Highlight the customers you want to migrate and press 'Export data' button.

  4. Highlight users and press Export data button

  5. Select the location on your computer where to save the export file to.

  6. Select location to save exported users to

  7. Select the delimiters to be used in the file.

  8. Select delimiiters for CSV

  9. Choose the database fields to export. To do that, move the fields from the left grid to the right grid using the buttons in between. Make sure to move the Passwords field.

  10. Choose fields to be exported to CSV

  11. On the next step, specify whether you want to export all the customers or only the selected ones. If you open the advanced options, you will find settings for exporting data values and numbers.

  12. Select what customer records to export

  13. Press 'Export'.

CSV File Sample

Now, when you look up into the exported CSV, you'll find that the customers' passwords are already hashed. To ensure the security of the process, Store Manager encodes them right during the export. Here how your export file should look like:


Exported users with hashed passwords


Import Customers with Pre-Hashed Passwords

To import WooCommerce customers with passwords to another store, first make sure to change store connection in Preferences (F12).


Change connection in Preferences

After that, proceed through the import:

  1. In the 'Users' section, press the 'Import data' button.

  2. Go to Users section and press import data button

  3. Select the file to import using the browse button.

  4. Select CSV file with users data to import

  5. Select the delimiters that will be used in the import file. You can preview how the CSV will look with the selected delimiters under the settings.

  6. Exported users with hashed passwords

  7. Next, map database fields to source file columns.

  8. Map database fields to cSV columns

    It is possible to make Store Manager apply SQL expressions during the import. To do that, press the 'Edit' button in the 'Expression' column.


    Apply expressions to data during WooCommerce users import

  9. Select the import method:
    • Modify only (only update the existing customers)
    • Just add (create new users without searching for the existing ones)

    Select import method for WooCommerce users import with passwords

    If you press on the 'Show the advanced' options button, you will find there a checkbox allowing not to re-hash the passwords during the import.


    Check not to re-hash imported WooCommerce passwords

    Here may be two variants:

    • In case, you are importing CSV file that was previously exported with Store Manager, make sure to tick this box. Otherwise, the passwords will be hashed again.
    • In case you are importing customers with passwords that were not previously encoded, leave this box unchecked.
  10. Press 'Import'.

When importing data to another store, the possibility to migrate customers with pre-hashed passwords will come to great help. Store Manager for WooCommerce provides an absolutely user-friendly way to accomplish the procedure. You can test a 14-days trial version of the application and check if it suits your purposes.

Migrate WooCommerce users with pre-hashed passwords for free

Try Now

COMMENTS
Be the first to comment.