I've built two WordPress sites. One is public site--people go to it, view my content, etc. The other site is a private course catalog. In the course catalog I have 3 custom post types. The content of the course catalog gets shared to different places via templates that output XML, PDFs, and so on, and then the content also needs to go to my main site. The course catalog posts change from time to time, so the main site needs to update to reflect those changes.
I can't figure out HOW, though. I'm hoping the community here can help me figure it out.
Using WordPress Export to get the custom post types out form the course catalog and import into the main site works but for two problems: existing posts will not be updated to reflect changes and categories from the course catalog CREATE categories in the main site instead of using the already existing, identically named categories.
I've looked into FeedWordPress, but it doesn't do custom post types and custom fields, even if I build an RSS template in the course catalog to show those custom fields.
WP All Import says it will do everything but the categories, but I need the categories to map correctly between sites. The content is organized and filtered by category in the course catalog front end.
Help? Please?