Magento 2 : Reset Dashboard Data

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;

About air

Periksa Juga

Magento 2 : Mengetahui Versi Magento

Cara mudah mengetahui versi Magento 2 adalah melalui browser.Cukup tambahkan magento_versioncontoh :https://mage.andhiirawan.my.id/magento_versionhasilnya : Related posts: …

Leave a Reply

Your email address will not be published.