Import and export users and customers

This is caused by the option that forces the users to reset their password. When it is used, each of those users is redirected to their password page on every page load until they change it, and if that destination cannot be reached (for example, because wp-admin is blocked for customers or subscribers by WooCommerce, by a membership plugin or by a security plugin) the browser ends up in a redirection loop.

Since version 2.4.12 the plugin detects this situation and gives up after 3 consecutive redirects, so the site stays usable, but you can also clear the flag for the users that are already affected: go to the plugin documentation tab and use the button that removes the force reset password metadata from all the users.

If you want to change how many redirects are allowed before the plugin gives up, use the acui_force_reset_password_max_redirects filter (return 0 to disable the limit):

add_filter( 'acui_force_reset_password_max_redirects', function( $max ){ return 5; } );

By default they are sent to their WordPress profile page. If WooCommerce or WP User Manager are active, they are sent to the password section of the account page of those plugins instead. You can point them anywhere else using the acui_force_reset_password_edit_profile_url filter, and you can add your own exceptions (pages where the redirection must not happen) using acui_force_reset_password_redirect_condition .= Can I import users from an Excel or LibreOffice file? =

The plugin natively supports CSV files. If you need to import directly from Excel (XLSX, XLS) or LibreOffice (ODS) files without converting them first, the File Formats Addon adds support for those formats.

You should fill the first two columns with the next values: Username, Email.

The next columns are totally customizable and you can use whatever you want. All rows must contains same columns. User profile will be adapted to the kind of data you have selected. If you want to disable the extra profile information, please deactivate this plugin after make the import.

You can use a column called id in order to make inserts or updates of an user using the ID used by WordPress in the wp_users table. We have two different cases:

• If id doesn’t exist in your users table: WordPress core does not allow us insert it, so it will throw an error of kind: invalid_user_id
• If id exists: plugin check if username is the same, if yes, it will update the data, if not, it ignores the cell to avoid problems

We can use a column called “Password” to manage a string that contains user passwords. We have different options for this case:

• If you don’t create a column for passwords: passwords will be generated automatically
• If you create a column for passwords: if cell is empty, password won’t be updated; if cell has a value, it will be used

Plugin can import serialized data. You have to use the serialized string directly in the CSV cell in order the plugin will be able to understand it as an serialized data instead as any other string.

Plugin can import lists as an array. Use this separator: :: two colons, inside the cell in order to split the string in a list of items.

You can use those labels if you want to set data adapted to the WordPress default user columns (the ones who use the function wp_update_user)

• user_nicename: A string that contains a URL-friendly name for the user. The default is the user’s username.
• user_url: A string containing the user’s URL for the user’s web site.
• display_name: A string that will be shown on the site. Defaults to user’s username. It is likely that you will want to change this, for both appearance and security through * obscurity (that is if you don’t use and delete the default admin user).
• nickname: The user’s nickname, defaults to the user’s username.
• first_name: The user’s first name.
• last_name: The user’s last name.
• description: A string containing content about the user.
• jabber: User’s Jabber account.
• aim: User’s AOL IM account.
• yim: User’s Yahoo IM account.
• user_registered: Using the WordPress format for this kind of data Y-m-d H:i:s.

You can upload as many files as you want, but all must have the same columns. If you upload another file, the columns will change to the form of last file uploaded.

You can export a file with all your users data using “Export” tab. There you will be able to find some filters and options to prepare your export.

If you want to extend this plugin or use this plugin with any other, here you have a list with all hooks available in the plugin .

Thanks, donations help us to continue improving our plugins and allow us to give the best support in the forums Donate Here via PayPal.

Of course! In Codection we help you to import, migrate, synchronized, update or any other operation you will need to do with your users. Contact us at contacto@codection.com for more information.

You can get:

• Free support in WordPress forums
• Premium support writing directly to contacto@codection.com .

Write us directly to contacto@codection.com .

Yes. Export users from your old site using the Export tab, then import the resulting CSV into your new site. Hashed passwords can be transferred using the user_pass column so users keep their existing passwords without needing to reset them.

Yes. Add WooCommerce billing and shipping fields as columns in your CSV (e.g. billing_first_name, billing_email, shipping_address_1) and the plugin will populate them automatically when importing users with the customer role.

Yes. The plugin has addons for Advanced Custom Fields, BuddyPress/BuddyBoss, Paid Membership Pro, WooCommerce Memberships, WooCommerce Subscriptions and many others. Custom meta fields not covered by an addon can still be imported by using the meta key as the column header.

By default WordPress requires an email for every user. If you need to import users without one, the Allow No Email Addon removes that requirement.

Yes. The plugin checks for existing users by username and email before inserting. If a match is found the user is updated instead of created. You can also control whether passwords and roles are overwritten on update.

Scheduled exports are available via the Recurring Export Addon . It lets you configure periodic CSV exports of your users or WooCommerce customers and send them to a file path or remote destination automatically.

Yes. The Recurring Import tab lets you configure a periodic import from a file path or URL. The plugin will fetch and process the CSV automatically at the chosen interval (hourly, daily, weekly, etc.) without any manual action.

The import runs as the user selected in “User that runs the cron”, so it can only do what that user is allowed to do. If the settings are saved by a user who cannot edit other users ( edit_users ), for example a role that has only been given create_users to import users, the import always runs as that same user, whoever starts it, and the selector only offers their own account.

The free version supports one recurring import task. If you need multiple simultaneous scheduled imports — each with its own file, interval, role and settings — the Recurring Import Addon removes that limitation.

Yes. Point the recurring import at a URL that your external system generates and the plugin will pull and process it on every scheduled run, keeping your WordPress users in sync automatically.

You can report security bugs through the Patchstack Vulnerability Disclosure Program. The Patchstack team help validate, triage and handle any security vulnerabilities. Report a security vulnerability.