Reviews - Updated [Support Thread]

[lat9]

Hello Cindy - my apologies - please IGNORE my posts above - I figured out the issue was to do with my template - jumped the gun too early. This plugin works great.

There is one question though :) - can the date of a review be changed after submission - date cannot be edited in admin/catalog/reviews (only review text which is strange, content can be edited but nothing else).

Because I didn't have the reviews by guests set up properly for a long, long time I have missed out on some who would have otherwise left reviews - they actually sent emails saying how happy they were with the product(s) - I want to copy the content of their positive remarks and submit a review with it but I really want to be able to change the dates otherwise I could have a number of reviews all with the same date which may look suspicious to Mr Google Bot - any ideas?

cheers Mike

Mike, the plugin affects only the storefront "offering" and acceptance of reviews by guests; it doesn't have any admin-level component. That address-change can be performed in the admin, through a kind of convoluted process, though.

Log into the admin, go to Catalog->Reviews and view the review whose date should be updated. You'll see a link similar to the following:

http://localhost/site/admin/reviews.php?page=1&rID=16&action=edit

That rID value identifies the reviews_id associated with that review.

Armed with that information, go to Tools->Install SQL Patches and enter the following to change that review's date-added to a specific date:

UPDATE reviews SET date_added = '2019-09-18 00:00:00' WHERE reviews_id = 16 LIMIT 1;

Alternatively, you could set the date_added to today's date:

UPDATE reviews SET date_added = now() WHERE reviews_id = 16 LIMIT 1;