Thread: Import from other CMS with SQL

Import from other CMS with SQL

Hi,

We are building an WordPress site to replace an old system and used a custom SQL script to convert all the data into WordPress format as "listing" CTPs including some custom fields. Unfortunately, posts imported this way show up under Listings backend, but do not appear on the frontend or under Listings backend when filtered by category.

I have found that by opening a listing and clicking "Update", the listing seems to work fine, but there are too many listings in this database to do this for every one. I was hoping that someone with knowledge of the custom save_posts etc for listings could tell me what metadata these listings need in order to show up, as with the vast number of listings involved, MySQL or PHP is the only way to fix all of them at once.

Please let me know if you need further information.

Thanks.