开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜