Clarification: We might want to do this as ad-hoc need, not something that we will usually do from the admin interface. So if this is something we can request to change on the database it would be highly appreciated, I expect no more than 5-6 groups in this situation.
@nukeador I don't have access to your production database, so doing an ad-hoc solution is not viable. Also the way the meta data is stored in a non readable way so updating the data manually would not be easy. Creating an interface in the admin would be easier, the only thing stored on the wordpress side is the group / category ids, anytime we need to pull data I do a get on the category / group, so I wouldn't need to sync anything on this side.
As long as the proper cateogry id is used, but there is no way for me to verify which is the "correct" category id. Also you would need to find the id from the discourse side we wouldn't be searching from the portal side for the proper id.