Berikut ini cara reset data-data pada dashboard data Magento 2 :
jalankan melalui database
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;