If you need to delete all WooCommerce booking with the custom post type wc_booking you can use the MySQL query below: DELETE FROM wpstg4_postmeta WHERE post_id IN ( SELECT ID FROM wpstg4_posts WHERE post_type = ‘wc_booking’ ); DELETE FROM wpstg4_posts WHERE post_type = ‘wc_booking’;
Tag: query
MySQL Query: How to Delete all WooCommerce Orders
Use this MySQL query to delete all woocommerce orders at once from the MySQL command line. This can be useful if you want to delete all orders on your staging site and then import all orders again from the live site to make the staging site up to date before pushing it to the live … Continue reading “MySQL Query: How to Delete all WooCommerce Orders”