Answers.Body: <blockquote>
  <p>how do I deal with the leftover user IDs attached to contact records?</p>
  </blockquote>
  <p>Clear your <code>civicrm_uf_match</code> table except for your own record - i.e. the one that has your User ID and Contact ID. You'll then need to decide how and why you want to create Users from your Contacts...</p>
  <ol>
  <li>Do they have memberships in CiviCRM?</li>
  <li>Do they need to login for some reason?</li>
  </ol>
  <p>Depending on the answer above, you have a couple of options:</p>
  <ul>
  <li>For membership-based Users, use CiviCRM Member Sync. You can then create your Users from the plugin's &quot;Manual Sync&quot; admin screen.</li>
  <li>For login-based Users, you can create Users one-by-one with CiviCRM's built-in &quot;Create User Record&quot; option in the Actions menu on the Contact View screen. Or you can use CiviCRM Profile Sync which has a &quot;Create Users from Contacts&quot; Bulk Action in CiviCRM that you can enable by adding <code>define( 'CIVICRM_WP_PROFILE_SYNC_BULK', true );</code> to your <code>wp-config.php</code> file.</li>
  </ul>
  <blockquote>
  <p>Wordpress groups</p>
  </blockquote>
  <p>WordPress doesn't have groups out of the box, so you need to decide which plugin you want to use to provide them.</p>
  <p>BuddyPress can provide them if you're after social media style discussion groups and that's what BP Groups CiviCRM Sync is for - it works in a similar fashion to the Drupal OG Groups Sync module.</p>
  <p>The &quot;Groups&quot; plugin can also provide them and that's what CiviCRM Groups Sync is for - these groups are permissions-based groups and don't do anything in and of themselves but can be used to grant (or revoke) access to content.</p>
  <p>Your choice of group type depends on your use case.</p>
  <p>Hope that helps get you started.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-11-24T23:54:43.017Z
Answers.Text: Excellent, thanks - so to clarify, since I'm not using Memberships or BuddyPress, I should create WP users using CiviCRM Profile Sync, and then keep them up to date using CiviCRM Groups Sync?  I'm still a little confused how those two relate to each other.
Answers.UserDisplayName: Ken Williams
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-11-25T12:43:58.567Z
Answers.Text: Depends on your use case Ken :-) Why do you need Contacts to have Users?
Answers.UserDisplayName: Christian Wach
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-11-27T16:25:23.970Z
Answers.Text: A set of about 70 people (within our CRM of about 3000 people) need to be able to log in to see privileged content.  We're a choir, these are the choir members - they need to see names & numbers of other singers, as well as logistical stuff & things that aren't public for copyright reasons.
Answers.UserDisplayName: Ken Williams
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-11-28T11:22:33.000Z
Answers.Text: @KenWilliams I'd assign them a free membership (since they are choir "members") and then use CiviCRM Member Sync to create WordPress Users. The sync can be set up such that they get assigned to groups provided by the Groups plugin for capabilities required to view restricted content.
Answers.UserDisplayName: Christian Wach
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-12-04T04:16:15.463Z
Answers.Text: I've had a chance to play around with this, and I think CiviCRM memberships aren't a good fit.  There's a lot of assumed workflow around memberships that doesn't fit.  Is it not possible to get a similar syncing behavior with CiviCRM groups, then?
Answers.UserDisplayName: Ken Williams
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-12-04T09:43:32.413Z
Answers.Text: What do you mean by "assumed workflow"?
Answers.UserDisplayName: Christian Wach
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-11-23T11:00:15.143Z
Answers.LastActivityDate: 2023-11-23T11:00:15.143Z
Answers.UserDisplayName: Christian Wach
Body: <p>I'm migrating my site from Drupal to WordPress, and could use some advice about how to handle syncing between CiviCRM groups (not members) and WordPress groups.</p>
  <p>I guess the first question is: how do I deal with the leftover user IDs attached to contact records?  There are a few hundred contacts that show a user ID, but those user IDs don't exist in WordPress (I'm currently the only actual user on the site):</p>
  <img src="https://i.sstatic.net/HHxMf.png" width="600">
  <p>Can I simply run a SQL query to delete all the user ID values?  If so, where are they located?  I haven't found them yet.</p>
  <p>Once I've cleaned that up, I need to choose a method for syncing groups between WordPress and CCRM. It looks like <a href="https://civicrm.org/blog/danaskallman/civicrm-groups-sync-plugin-for-wordpress" rel="nofollow noreferrer">CiviCRM Groups Sync</a> is the right choice for that, am I correct?</p>
  <p>I've been getting a little confused between <a href="https://wordpress.org/plugins/civicrm-wp-profile-sync/" rel="nofollow noreferrer">CiviCRM WP Profile Sync</a>, CiviCRM WP Member Sync, BP Groups CiviCRM Sync, and CiviCRM Groups Sync.  I installed CiviCRM WP Profile Sync first, because it was easy to find and install, but I guess that only deals with <strong>Members</strong> in CiviCRM land?</p>
  
Tags: <wordpress><groups><sync>
Title: WordPress group sync - after migrating from Drupal
ThreadText: # WordPress group sync - after migrating from Drupal
  
  (Asked by: username_0 on 2023-11-23)
  
  I'm migrating my site from Drupal to WordPress, and could use some advice about how to handle syncing between CiviCRM groups (not members) and WordPress groups.
  
  I guess the first question is: how do I deal with the leftover user IDs attached to contact records? There are a few hundred contacts that show a user ID, but those user IDs don't exist in WordPress (I'm currently the only actual user on the site):
  
  ![](https://i.sstatic.net/HHxMf.png)
  
  Can I simply run a SQL query to delete all the user ID values? If so, where are they located? I haven't found them yet.
  
  Once I've cleaned that up, I need to choose a method for syncing groups between WordPress and CCRM. It looks like [CiviCRM Groups Sync](https://civicrm.org/blog/danaskallman/civicrm-groups-sync-plugin-for-wordpress) is the right choice for that, am I correct?
  
  I've been getting a little confused between [CiviCRM WP Profile Sync](https://wordpress.org/plugins/civicrm-wp-profile-sync/), CiviCRM WP Member Sync, BP Groups CiviCRM Sync, and CiviCRM Groups Sync. I installed CiviCRM WP Profile Sync first, because it was easy to find and install, but I guess that only deals with **Members** in CiviCRM land?
  
  **Tags:** wordpress, groups, sync
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2023-11-23. Score: 5 | Accepted answer
  
  > how do I deal with the leftover user IDs attached to contact records?
  
  Clear your `civicrm_uf_match` table except for your own record - i.e. the one that has your User ID and Contact ID. You'll then need to decide how and why you want to create Users from your Contacts...
  
  1. Do they have memberships in CiviCRM?
  2. Do they need to login for some reason?
  
  Depending on the answer above, you have a couple of options:
  
  * For membership-based Users, use CiviCRM Member Sync. You can then create your Users from the plugin's "Manual Sync" admin screen.
  * For login-based Users, you can create Users one-by-one with CiviCRM's built-in "Create User Record" option in the Actions menu on the Contact View screen. Or you can use CiviCRM Profile Sync which has a "Create Users from Contacts" Bulk Action in CiviCRM that you can enable by adding `define( 'CIVICRM_WP_PROFILE_SYNC_BULK', true );` to your `wp-config.php` file.
  
  > Wordpress groups
  
  WordPress doesn't have groups out of the box, so you need to decide which plugin you want to use to provide them.
  
  BuddyPress can provide them if you're after social media style discussion groups and that's what BP Groups CiviCRM Sync is for - it works in a similar fashion to the Drupal OG Groups Sync module.
  
  The "Groups" plugin can also provide them and that's what CiviCRM Groups Sync is for - these groups are permissions-based groups and don't do anything in and of themselves but can be used to grant (or revoke) access to content.
  
  Your choice of group type depends on your use case.
  
  Hope that helps get you started.
  
  > **Comments:**
  > **username_0**: Excellent, thanks - so to clarify, since I'm not using Memberships or BuddyPress, I should create WP users using CiviCRM Profile Sync, and then keep them up to date using CiviCRM Groups Sync?  I'm still a little confused how those two relate to each other.  
  > **username_1**: Depends on your use case Ken :-) Why do you need Contacts to have Users?  
  > **username_0**: A set of about 70 people (within our CRM of about 3000 people) need to be able to log in to see privileged content.  We're a choir, these are the choir members - they need to see names & numbers of other singers, as well as logistical stuff & things that aren't public for copyright reasons.  
  > **username_1**: @KenWilliams I'd assign them a free membership (since they are choir "members") and then use CiviCRM Member Sync to create WordPress Users. The sync can be set up such that they get assigned to groups provided by the Groups plugin for capabilities required to view restricted content.  
  > **username_0**: I've had a chance to play around with this, and I think CiviCRM memberships aren't a good fit.  There's a lot of assumed workflow around memberships that doesn't fit.  Is it not possible to get a similar syncing behavior with CiviCRM groups, then?  
  > **username_1**: What do you mean by "assumed workflow"?  
  
  ---
  
  