How to delete / clear all product reviews in magento?

How to delete /开发者_运维知识库 clear all product reviews in magento?

Go to Catalog -> Reviews and Ratings -> Customer Reviews -> All Reviews

There are checkboxes and you can take the "Delete" action in the upper right.

truncate table `rating_option_vote`; 
truncate table `rating_option_vote_aggregated`;
truncate table `review`; 
truncate table `review_detail`; 
truncate table `review_entity_summary`; 
truncate table `review_store`;

You do not have to delete all of the tables, just the main one (review) and the aggregated (review_entity_summary), they use foreign keys and are set to cascade on delete of parent.

You can just run the following:

DELETE FROM review;
DELETE FROM review_entity_summary;
DELETE FROM rating_option_vote;
DELETE FROM rating_option_vote_aggregated;

That should help remove any old reviews.