My situation is I have an Individual database of 11,344 Contacts in Drupal Civi, and I want to turn them all into WP Users. I know I can convert Users into Contacts, but I want to do it the other way around. I have pointed my WordPress CiViCRM to a drupal Civi database which I need very much. I want the CiViCRM members to show under WordPress users but this isn't working. I have downloaded the plugin CiviCRM WordPress Profile Sync; but I can see the plugin on button on my dashboard to even try something. Can you please help me? I really need this issue solved. Thank you

  • Do the Contacts you want to make into WordPress Users have CiviCRM Memberships? Commented Feb 6, 2020 at 9:44

1 Answer 1


How i would do is

  1. Export contacts with email address that want to be user.
  2. Install Wordpress export/import user plugin.
  3. Change the un-supervised dedupe rule to have only email address
  4. Import users via Wordpress screen using exported csv from CiviCRM
  5. Switch back un-supervised dedupe rule



  • Thanks Everyone for your support. I finally used the CiviCRM WordPress Profile Sync; and it seemed to work 89%. My issue now is that I want to be able to build the old CiviCRM system by importing the data step by step so that I can have control over everything. The reason I want to do that is I was trying to create a new event and want to set the fees but the fee settings refuses to save. If the fee is not saved, registration isn't possible. The system has been there for a couple of years now.
    – user7645
    Commented Feb 7, 2020 at 10:47
  • Since mysql contact table is showing 17000 rows whilst contacts in CiviCRM is showing about 13000 contacts, I'm wondering which one to import.I'm planning on copying the mysql contat table of Drupal straight to my new Wordpress Civicrm database. Is that a good idea?
    – user7645
    Commented Feb 7, 2020 at 10:50
  • I would use CiviCRM UI to export contacts. The table might have contacts that are in trash try doing query with is_deleted = 0 on contact table Commented Feb 7, 2020 at 11:42
  • should I do that in civi or Mysql?
    – user7645
    Commented Feb 7, 2020 at 12:16
  • CIvi UI i will suggest Commented Feb 7, 2020 at 12:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.