I'm stuck at a scenario where my events custom post type posts have categories ticked but not actually assigned to them untill I manually republish or update every single post.

And its happening accros multisites and there are thousand of events which I cannot update manually one by one.

I was thinking of using wp-insert-post or wp-update-post functionality of wordpress in a loop across all my custom post type posts...

If anyone can point me in right direction.

Regards.