www-mageefy-com-blog-post-delete-bestsellers-search-terms-data-magento-dashboard

[email protected] HIRE US     Home Magento Blog - Tutorials, Tips, News and Insights Magento Delete Bestsellers & Search Terms Data from Magento Dashboard Delete Bestsellers & Search Terms Data from Magento Dashboard Posted: August 07, 2016| Categories: Magento | Tags: search, magento, best sellers | Views: 9 Delete Bestsellers & Search Terms Data from Magento Dashboard Regularly whilst a Magento store is in the last phases of improvement, you'll develop a reasonable piece of test / dummy data (like test sales / orders and customers which will populate different tables, for example, bestsellers and search terms in your Magento dashboard. You can delete all the bestsellers and search terms from your Magento by running the below SQL query. This has been tested and confirmed working on Magento versions from 1.4.0.1 to 1.9.2.2. SET FOREIGN_KEY_CHECKS=0;  ALLOW COOKIES    ##############################  # SEARCH TERMS RELATED TABLES  ##############################  TRUNCATE catalogsearch_query;  TRUNCATE catalogsearch_fulltext;  TRUNCATE catalogsearch_result;  ALTER TABLE catalogsearch_query AUTO_INCREMENT=1;  ALTER TABLE catalogsearch_fulltext AUTO_INCREMENT=1;  ALTER TABLE catalogsearch_result AUTO_INCREMENT=1;  ##############################  # BESTSELLERS RELATED TABLES  ##############################  TRUNCATE TABLE sales_bestsellers_aggregated_daily;  TRUNCATE TABLE sales_bestsellers_aggregated_monthly;  TRUNCATE TABLE sales_bestsellers_aggregated_yearly;  ALTER TABLE sales_bestsellers_aggregated_daily AUTO_INCREMENT=1;  ALTER TABLE sales_bestsellers_aggregated_monthly AUTO_INCREMENT=1;  ALTER TABLE sales_bestsellers_aggregated_yearly AUTO_INCREMENT=1;  We uSEsTe cFoORoEkIiGeNs_KtEoYm_CHaEkCeKSy=o1u;r experience better. To comply with the new e-Privacy directive, we need to ask for your consent to set the

new e-Privacy directive, we need to ask for your consent to set the Next → Pricvaocyo- kTeiremss . Learn more. ← Previous Comment(s) Add a comment... Search posts here... Categories Magento (62) Magento 2 (20) How To (7) Magento Tutorials (4) Magento Security (0) Magento News (0) Shopify (0) Recent Posts How to Get Current Product in Magento 2? February 10, 2023 How to load Order data by Id programmatically in Magento 2 September 17, 2022 How to remove test customers in magento 2? July 08, 2022 How to get Invoice comments list programmatically in Magento 2? August 24, 2021 How to create custom validation message in Magento 2 August 01, 2021 Tags

magento custom magento2 product magento tips category resize order email module block payment extension search currency delete form image attribute programatically products cart review api captcha cms method related web service cutom modules date picker magento admin translation collection installation sort by filter dispaly level featured security layered navigation exchange patches admin item wysiwyg upgrade JOIN THE COMMUNITY TO BE UPDATED FIRSTLY ? Enter your email address SUBSCRIBE Mageefy is specialized in building successful e-commerce store fronts for Magento. Mageefy helps merchants plan, build, and run their online business. CUSTOMER SERVICE  INFORMATION  CONTACT US  Copyright ©2023 Mageefy.com. All rights reserved.