In this quick tutorial, we show you how to bulk delete all post comments using the Comments and Reviews Spreadsheet plugin.
You can’t do this with WordPress because it allows you to delete a certain number of posts only. Therefore, if you have thousands of comments to delete, you may spend a lot of time and get server errors if you try to delete too many comments at once.
However, this plugin allows you to…
- View and edit all WordPress comments on a spreadsheet
- Do advanced searches: search comments by comment type, post type, keyword, status, etc.
- Bulk edit any of your comments’ fields
- Export comments to a CSV file
- Import comments from a CSV file
After installing it, go to WP Sheet Editor > Edit Comments to open the spreadsheet. You’ll see all comments displayed as rows and all their fields displayed as columns.
Now just follow these simple steps to delete all post comments.
Step 1. Open the “Bulk Edit” tool
This tool allows you to edit thousands of comments at once. Open it with one click on Bulk Edit; it’s on the toolbar.
Step 2. Filter all post comments
The spreadsheet will show you all types of comments. For example, you’ll find comments, testimonials, reviews, etc.
Therefore, you need to open the Search tool by selecting the I want to search rows to update option in Select the rows that you want to update.
Now you need to select these options to filter all your post comments.
- Post type: post
- Comment type: Comment
- Click on Run search
This will filter your comments and take you back to the Bulk Edit tool.
Step 3. Delete all post comments
After filtering the post comments, select these options to delete them all at once.
- Select the rows that you want to update: I want to search rows to update
- What field do you want to edit: Status
- Select type of edit: Set value
- Replace existing value with this value: Delete completely
- Click on Execute now.
That was easy!
You don’t have to spend thousands of hours cleaning your post comments in WordPress. You can do it quickly with the Comments and Reviews Spreadsheet plugin.
Also, you can apply thousands of other changes and do advanced options.