how to restore reviews sql from Magento

how to restore reviews sql from Magento

September 22, 2026 · Illustrated author avatarBy Stefan Bogdanescu
how to restore reviews sql from Magento

Restoring Magento Reviews from the Database

If you’ve accidentally deleted your Magento reviews but can still see them in the review_detail table, don’t worry—you can restore them without losing any data. The key is to understand how Magento manages its review system and use that knowledge to bring your lost reviews back online.

Understanding Magento Review System

Magento stores review data across multiple tables:

  • review_entity: Contains general information about the review.
  • review_detail: Stores the actual review text, rating, etc.
  • review_entity_int: Holds additional attributes for each review entity.
  • rating_options: Defines the rating options available to customers.

When a review is deleted from the Magento admin panel, it’s not physically removed from the database. Instead, Magento updates the status field in the review_entity table to ‘deleted’. The actual review data remains intact in the other tables.

Restoring Deleted Reviews

To restore your lost reviews, you need to update the status back to ‘approved’ for each deleted entity. Here’s how:

  1. Open PhpMyAdmin or any MySQL client that allows SQL queries.
  2. Locate the review_entity table where all your deleted reviews are still listed with a status of ‘deleted’.
  3. Run the following SQL query, replacing '0' with your store ID if needed:
UPDATE review_entity
SET status = 'approved'
WHERE entity_id IN (
    SELECT entity_id
    FROM review_detail
)

This query does two things:

  • The subquery SELECT entity_id FROM review_detail retrieves the IDs of all reviews that exist in the database.
  • The outer query then updates those entities to have a status of ‘approved’ in the review_entity table.

After running this script, log out and log back into your Magento admin panel. You should now see all your deleted reviews reappearing as if they were never removed!

Best Practices for Review Management

To avoid such issues in the future:

  • Always take a database backup before making significant changes to your store’s data.
  • Be cautious when deleting items directly from the database, especially without understanding their structures and dependencies.
  • Regularly review your database logs for any potential issues or anomalies.

Remember that Magento’s review system is quite robust but can be delicate if mishandled. Always proceed with caution when dealing with core tables like review_entity.

Learn More About Magento Development

If you want to dive deeper into Magento development, check out the Laravel Company Blog. We regularly publish articles on best practices for Magento e-commerce development and management.

Don’t let database errors keep you from building a successful online store. With careful attention to detail and some SQL know-how, you can handle any review-related challenges that come your way!

Happy coding!

Database API Admin Customers

Our network