| 1 |
=== Import Users & Customers with Meta | WP Ultimate CSV Importer Add-on === |
| 2 |
Contributors: smackcoders, premairuthayarajan |
| 3 |
Donate link: https://www.paypal.me/smackcoders |
| 4 |
Requires at least: 5.0 |
| 5 |
Tested up to: 7.0 |
| 6 |
Stable tag: 2.1 |
| 7 |
Version: 2.1 |
| 8 |
Requires PHP: 7.4 |
| 9 |
Author: smackcoders |
| 10 |
Author URI: https://www.smackcoders.com/wp-ultimate-csv-importer-pro.html |
| 11 |
Tags: import users, user import, import users from csv, wordpress user import, user meta import, import user meta wordpress, woocommerce customer import, user import with meta, wordpress user csv import, user export, memberpress import, buddypress import, membership import |
| 12 |
License: GPLv2 or later |
| 13 |
|
| 14 |
Import export WordPress users and WooCommerce customers with user meta, custom fields, billing & shipping details, and membership data. |
| 15 |
|
| 16 |
== Description == |
| 17 |
|
| 18 |
Migrating users to a new WordPress site, onboarding a customer database into WooCommerce, or managing members across a membership platform — all of it requires moving user data at scale, accurately and without duplicates. The **Import Users & Customers with Meta Add-on** makes this straightforward. |
| 19 |
|
| 20 |
This add-on extends [WP Ultimate CSV Importer](https://wordpress.org/plugins/wp-ultimate-csv-importer/) — the free parent plugin to support bulk WordPress user import and WooCommerce customer import from CSV, XML, Excel, TSV, and Google Sheets files. It handles standard WordPress user fields, user meta, WooCommerce billing and shipping details, and profile data from popular membership plugins including **WP-Members**, **MemberPress**, **BuddyPress**, and the **Listeo** theme. |
| 21 |
|
| 22 |
It also includes a full user export system, so you can export WordPress users and WooCommerce customers to CSV, XML, XLS, XLSX, JSON, or TSV. |
| 23 |
|
| 24 |
[youtube https://www.youtube.com/watch?v=pK2lKrNEnkQ&feature=youtu.be] |
| 25 |
|
| 26 |
**This add-on requires the free [WP Ultimate CSV Importer](https://wordpress.org/plugins/wp-ultimate-csv-importer/) plugin.** It is part of a complete data management ecosystem for WordPress and WooCommerce: |
| 27 |
|
| 28 |
* **[WP Ultimate CSV Importer](https://wordpress.org/plugins/wp-ultimate-csv-importer/)** (Free, required) — Import posts, pages, custom post types, and more. |
| 29 |
* **Import Users & Customers with Meta** (This plugin) — Bulk import and export WordPress users and WooCommerce customers with full meta support. |
| 30 |
* **[Import WooCommerce Suite](https://wordpress.org/plugins/import-woocommerce/)** — Import WooCommerce products, orders, coupons, and reviews. |
| 31 |
* **[WP Ultimate Exporter](https://wordpress.org/plugins/wp-ultimate-exporter)** — Export any WordPress or WooCommerce data to CSV, XML, or other formats. |
| 32 |
|
| 33 |
Install just what you need, or use all four together for a complete import/export solution. |
| 34 |
|
| 35 |
== Key Features == |
| 36 |
|
| 37 |
**Flexible Import Sources** |
| 38 |
You can import user data from: |
| 39 |
- Your desktop |
| 40 |
- FTP/SFTP servers |
| 41 |
- External URLs (Google Sheet / Dropbox) |
| 42 |
|
| 43 |
**Supports Multiple File Formats** |
| 44 |
Import from a wide range of file formats including: |
| 45 |
- CSV |
| 46 |
- XML |
| 47 |
- Excel (XLS/XLSX) |
| 48 |
- TSV |
| 49 |
- Google Sheets |
| 50 |
- ZIP files containing structured data |
| 51 |
|
| 52 |
**Import WordPress Users and WooCommerce Customers** |
| 53 |
Bring in new users with: |
| 54 |
- Standard WordPress fields |
| 55 |
- User meta |
| 56 |
- WooCommerce billing and shipping information |
| 57 |
- Additional customer details like phone, address, notes, and more |
| 58 |
|
| 59 |
**Membership Plugin Compatibility** |
| 60 |
Seamlessly import profile data for: |
| 61 |
- WP-Members |
| 62 |
- MemberPress |
| 63 |
- BuddyPress |
| 64 |
|
| 65 |
**Automatic Password Handling** |
| 66 |
If your CSV (or other import file) doesn't include a password, the plugin generates a secure one and automatically emails it to the user. |
| 67 |
|
| 68 |
**Smart Field Mapping** |
| 69 |
Use an intuitive drag-and-drop interface or dropdown suggestions to map all your fields correctly. If your file headers and WordPress field headers are same, the plugin will automatically maps them. This makes large and complex imports easier and faster. |
| 70 |
|
| 71 |
**Conditional Filters for Imports** |
| 72 |
Apply filters to import only the specific users you want based on conditions like role, status, or any metadata, helping you maintain clean and organized data imports. |
| 73 |
|
| 74 |
**Duplicate Handling** |
| 75 |
Prevent duplicate user creation by validating user email. |
| 76 |
|
| 77 |
Use update mode to modify existing users instead of creating new ones. (Pro feature) |
| 78 |
|
| 79 |
**Iteration-Based Import** |
| 80 |
Large files are split into smaller manageable chunks (iterations), ensuring that high-volume imports run smoothly without server timeouts. |
| 81 |
|
| 82 |
**Monitor Import Progress** |
| 83 |
Track import status in real time, view logs, and quickly resolve any issues. Errors are highlighted clearly for easy debugging. |
| 84 |
|
| 85 |
|
| 86 |
== Export Capabilities == |
| 87 |
|
| 88 |
The add-on is not only for importing, it also provides a full user export system. |
| 89 |
|
| 90 |
**Export Users and WooCommerce Customers** |
| 91 |
Export: |
| 92 |
- WordPress users |
| 93 |
- WooCommerce customers |
| 94 |
- All their meta fields |
| 95 |
|
| 96 |
**Multiple Export Formats** |
| 97 |
Export your user data into file formats like: |
| 98 |
- CSV |
| 99 |
- XML |
| 100 |
- XLS |
| 101 |
- XLSX |
| 102 |
- JSON |
| 103 |
- TSV |
| 104 |
|
| 105 |
**Iteration Export and Date-Based Export** |
| 106 |
Export users in batches or export only users created during a specific time period. |
| 107 |
|
| 108 |
**Preview Before Export** |
| 109 |
Review your user data before downloading to ensure accuracy. |
| 110 |
|
| 111 |
**One-Click User Migration** |
| 112 |
Move users between sites seamlessly with the one-click import & migrate feature. |
| 113 |
|
| 114 |
|
| 115 |
== Use Cases == |
| 116 |
|
| 117 |
* **Migrate users from another WordPress site** — Export users from your old site and bulk import them into your new one, including all meta fields and roles. |
| 118 |
* **Import WooCommerce customers** — Bring in a customer database with billing addresses, shipping addresses, phone numbers, and notes in one import run. |
| 119 |
* **Onboard members from a spreadsheet** — Import a list of new members into WP-Members, MemberPress, or BuddyPress from a CSV or Excel file. |
| 120 |
* **Sync users from an external system** — Import user data from a CRM, LMS, or HR system exported as CSV or Google Sheets. |
| 121 |
* **Import users after a platform switch** — Moving from Shopify, Magento, or another CMS? Import your customer list directly into WooCommerce. |
| 122 |
* **Bulk update user roles or meta** — Use update mode (PRO) to change roles, update profile fields, or assign membership levels across hundreds of users at once. |
| 123 |
* **Migrate membership site data** — Import MemberPress or WP-Members subscriber data including subscription levels and profile fields. |
| 124 |
* **Export users for backup or audit** — Export your full WordPress user database or WooCommerce customer list to CSV, Excel, or JSON at any time. |
| 125 |
|
| 126 |
== How It Works == |
| 127 |
|
| 128 |
1. Install WP Ultimate CSV Importer (Free). |
| 129 |
2. Install and activate this add-on. |
| 130 |
3. Upload your source file or choose an external source. |
| 131 |
4. Map fields using the drag-and-drop UI or dropdown mode. |
| 132 |
5. Apply filters if required. |
| 133 |
6. Run the import and track progress live. |
| 134 |
|
| 135 |
|
| 136 |
== How to Import Users == |
| 137 |
|
| 138 |
**1. Prepare Your File** |
| 139 |
Create a CSV, Excel, XML, TSV, or Google Sheet containing user fields such as username, email, user meta, and WooCommerce billing/shipping data. |
| 140 |
|
| 141 |
**2. Go to Import Screen** |
| 142 |
Navigate to Ultimate CSV Importer Free → Import/Update page. |
| 143 |
|
| 144 |
**3. Choose File Source** |
| 145 |
Upload your file from desktop, FTP/SFTP, or external URL. Only fresh import is allowed. For update, you require pro version. |
| 146 |
|
| 147 |
**4. Map Fields** |
| 148 |
Match your file columns to WordPress Users fields using drag-and-drop or dropdown mapping mode. |
| 149 |
|
| 150 |
**5. Apply Filters (Optional)** |
| 151 |
Apply conditional filters to import only users matching specific roles, dates, or others. |
| 152 |
|
| 153 |
**6. Run Import** |
| 154 |
Click Import to instantly run it. You can configure iterations and other settings before proceeding the import. The plugin can processes large files. It shows progress, errors, and completed entries after import. |
| 155 |
|
| 156 |
== How to Export Users == |
| 157 |
|
| 158 |
**1. Visit Export Screen** |
| 159 |
Go to WP Ultimate CSV Importer → Export. |
| 160 |
|
| 161 |
**2. Choose What to Export** |
| 162 |
Select Users or WooCommerce Customers from the modules list. |
| 163 |
|
| 164 |
**3. Select Export Format** |
| 165 |
Provide a file name and select export file formats like CSV, XML, XLS, XLSX, TSV, or JSON. |
| 166 |
|
| 167 |
**4. Preview (Optional)** |
| 168 |
Click Preview button to review selected users and fields before exporting. |
| 169 |
|
| 170 |
**5. Download Export File** |
| 171 |
Click Export and the export file will be prepared. Then click Download to save the file to your device. |
| 172 |
|
| 173 |
|
| 174 |
== WP Ultimate CSV Importer Pro Features == |
| 175 |
|
| 176 |
WP Ultimate CSV Importer offers many advanced features in its pro version. Here are some listed below: |
| 177 |
|
| 178 |
**Update Existing Users** |
| 179 |
Modify existing WordPress users and WooCommerce customers without creating duplicates. Update roles, profile data, and meta fields while keeping user IDs intact. |
| 180 |
|
| 181 |
**Scheduled Imports** |
| 182 |
Run cron-based automatic schedule import from FTP/SFTP, and Google Sheets. Useful for sites that receive user data on a regular basis from external systems. |
| 183 |
|
| 184 |
**Mapping Templates** |
| 185 |
Save your field mapping once and reuse it for future imports, making repeated or scheduled tasks easier to manage. |
| 186 |
|
| 187 |
**Import and Export All WordPress Data** |
| 188 |
Pro supports full-site data handling, including posts, products, orders, taxonomies, custom fields, comments, and SEO fields, enabling complete migrations. |
| 189 |
|
| 190 |
**Advanced Export Options** |
| 191 |
Export users and other WordPress data with filters, date ranges, selected fields, user roles, or in iteration mode for large datasets, and much more. |
| 192 |
|
| 193 |
**One-Click Rollback** |
| 194 |
Revert an import instantly if needed, helping maintain clean and reliable user data. |
| 195 |
|
| 196 |
Visit [WP Ultimate CSV Importer Pro plugin here](https://www.smackcoders.com/wp-ultimate-csv-importer-pro.html?utmsource=web&utmcampaign=readme&utmmedium=wporg) |
| 197 |
|
| 198 |
|
| 199 |
= Other Useful Plugins & Addons By Smackcoders = |
| 200 |
|
| 201 |
The Leads Builder for WordPress to capture your webforms as leads to one of the top ranking open source CRM, install the [WordPress Lead Form Data Collection to CRM](https://wordpress.org/plugins/wp-leads-builder-any-crm/) Plugin. Install one of the CRM of your choice with the additional add-ons listed below and keep both parent plugin and CRM addon activated. |
| 202 |
* [Zoho CRM & Zoho CRM Plus](https://wordpress.org/plugins/wp-zoho-crm/) |
| 203 |
* [Salesforce](https://wordpress.org/plugins/wp-salesforce/) |
| 204 |
* [SugarCRM](https://wordpress.org/plugins/wp-sugar-free/) |
| 205 |
* [Freshsales](https://wordpress.org/plugins/wp-freshsales/) |
| 206 |
* [Vtiger CRM](https://wordpress.org/plugins/wp-tiger/) |
| 207 |
|
| 208 |
To know more about the premium bundled version, visit [WordPress Lead Form Data Collection to CRM with unlimited features](https://www.smackcoders.com/wp-leads-builder-any-crm-pro.html) |
| 209 |
|
| 210 |
|
| 211 |
= Helpful links = |
| 212 |
|
| 213 |
Visit [Smackcoders](https://www.smackcoders.com/wordpress.html) to explore more WordPress products. You can write to us your comments, feedback at [[email protected]](mailto:[email protected]). |
| 214 |
|
| 215 |
Get to know about other WordPress addons and latest product update news at [www.smackcoders.com/blogs.html](https://www.smackcoders.com/blog/category/wordpress-products). |
| 216 |
|
| 217 |
|
| 218 |
== Screenshots == |
| 219 |
|
| 220 |
1. Import file upload screen |
| 221 |
2. Drag-and-drop mapping interface |
| 222 |
3. WooCommerce customer field mapping |
| 223 |
4. Import progress view |
| 224 |
5. Users module selection to export |
| 225 |
6. Configure Advanced export settings |
| 226 |
7. Export completed page |
| 227 |
|
| 228 |
|
| 229 |
== Installation == |
| 230 |
|
| 231 |
1. First, install [CSV Importer & Exporter](https://wordpress.org/plugins/wp-ultimate-csv-importer/). |
| 232 |
2. Extract the Import-Users.zip in wordpress/wp-content/plugins using FTP or through plugin install in wp-admin. |
| 233 |
3. Activate the plugin in the WordPress plugin list. |
| 234 |
4. Install Import WooCommerce add-on to import WooCommerce customers. |
| 235 |
|
| 236 |
|
| 237 |
== Frequently Asked Questions == |
| 238 |
|
| 239 |
= Do I need WP Ultimate CSV Importer installed? = |
| 240 |
Yes. This add-on works only with the free parent plugin [WP Ultimate CSV Importer](https://wordpress.org/plugins/wp-ultimate-csv-importer/). Install and activate it first. |
| 241 |
|
| 242 |
= How do I bulk import WordPress users from CSV? = |
| 243 |
Prepare a CSV file with your user fields (username, email, role, user meta, etc.), then go to Ultimate CSV Importer → Import. Upload your file, select "Users" as the post type, map your columns to the corresponding WordPress user fields using the drag-and-drop interface, and click Import. The plugin processes large files in iterations to prevent server timeouts. |
| 244 |
|
| 245 |
= Can I import WooCommerce customers with billing and shipping details? = |
| 246 |
Yes. All WooCommerce customer fields are supported, including billing name, billing address, billing city, billing country, shipping address, phone number, and customer notes. Map these fields in the import screen and they will be populated on the WooCommerce customer profile. |
| 247 |
|
| 248 |
= Can I import WordPress user meta fields? = |
| 249 |
Yes. Standard WordPress user meta fields are supported. For custom meta fields created with third-party plugins, the PRO version of WP Ultimate CSV Importer supports extended custom field compatibility. |
| 250 |
|
| 251 |
= Can I import users from Google Sheets? = |
| 252 |
Yes. Paste your publicly accessible Google Sheet URL into the external URL field in the import screen. Make sure the sheet is set to "Anyone with the link can view" before running the import. |
| 253 |
|
| 254 |
= Is it possible to update existing users without creating duplicates? = |
| 255 |
Update mode (modifying existing users by email without creating duplicates) requires the [WP Ultimate CSV Importer Pro plugin](https://www.smackcoders.com/wp-ultimate-csv-importer-pro.html). The free add-on supports fresh imports with duplicate detection by email. |
| 256 |
|
| 257 |
= Can I import MemberPress or WP-Members data? = |
| 258 |
Yes. The add-on supports importing profile data for both MemberPress and WP-Members users, including membership levels and custom profile fields. |
| 259 |
|
| 260 |
= Can I import BuddyPress profile fields? = |
| 261 |
Yes. BuddyPress extended profile fields are supported from version 1.4 onwards. |
| 262 |
|
| 263 |
= What file formats are supported? = |
| 264 |
CSV, XML, Excel (XLS/XLSX), TSV, Google Sheets, and ZIP files containing structured data are all supported for both import and export. |
| 265 |
|
| 266 |
|
| 267 |
== Changelog == |
| 268 |
|
| 269 |
= 2.1 = |
| 270 |
* Fixed: User and BuddyPress media imports reject files with executable extensions (e.g. .php, .phtml). |
| 271 |
* Fixed: BuddyPress file fields store a sanitized file name and only accept known file types. |
| 272 |
|
| 273 |
= 2.0 = |
| 274 |
* Improved: Aligned with WP Ultimate CSV Importer 9.0. |
| 275 |
* Fixed: An SQL injection vulnerability and hardened database queries across user import and export operations. |
| 276 |
|
| 277 |
= 1.7.1 = |
| 278 |
* Added PHP 8.3 compatibility support |
| 279 |
* Fixed minor bugs and stability issues |
| 280 |
|
| 281 |
= 1.7 = |
| 282 |
* Added: compatibility for WordPress 7.0 |
| 283 |
|
| 284 |
= 1.6 = |
| 285 |
* Added: Compatibility with WordPress 6.9. |
| 286 |
* Added: Support for the Listeo theme, including import of profile meta fields such as phone, address, social links, and more. |
| 287 |
|
| 288 |
= 1.5 = |
| 289 |
* Added: Support for MemberPress Users data import/export. |
| 290 |
|
| 291 |
= 1.4.3 = |
| 292 |
* Resolved: Issue with PHP Notice error occurring when installing import-users plugin has been fixed. |
| 293 |
* Resolved: Fixed PHP Notice for Undefined index: user_pass iss |
| 294 |
|
| 295 |
= 1.4.2 = |
| 296 |
* Checked: Compatibility for WordPress 6.4.1 |
| 297 |
|
| 298 |
= 1.4.1 = |
| 299 |
* Checked: Compatibility for WordPress 6.3.1 |
| 300 |
|
| 301 |
= 1.4 = |
| 302 |
* Checked: Compatibility for WordPress 6.2 |
| 303 |
* Added: BuddyPress Profile Fields Import |
| 304 |
|
| 305 |
= 1.3 = |
| 306 |
* Checked: Compatibility for WordPress 6.0 |
| 307 |
|
| 308 |
= 1.2.9 = |
| 309 |
* Checked: Compatibility for WordPress 5.9 |
| 310 |
|
| 311 |
= 1.2.8 = |
| 312 |
* Fixed: Plugin activation conflict - file missing issue |
| 313 |
|
| 314 |
= 1.2.7 = |
| 315 |
* Checked: Compatibility for WordPress 5.8 |
| 316 |
|
| 317 |
= 1.2.6 = |
| 318 |
* Added: WordPress 5.6 compatibility |
| 319 |
* Added: PHP 8 compatibility |
| 320 |
|
| 321 |
= 1.2.5 = |
| 322 |
* Fixed: User password import issue. |
| 323 |
|
| 324 |
= 1.2.4 = |
| 325 |
* Checked: Compatibility for WordPress 5.5.1 |
| 326 |
* Fixed: Updated existing user password based on email while import. |
| 327 |
|
| 328 |
= 1.2.3 = |
| 329 |
* Checked: Compatibility for WordPress 5.3.2 |
| 330 |
|
| 331 |
= 1.2.2 = |
| 332 |
* Fixed: Minor issues and warnings |
| 333 |
|
| 334 |
= 1.2.1 = |
| 335 |
* Added: new api call to find plugin installed or not |
| 336 |
* Fixed: Minor issues and notice/alert for plugin not installed. |
| 337 |
|
| 338 |
= 1.2 = |
| 339 |
* Fixed: wp-members image field import issue |
| 340 |
* Added: Improved user interface and performance. |
| 341 |
* Added: Check mandatory field in mapping section |
| 342 |
|
| 343 |
= 1.1 = |
| 344 |
* Added: addon support |
| 345 |
* Fixed: send password through email |
| 346 |
|
| 347 |
= 1.0 = |
| 348 |
* Initial stable release version. |
| 349 |
|
| 350 |
== Upgrade Notice == |
| 351 |
|
| 352 |
= 2.1 = |
| 353 |
Security update for media imports. Update alongside WP Ultimate CSV Importer 9.2. Recommended for all users. |
| 354 |
|
| 355 |
= 2.0 = |
| 356 |
Aligned with WP Ultimate CSV Importer 9.0. Update the core plugin to get the redesigned interface, Pre-Flight Validation, and Auto Recovery for user imports. |
| 357 |
|
