Import Export WordPress Users and WooCommerce Customers

Description

WordPress User Import Export plugin allows the import and export of WordPress users and WooCommerce customers quickly and easily. User export and user import are much-required features while moving WordPress / WooCommerce sites.

🔸 Users Export – Export Users to CSV.
🔸 Users import – WordPress Import Users from CSV.
🔸 Customer Export – Export WooCommerce customers to CSV
🔸 Customer Import – Import WooCommerce customers from CSV
🔸 Batch Export/Import
🔸 Export/Import based on user roles, user email, date range
🔸 Retain user passwords (optional)
🔸 Map and Transform fields while importing customers/users
🔸 Change values (bulk modify) while importing customers/users using Evaluation Fields
🔸 Export Guest users – Include data of WooCommerce guest customers(users who bought products from site without creating an account).
🔸 Export specific users based on username/email – Suggests email addresses and names in export data filter fields while you type in.
🔸 Tested OK with WordPress 5.9
🔸 Tested OK with WooCommerce 6.2
🔸 Tested OK with PHP 8.0

Highlights: WordPress Users Export, WordPress Users CSV Import Suite, Export WordPress Users to CSV. Pro Version supports export and import of all additional user meta like WooCommerce details.

How does it work?

The Import Export WordPress Users Plugin takes CSV (Comma-Separated Values) file as input. You must create a CSV file and enter the user details in a structured format as explained in the tutorial. This is to match each field of CSV file to the field of particular user fields, otherwise, Admin needs to input manually. For example, the user_email field gets mapped to the User Email. For the plugin to work correctly, you must map headers of all the column correctly and you must ensure that all of the fields you enter is in the correct format.

You can create the CSV from the scratch or you can export the users to get the format of CSV. You can use a spreadsheet program, such as Microsoft Excel, OpenOffice, Libre office, or Google Spreadsheets for creating and modifying the CSV file. Save this file in UTF-8 encoding with extension .CSV. After entering all details about users in a spreadsheet, you can bulk import users to WordPress. With this plugin, you can also export and download user details as a CSV file.

More information about the set up of the plugin and a sample CSV that is taken as input by the plugin is given in the WordPress Users & WooCommerce Customers Import Export Plugin – User Guide.

Watch the video on getting started with the plugin.

Premium version Features

✅ Import Export WordPress Users & WooCommerce Customers
✅ Export/Import WooCommerce User/Customer details into CSV and XML format. (Basic version supports only CSV Import-export)
✅ Option to choose All Roles or Multiple Roles while export.
✅ Various Filter options (User Roles, User Email, Date Range, Offset/Limit, Guest Users, Ascending/Descending Sort) for exporting Customers/Users.
✅ Map and Transform fields while Importing Customers.
✅ Map and Transform fields while Importing Customers.
✅ Change values while importing Customers using Evaluation Fields.
✅ Export User Meta. (custom fields and hidden metadata supported in addition to other user data)
✅ Choice to Update or Skip existing imported Customers.
✅ Bulk update existing customers/user data.
✅ Choice to Send or Skip emails for newly imported Customers.
✅ WPML Supported. French language support.
✅ Export Import users/customers to/from a remote server via FTP in Scheduled time interval with Cron Job.
✅ Supports Import from URL.
✅ Third party plugin customization support.
✅ Compatible with BuddyPress, Ultimate Member, Ultimate Membership Pro, Better Notifications for WP, Advanced Custom Fields (ACF) etc.
✅ Excellent Support for setting it up!

Please visit Import Export WordPress Users & WooCommerce Customers for more details

Use Cases Handled

Import Export WordPress Users Plugin is an ideal plugin for exporting and importing WordPress users or WooCommerce customers’ details from/to your WooCommerce store for migrating an existing online store.

The following use cases are handled by the plugin

✅ User Export – Export WordPress users to CSV.
✅ User Import – Import WordPress users from CSV.
✅ Customer Export – WooCommerce Export Customers to CSV.
✅ Customer Import – WooCommerce Import Customers from CSV.

WordPress Export Users to CSV

With this WordPress user export plugin, you can export WordPress users from the WordPress site and generate a CSV file. Use this CSV file to migrate users to another WordPress site by first using the WordPress Export Users functionality and then the import or merge users (update existing users) functionality of this plugin. If you have hundreds, even thousands, of WordPress users, this helps to save your effort and time of manually adding user information.

You can bulk export users’ details to a CSV file with multiple powerful filters such as User Roles, date ranges, etc. Even the plugin automatically uploads your exports via FTP(premium).

WordPress Import Users from CSV

You can import WordPress users to your WordPress site from other platforms easily and quickly using this WordPress user import plugin. Using the WordPress user import or merge users (update existing users)feature you can import hundreds or thousands of WordPress users’ details using one file which saves your effort and time of manually adding user information.

This WordPress import plugin has the option to send an Email to the user email ID whenever the admin imports/updates users’ details.

You can map your import columns to the appropriate WordPress data to import or merge user details. You can also import data from a variety of sources, such as an uploaded CSV file on FTP (Premium), locally saved CSV file to your computer.

For importing WordPress user details to your website, you must create a CSV(Comma-Separated Values) file which contains information about mapping fields in a tabular form. You can create a CSV file by using a spreadsheet program, such as Excel, or Google Spreadsheets. Save this file with extension ‘.csv’. After entering all details about WordPress users in the spreadsheet, you can import them to your website.

WooCommerce Export Customers to CSV

You can export the WooCommerce customer list from WordPress/WooCommerce site and generate a CSV file. Use this CSV file to migrate customers to another online store by WordPress import customers functionality or merge customers (update existing customers-premium) functionality of this plugin. If you have hundreds, even thousands, of WooCommerce Customers, this helps to save your effort and time of manually adding the WooCommerce customer list.

The plugin can easily export customers’ details to CSV files by filtering customers by user role. Even the plugin automatically uploads your exports via FTP (premium).

WooCommerce Import Customers from CSV

You can import WooCommerce customers to WordPress/WooCommerce sites easily. WooCommerce import customers feature or merge customers feature (update existing customers) help move or update hundreds, even thousands, of customers details using one file which saves your effort and time of manually adding user information.

The plugin has the option to send an Email to the user email ID whenever the admin imports/updates customer details (premium).

You can map your import columns to the appropriate WooCommerce data to import or merge customer details. You can also import data from a variety of sources, such as an uploaded CSV file on FTP (Premium), locally saved CSV file to your computer.

For importing WooCommerce customer details to your website, you must create a CSV(Comma-Separated Values) file which contains information about mapping fields in a tabular form. You can create a CSV file by using a spreadsheet program, such as Excel, or Google Spreadsheets. Save this file with extension .CSV. After entering all details about WooCommerce users in the spreadsheet, you can import them to your website.

Import/Export/Migration Plugins for WooCommerce from WebToffee

🔸 WooCommerce Product Import Export Plugin: Easily import and export products to/from your WooCommerce store using a CSV file.
🔸 WooCommerce Order/Coupon/Subscription Import Export: The plugin lets you export and import orders and coupons via CSV to and from your WooCommerce store.
🔸 WordPress Backup & Migration: Quickly migrate and backup entire WordPress site or selected files from one location to another. Backup to FTP, Google Drive, Amazon S3, or local storage and easily restore them.

About WebToffee.com

WebToffee creates quality WordPress/WooCommerce plugins that are easy to use and customize. We are proud to have millions of customers actively using our plugins across the globe.

Screenshots

  • WordPress user export import plugin general settings

  • WordPress user exporter screen

  • WordPress user export filters

  • Map or re-order columns on WordPress user export

  • WordPress user batch export

  • WordPress user import-export template save option

  • WordPress import users screen

  • Map or re-order columns on WordPress user import

  • Bulk update WordPress users when importing from CSV

  • Advanced WordPress user import options and batch import

  • WordPress user CSV import export history

  • WordPress user import export log

Installation

  1. Upload the plugin folder to the /wp-content/plugins/ directory.
  2. Activate the plugin through the Plugins menu in WordPress.
  3. That’s it! you can now configure the plugin.

FAQ

Does this plugin export users to excel?

This plugin exports user data to CSV which can be opened with Excel and saved as an Excel file.

Does this plugin support multiple roles?

Yes. You can export import users along with multiple user roles

Does this plugin export WooCommerce customer data?

Yes. Using the premium version you can export customer data as well.

Can the plugin handle WooCommerce export customer emails?

Yes. In the premium version, the exported CSV will have all customer emails. WooCommerce export customer email plugin basically does the same by exporting all customer emails to a CSV.

Does this export users with passwords?

Yes. This plugin will export users with passwords

Does this import users with their passwords?

Yes. This plugin will import users with the password, so users can use the same old password in the imported site as well

Does this plugin support WooCommerce customer order CSV export?

No. You may want to use Order Export & Order Import for WooCommerce for this

Are you redirected to the dashboard or login page while exporting?

By default, admin and store manager are given access to export users. Please visit How to export users without user role restriction for more details

Do Import Export WordPress Users support Multisite?

Yes, the plugin supports exporting users from each sub-sites of the multisite network.

Does this plugin export custom data fields?

This version of the plugin does not support the import or export of user custom data fields. It is one of our premium features. Please have a look at the premium version of the plugin to export and import custom metadata fields.

Can this plugin update existing user data?

Yes, you can update the user data with the help of this plugin. The users will be updated during the import if the ‘If the user exists in the store’ field in the Advanced options is set to ‘Update’.

Imported customers are not listed under WooCommerce customers

Please refer the article on how to refresh WooCommerce customers list

Reviews

March 15, 2022
Works like a charm, and has so many configuration options, and guides you so clearly, that one is always in control during the export, even if you have almost no previous experience with such plugins.
March 14, 2022
Seamless export and import of users from one wordpress site to another. Recommended!
February 20, 2022
Migrating from one membership system to MemberPress so this plugin was literally a lifesaver because it was able to transfer members' passwords over. Otherwise, it would have been a nightmare sending out notifications for them to all have to reset theirs. Thanks!!
Read all 282 reviews

Contributors & Developers

“Import Export WordPress Users and WooCommerce Customers” is open source software. The following people have contributed to this plugin.

Contributors

“Import Export WordPress Users and WooCommerce Customers” has been translated into 2 locales. Thank you to the translators for their contributions.

Translate “Import Export WordPress Users and WooCommerce Customers” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

2.2.8

  • Enhancement: Performance and UI improvements, text corrections.

2.2.7

  • WP 5.9 Tested OK.

2.2.6

  • Improvements: Optimise user email search filter to work without WooCommerce

2.2.5

  • WC 6.1 Tested OK
  • Add – Export guest users option.
  • Fix – user_status column value export.

2.2.4

  • WC 6.0 Tested OK

2.2.3

  • WC 5.9 Tested OK

2.2.2

  • Bug Fix: Upload timeout issue.

2.2.1

  • WC 5.8 Tested OK
  • Improvements: Added filter wt_import_csv_parser_keep_bom for escaping cyrillic letters.
  • Fixes: Keeping previously selected options when e-running the export/import and wp_max_upload_size(), mb_detect_encoding() related issues.

2.2.0

  • WC 5.7 tested OK

2.1.9

  • Added support for customer shipping phone number import export
  • WC 5.6 tested OK

2.1.8

  • Bug fix: Email and username validation improvements
  • WP 5.8 tested OK
  • WC 5.5 tested OK

2.1.7

  • Bug fix: Default role getting added when importing with a custom role

2.1.6

  • Faq update: Refresh WooCommerce customer list after import

2.1.5

  • Text corrections and batch count defaulted to 10

2.1.4

  • Menu access capability update

2.1.3

  • Tested OK with PHP 8.0

2.1.2

  • Tested OK with WC 5.2.2

2.1.1

  • Tested OK with WC 5.2.0

2.1.0

  • Improvements.

2.0.9

  • Plugin name update.

2.0.8

  • Tested OK with WC 5.1.0 and WP 5.7
  • Check existing users default with user_email while importing.

2.0.7

  • Tested OK with WC 5.0.0 and WP 5.6.1
  • Version 2.0.0 onward has been revamped majorly.

2.0.6

  • Content update.
  • Version 2.0.0 onward has been revamped majorly.

2.0.5

  • New Feature: Update existing users.
  • Improvement: Content updates.
  • Improved UI for better user experience
  • Tested OK with WC 4.9.0
  • Version 2.0.0 onward has been revamped majorly.

2.0.4

  • Improvement: Content updates.
  • Tested OK with WC 4.8.0
  • Version 2.0.0 onward has been revamped majorly.

2.0.3

  • Fix: Issue with importing user roles.
  • Improvement: Added more filters for export.
  • Tested OK with WP 5.6
  • Tested OK with WC 4.7.1
  • Version 2.0.0 onward has been revamped majorly.

2.0.2

  • Fix: Batch count issue for quick export.
  • Fix: Issue with password migration for quick import.
  • Tested OK with WC 4.7.0.
  • Version 2.0.0 onward has been revamped majorly.

2.0.1

  • Fix: Browser popup blocker issue.
  • Tested OK with WC 4.6.1.

2.0.0

  • Heads up! This version has been revamped majorly.
  • Improved UI for better user experience
  • Export/Import options: via a pre-saved template or a quick(standard columns) export/import
  • Option to export/import selective columns
  • Option to reorder columns during export
  • Import: Support for different types of delimiters
  • Export/Import options: Batch option with configurable batch count
  • History of all the Import/Export process
  • Dedicated logs for debugging failures
  • Tested OK with WC 4.6.0

1.4.4

  • Tested OK with WC 4.5.0 and WP 5.5.1

1.4.3

  • Tested OK with WC 4.3.1 and WP 5.4.2

1.4.2

  • Tested OK with WC 4.1.0 and WP 5.4.1

1.4.1

  • Tested OK with WP 5.4

1.4.0

  • Tested OK with WC 4.0.1
  • Improvement:-‘wt_hashed’ column name changed to ‘wt_hash’ in csv.

1.3.9

  • [Improvement] Security

1.3.8

  • Security fix.

1.3.7

  • Tested OK with WC 3.9.2
  • Improvement:-Password hashed before import based on ‘wt_hashed’ column in csv.

1.3.6

  • Tested OK with WP 5.3.2
  • Content update.

1.3.5

  • provision to export for Super Admin.
  • Tested OK with WC 3.8.1 and WP 5.3

1.3.4

  • Tested OK with WC 3.8 and WP 5.2.4
  • Content Update.
  • Improvement:- Option to select all and deselect all columns on export page.

1.3.3

  • Tested OK with WC 3.7.1 and WP 5.2.3
  • Biographical Info – reported by (@krsh333 and @wadehammes)

1.3.2

  • CSV Injection was fixed – reported by one of our user (Javier Olmedo) CVE-2019-15092

1.3.1

  • Tested OK with WC 3.7.0
  • Plugin update information hook added.

1.2.9

  • Tested OK with WC 3.6.3 and WP 5.2.1

1.2.8

  • Tested OK with WC 3.6.1

1.2.7

  • Bug Fix:- Encoding issue with export CSV.

1.2.6

  • Bug Fix:- Cannot insert user without e-mail.

1.2.5

  • Minor UI change.
  • Tested OK with WC 3.5.7
  • Tested OK with PHP 7.3.3

1.2.4

  • Bug Fix.

1.2.3

  • Tested OK with WP 5.1.1 and WC 3.5.6
  • Minor UI changes.

1.2.2

  • Tested OK with WP 5.0.3 and WC 3.5.3
  • Bug Fix: User cannot import without email.
  • Translation added German and French – Thanks for contributing French translation Jean(@momo-fr).

1.2.1

  • Tested OK with WP 5.0.2 and WC 3.5.1

1.2.0

  • Bug fix.

1.1.9

  • Tested OK with WC 3.5.1
  • Feedback on uninstall

1.1.8

  • Tested OK with WC 3.5.0

1.1.7

  • Content Update.

1.1.6

  • Bug fix.

1.1.5

  • Tested OK with WC 3.4.5.
  • Review link added on footer.

1.1.4

  • implement hashed/plaintext password processing during import.
  • Bug fix: User role import.

1.1.3

  • Export page blank bug fix.

1.1.2

  • Tested OK WC 3.4.4 and WP 4.9.8
  • Warnings fixed.
  • UI Changed.
  • Export multiple roles at a time.

1.1.1

  • Tested OK with WP 4.9.6 and WC 3.3.5.

1.1.0

  • Fixed WC Dependency issue, fixed notice.

1.0.9

  • Fixed WC Dependency issue.

1.0.8

  • Tested OK with WordPress 4.9

1.0.7

  • Minor Content updates

1.0.6

  • Fixed Conflict with Premium Version

1.0.5

  • Fixed PHP 7.0 Compatibility Issue and warning fix

1.0.4

  • Marketing Content Change.

1.0.3

  • Minor content updates.

1.0.2

  • Minor content updates.

1.0.1

  • Minor content updates.

1.0.0

  • Export Import WordPress Users.