Import Export WordPress Users and WooCommerce Customers

Description

Introduction

WordPress User Import Export plugin allows you to import and export WordPress users and WooCommerce customers quickly and easily. User Export and User import are much required feature while moving WordPress / WooCommerce websites.

🔸 Users Export – Export Users to CSV file.
🔸 Users import – Import Users from CSV format to WordPress/WooCommerce Store.
🔸 Customer Export – Export WooCommerce customers to CSV
🔸 Customer Import – Import WooCommerce customers from CSV
🔸 Batch Export/Import
🔸 Export/Import based on user roles
🔸 Export filters
🔸 Retain user passwords (optional)
🔸 Map and Transform fields while importing customers/users
🔸 Change values (bulk modify) while importing customers/users using Evaluation Fields
🔸 Tested OK with WordPress 5.7
🔸 Tested OK with WooCommerce 5.2.2
🔸 Tested OK with PHP 7.3.5

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 a particular user fields , otherwise Admin need 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, LibreOffice 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 spreadsheet, you can bulk import users to your online Site/Store. 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.
✅ 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 Out of the Box.
✅ 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

Tags: CSV import, CSV export, customer import, customer export, user import, user export, WooCommerce, WordPress.

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 – WordPress Export Users to CSV.
✅ User Import – WordPress Import 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 export plugin, you can export WordPress users from 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 WordPress import users 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 CSV file with multiple powerful filters such as User Roles, date ranges, etc. Even the plugin automatically upload 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 CSV importer plugin. Use WordPress import users feature or merge users (update existing users) hundreds, even 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 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 to your website.

WooCommerce Export Customers to CSV (Premium)

You can export 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.

Plugin can easily export customers details to CSV file by filtering customers by user role. Even the plugin automatically upload your exports via FTP.

WooCommerce Import Customers from CSV (Premium)

You can import WooCommerce customers to WordPress/WooCommerce site 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 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 to your website.

Import/Export/Migration Plugins for WooCommerce from WebToffee

🔸 WebToffee Product Feed for Facebook: This plugin allows you to sync your WooCommerce Products to your Facebook Business Manager account.
🔸 WooCommerce Product Import Export Plugin: Easily import and export products to/from your WooCommerce store using a CSV file.
🔸 Product Review Import Export for WooCommerce: Import and Export product reviews quickly using a CSV file to and from your WooCommerce store.
🔸 WooCommerce Order/Coupon/Subscription Import Export: The plugin lets you export and import orders and coupons via CSV to and from your WooCommerce store.
🔸 Order XML File Export Import for WooCommerce: Import and export your WooCommerce orders in XML format supported by Stamps.com, UPS WorldShip, Endicia, and FedEx.
🔸 XML File Export Import for Stamps.com and WooCommerce: The plugin lets you easily export and import orders in your store via XML compatible to Stamps.com.
🔸 WordPress Comments Import & Export: Easily import and export WordPress comments using this comment import export plugin.

About WebToffee.com

WebToffee creates quality WordPress/WooCommerce plugins that are easy to use and customize. We are proud to have thousands 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. Thats 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 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 password, so users can use same old password in 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 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 an import, if the ‘If the user exists in the store’ field in the Advanced options is set to ‘Update’.

Reviews

May 10, 2021
I tried another one first, spent 30 min trying to make it work. Gave up and installed this one. It worked instantly, first try, even using the CSV from the other plug-in.
May 2, 2021
Because of this plugin, the migration of user information was done well.
April 21, 2021
This doesn't seem to keep user ids which I think are needed when your next step is to import a bunch of posts that you want linked up with the users.
Read all 214 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.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.