You can delete all post via $wpdb
DELETE FROM wp_posts WHERE post_type="post_type";
DELETE FROM wp_postmeta WHERE post_id NOT IN (SELECT id FROM wp_posts);
DELETE FROM wp_term_relationships WHERE object_id NOT IN (SELECT id FROM wp_posts)
or use this query replace it with {{your CPT}} with your Custom Post Type
DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b
ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c
ON (a.ID = c.post_id)
WHERE a.post_type="{{your CPT}}";
Related Posts:
- Most efficient way of deleting post
- WordPress Admin Page Slow. Customer Post Type is the slowest
- Should I use custom post types or a custom database tables for plugin development?
- Where are wordpress custom types stored?
- Custom Post Types, or completely custom?
- WordPress Custom Post Type Admin Page really slow
- Custom Post Type with Input fields to seperate table on database.
- Right way of storing large number of custom post fields
- How to use custom database tables for custom post types?
- How often do you need to register_post_type?
- Custom Post Type or Custom Tables
- Custom post type or just use custom fields
- Create Pages from Database
- Use Custom Database with Custom Post Type
- Custom Search | Wrong output & question
- How do I write this SQL statement for Posts written in last 24 hours?
- Save or update data when custom post published
- Custom post type Vs. data in own table
- Save custom post type in different table
- Is there any performance consideration when using Custom Post Types?
- Using posts and postmeta table to store custom Address Book Plugin data
- How to use custom post type APIs, but use a different db table
- Developing WordPress on Kubernetes
- Recommended custom post type structure for TV Schedule site?
- Filtering by Post Meta Custom Fields – Performance
- WordPress post count not showing for custom post type author
- Where to store custom tagging data associated with a custom post type
- wpdb custom post_type problem
- Adding custom tables to WordPress
- WP All Import – Using Xpath to set a select value
- Sorting custom post type columns with external data and without meta values
- Getting a PHP Notice when using Pods with WPML [closed]
- Custom Post Types. Are there any disadvantages/advantages in using a plugin to develop them?
- How to use custom taxonomies to reference complex relationships?
- Create a clone from one WordPress site to another in a few minutes
- Database to page routing API?
- Are pages consuming more server resources than posts?
- Custom Post Type + ACF and performance [closed]
- Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
- Side effects of Script and Iframe in post
- How to change wp prefix for custom post type only?
- Is it possible to store Custom Post Type data in separate set of tables and still have wp_post class functionality?
- Add update or delete database records using custom post type
- How to import a custom MySQL DB table into a WordPress custom post type
- Terms showing up in object cache on unrelated pages
- WP_Query orderby and tax_query
- Importing Data from a Non-WordPress database, into WP
- How to organise this data within WordPress
- Organize WordPress site, so it can maintain with huge database
- Save custom post type to external database
- Show data from one Custom Post Type in another Custom Post Type
- Specifying meta field’s column type in Database using add_post_meta
- Replace dynamically content in a custom database table when a custom post is created
- Running a song lyrics site on WordPress
- Save and user submitted data from a form and display them in the wp backend
- Dump custom post type database
- Should I use custom taxonomies or not?
- Designing a custom post type with a minimum number of meta fields
- Allow front end users to add data to a custom post type
- WordPress hook which triggers on post import
- Update all published posts at once
- Entity to store contact form entries?
- Ideas to connect external database table to wordpress posts as custom field source
- Database alteration: users who voted
- WordPress as a frontend website for iOS app [closed]
- Using custom post types WordPress network
- delete duplicate meta_value with same post_id
- custom post type: own database table structure and custom “new-post” interface
- Import External XML
- Say I have a tech blog, how best would I store technical specs for a phone, if i use custom post types
- How do you make relational post types in WordPress? [duplicate]
- Having a repeating custom field in admin custom post type, what I’d go better with, for DB’s sake? ACF repeater or query a different post type?
- Does this archive template part look like its making too many calls to the db?
- Right way to store a large set of similar information on website? [duplicate]
- when looping through custom post data not appearing
- custom post types, custom fields and normalization
- Automatically convert standard posts with custom fields to custom post types
- In WordPress do I create tables for my plugin or do I create custom post types for a Student and Classes Registration system?
- CPT or Custom Table for Repository of Serial Numbers
- How to enable the user to add value through the admin panel?
- Use Tags to Query Associated Multiple Posts and Get The Average Of Custom Field Values
- Shared Custom post type between WP network sites
- Custom Post Types and Posts are mixed
- Pulling Content from Existing Database
- Custom Post Type vs Shortcode: Which one is more performant?
- Displaying database table in backend of wordpress
- custom post type for custom talbe
- Check in function on custom page
- Problem with menu categories doubling up when updating database?
- Inserting into WP DB
- Save number of Facebook likes to database
- WordPress and Unity high scores table
- Checking for published posts in a certain post type
- Switched server & domain name, now custom post types won’t save
- custom post types containing a collection of items
- Why WordPress does not Use Separate Table for Post Types (When Registring)?
- Remote database access on another wordpress site’s custom post type
- What would be the optimal CPT / Taxonomy design for the following entities structure
- Should I save user cookie consent in a custom post type or make a custom database table?
- Optimizing storage of Post Meta Entries