Detect and delete posts from custom post types that are no longer in use

keesiemeijer

Custom post type posts are left in the database if a post type is no longer registered (in use).
Plugins and themes can (without you knowing) use custom post types as a way to store data. These posts stay in the database forever if they’re not cleaned up by the plugin/theme itself upon deletion.
There are a lot of plugins that clean your database (by removing revisions, drafts etc.), but I haven’t found one that does a cleanup of unused post type posts.
This plugin provides an easy way to detect and remove posts from post types that are no longer in use. The settings page for this plugin is at wp-admin > Tools > Custom Post Type Cleanup.
Note: The proper WordPress delete function <a href="https://developer.wordpress.org/reference/functions/wp_delete_post/" rel="nofollow ugc">wp_delete_post</a> is used instead of running a direct MySQL query to delete the posts. This way all associated post data (comments, post meta etc.) are also deleted from the database.
Since version 1.2.0 you can re-register unused custom post types for a limited period of time. This allows you to inspect and delete the posts like you would normally (in the wp-admin).

Custom Post Type Cleanup


So I didn't have to :)



Awesome little handy tool to clean up old sites from obsolete CPTs and their post meta.



I wish it also supported custom taxonomies that were registered for those obsolete CPTs.


Alternatives to Custom Post Type Cleanup

Top alternatives