Import 10,000 Users into WordPress WITH a specific ID for each user

by

I have a website which has about 10,000 users. I am converting this site over to WordPress. The new site is ready to roll, but I have to bring over all the users.

There are a number of plugins available to importing users from a CSV file, and I’ve got the CSV file ready to go. The plugin that I’d like to use is the following:

Import Users from CSV

The reason I’d like to use this plugin is that it provides the option to import a CSV file containing user id’s. Unfortunately, the plugin is currently designed so that if ID’s are present in the CSV file, it assumes that these users already exist in your WordPress database and you’re trying to “UPDATE” those records.

I’m not. I’m trying to make NEW users in the database, but with specific ID’s (because these ID’s are tied to another system and I don’t want these losers to lose access to all of this other info as a result of an ID change from the old system to the new.

It seems that the plugin above maybe be piggy-backing off of the built-in WordPress functions for registering or updating users, so this may be the problem.

How can I accomplish my goal with as little time investment as possible?

BTW – I am pretty comfortable in phpmyadmin, so I don’t mind doing it there, the only problem is I want to make sure that all users receive an email notifying them and providing their new password (because I can’t move these over). Using the plugin, this is automatic. Without it, not to much.

Thanks for any assistance.

3 Answers
3

I’m not familiar with the plugin, but this might be an option to work around it:

  1. Import the ids into the database directly using SQL (phpMyAdmin).
  2. Use the plugin to import the CSV and run the “update” on those now-existing users, so they receive their updated password email.

Leave a Comment