Populate custom post type/custom fields from an external database
I have a custom MySQL DB(same host/different domain) with a lot of vehicle information.
What we want to do is populate a custom post type and custom fields with this data so that it’s SEO friendly in WP. Is there any way to do this in WordPress? Basically have WP look at this table to populate the custom post type. We will NOT be using WP to manage this data. When the data is updated in this table, it should automatically be updated in WP.
So basically not an import, just read off of the other table. If it helps, we do have a REST API built too.
I’m hoping what I’m saying makes sense. If it doesn’t, please feel free to ask me questions. This is a pretty big deal to us and we really want to figure out the best solution.