WP Customer Reviews – Change date on a review


Change the submission date

WP Customer Reviews (Version 2.4.8) is an excellent plugin that allows you to setup a specific page on your blog to receive customer testimonials for your business/service or to write reviews about multiple products (using multiple pages). The plugin supports writing reviews on pages, posts and even custom posts.
Shortcodes are available for inserting reviews and review form on any page or widget.
However I ran into this issue while trying to change the submission date of a testimonial.

“Reviews can be edited by admin for content and date.”

On the admin page, there is a red pencil icon that, when clicked, opens an edit window for date and time of submission, stars rating and a review itself. However, once typed, changes are not getting saved and they go back to the original stage. It used to work with the older version of WordPress and this plugin. It doesn’t work for me anymore this way.

Other Solution I found:

Using phpMyAdmin choose your database and click on a table wp_wpcreviews within your database. Click on SQL (top) and in the white box RUN SQL query type:
SELECT * FROM wp_wpcreviews and then click GO.
It will bring you to wp_wpcreviews table with columns such as ID, date_time, reviewer_name, reviewer_email. Click on the Edit (pencil) on the review you’d like to change and the last column (value) is the one where you want to change your date. You can either click on the calendar or type your desired date and click GO.
After refreshing your page the date change should reflect on your website. You can change other values as well. This works great!

2 comments:

Leave a Reply

Your email address will not be published. Required fields are marked *