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):
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 is the right choice for that, am I correct?
I've been getting a little confused between 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?