In this tutorial, we will show you how to search all WooCommerce product reviews by date. This will allow you to easily find all product reviews created on a specific date or all reviews added in a specific date range.
Want to find all the reviews created today? Want to know how many reviews were added last month? You can easily do it using WP Sheet Editor – Comments and Reviews plugin.
This plugin allows you to view and manage all your WordPress comments and WooCommerce reviews using an intuitive spreadsheet inside WordPress.
You can filter your comments and reviews using any field and value as search criteria; you can edit any field in hundreds of comments at once. The plugin also allows you to export/import hundreds of comments to do mass migrations from one site to another without losing the relationship between the review/comment and the product/post.
You can download the plugin here:
Download Comments and Reviews Spreadsheet Plugin - or - Check the features
Once you install and activate the plugin, proceed to set up the comments spreadsheet. Here’s a quick guide on that.
Follow these simple steps to search for all the product reviews by date:
1- Open the product reviews spreadsheet
To view and manage your product reviews using the spreadsheet, go to WP Sheet Editor > Edit Comments.
You’ll see all your comments and reviews displayed on the spreadsheet. Every row will be a comment/review and every column will be a field.
2- Open the “Search” tool to filter the reviews by date
We’ll use the Search tool, which allows us to filter all comments and reviews using any field as a search parameter.
3- Search for WooCommerce product reviews by date
This tool allows you to perform advanced searches using several search filters. For example, here we will search for all reviews added to WooCommerce products, and that have been created/added on a specific date. That is, we will use three search filters to narrow down the results.
- Post type: Products (product)
- Comment type: Reviews
- Tick the Enable advanced filters checkbos.
- Field: Date (comment_date)
- Operator: =
- Value: Select the date here.
- Hit the Run search button.
If you want to find all the product reviews added during a specific date range, you can hit Add new to add a new advanced filter, and use the following values:
Initial date filter:
- Field: Date (comment_date)
- Operator: =>
- Value: Enter the initial date here.
Final date filter:
- Field: Date (comment_date)
- Operator: =<
- Value: Enter the final date here.
Once your product reviews have been filtered, the search results will be displayed on the spreadsheet.
With the WP Sheet Editor – Comments and Reviews plugin, it is really easy to manage your comments and reviews using an intuitive spreadsheet.
ou don’t need to go through them one by one, but you can easily filter them using any field as search criteria. You can find reviews by date, specific product, user ID, user IP, etc.
This can be very useful to present reports to your customers or create external custom databases.
You can download the plugin here:
Download Comments and Reviews Spreadsheet Plugin - or - Check the features