Over 15 years we helped companies reach their financial and branding goals. Beach Life Marketing is a values-driven and dedicated marketing agency.

Coding Tips

How to reset dashboard data in magento

When I first started in magento after logging into the dashboard, I saw a bunch of data that didn’t correspond to the real statistics and I wanted to deleted those data, but it was hard and I didn’t know how to do it via the admin area. This is what I had to do via SQL query. The following code was found on the internet and you now know how to do it too:

SET foreign_key_checks = 0;

— Last 5 Search Terms / Top 5 Search Terms

TRUNCATE TABLE catalogsearch_fulltext;

TRUNCATE TABLE catalogsearch_query;

TRUNCATE TABLE catalogsearch_result;

— Dashboard stats (e.g. “Most Viewed Products” etc)

TRUNCATE TABLE report_compared_product_index;

TRUNCATE TABLE report_event;

TRUNCATE TABLE report_viewed_product_aggregated_daily;

TRUNCATE TABLE report_viewed_product_aggregated_monthly;

TRUNCATE TABLE report_viewed_product_aggregated_yearly;

TRUNCATE TABLE report_viewed_product_index;

— Bestsellers

TRUNCATE TABLE sales_bestsellers_aggregated_daily;

TRUNCATE TABLE sales_bestsellers_aggregated_monthly;

TRUNCATE TABLE sales_bestsellers_aggregated_yearly;

SET foreign_key_checks = 1;