Delete Posts and Comments from Action Scheduler
The Action Scheduler is a background processing, queue job runner which is built into WooCommerce core. A number of plugins use the Action Scheduler, WooCommerce Subscriptions and WooCommerce Follow-Ups being two of the best known.
WP-CLI makes it easy to delete posts and comments which have been created by the Action Scheduler in WooCommerce. There may be cases where the Action Scheduler might create a large number of posts and comments on your live site, and you want to clear up the data from the site's database.
Delete Comments from Action Scheduler
To delete comments created by the Action Scheduler, you can run this wp-cli command:
wp comment list --field=comment_ID --'comment_author'='ActionScheduler' --number=1000 | xargs wp comment delete --force
The number can be increased if you have more comments that need to be deleted to 2000 or higher.
Delete Bulk Posts from Action Scheduler
To delete all the scheduled-actionposts, you can run this wp-cli command:
wp post list --field=ID --post_type=scheduled-action --posts_per_page=1000 | xargs wp post delete --force
The number can be increased if you have more posts that need to be deleted to say 2000 or higher.
Delete Scheduled Action Posts
To delete all the scheduled-action posts with a post status of trash, you can run this wp-cli command:
wp post list --field=ID --post_type=scheduled-action --posts_per_page=1000 --post_status=trash | xargs wp post delete --force
Delete Bulk Scheduled Actions
To delete all the scheduled-action posts with a post status of cancel, you can run this wp-cli command:
wp post list --field=ID --post_type=scheduled-action --posts_per_page=1000 --post_status=cancel | xargs wp post delete --force
Conclusion
Using a mix of these commands, you will be able to delete posts and comments easily, using WP-CLI on your site. It will also keep your site database clean, allowing it to run more efficiently. Take the work out of maintaining your WordPress site with our Managed WooCommerce product. Our WooCommerce platform comes with free iThemes plugins curated especially for online stores.
Related Articles:

About the Author: Luke Cavanagh
Product Operations Manager at Liquid Web. Devoted husband and Tween wrangler. Synthwave enthusiast. Jerry Goldsmith fan. Doctor Who fan and related gubbins.
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.
Latest Articles
ChatGPT Integration — How to Create a Plugin for ChatGPT
Read ArticleWhat is CentOS? Everything You Need to Know
Read ArticleWhat is CentOS? Everything You Need to Know
Read ArticleRedis as Cache: How It Works and Why You Should Use It
Read ArticleRefer-a-Friend Program for Website Hosting: Get $100 for Each Friend!
Read Article