How to delete all reviews & ratting – magento 1.9

Hello Friends,

When ever you are developing online store for your client, You are inserting some demo products / reviews / categories. But this all are for demo only..

So now when you do store online with real products and categories you must need to delete review & ratting that you have inserted for demo purpose.

Here is SQL Query for delete all reviews and ratting.

SET FOREIGN_KEY_CHECKS = 0;
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`;
SET FOREIGN_KEY_CHECKS = 1;

Don’t forgot to insert “FOREIGN_KEY_CHECKS = 0” before start query. If you are not set FOREIGN_KEY_CHECKS = 0 it maybe give error because of foreign key relation in tables.
And please visit “How to delete all review and ratting one by one from admin panel” if you want to delete it manually.

Hope you have deleted all reviews and ratting after read this blog.. Now next is to delete all products and categories. so you can read here “How to delete all products” & “How to delete all categories“.

Thanks for read, Please comment below!!!

Rakesh Patel on sabtwitterRakesh Patel on sabrssRakesh Patel on sabgoogleRakesh Patel on sabgithubRakesh Patel on sabfacebookRakesh Patel on sabemail
Rakesh Patel
Website Devloper at Divine Web Technology
Hello Viewers,
My self Rakesh Patel, And i am website developer from last 6+ Year, I am working as a full time freelancer from last 2years. My skills are Core PHP, Wordpress, Magento, HTML, CSS, Joomla, Drupal, Smarty.

I really like to share my skill to all my developer friends, And also request you all, Please share your skill here so other developer can get help.