Featured Articles
In today’s competitive world, one must be knowledgeable about the latest online bus...
Oct 12, 2018
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; ############################## # 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; SET FOREIGN_KEY_CHECKS=1; https://www.mageefy.com/blog/post/delete-bestsellers-search-terms-data-magento-dashboard
Article source: https://article-realm.com/article/Arts-Entertainment/Celebrities/42703-Delete-Bestsellers-and-Search-Terms-Data-from-Magento-Dashboard.html
Comments
Reviews
Most Recent Articles
- Oct 28, 2026 Tantrik in Delhi and Vashikaran Specialist in Kamakhya by Alzbeta Berka
- Oct 10, 2026 Muslim Astrologer in Kolkata and Tantrik in Kolkata by Alzbeta Berka
- Oct 10, 2026 Vastu Consultant in Kolkata and Vashikaran Specialist in Kolkata by Alzbeta Berka
- Jun 4, 2026 Famous Astrologer in Kolkata for Accurate Online Astrology Consultation by Alzbeta Berka
- Jun 4, 2026 Genuine Astrologer in Kolkata for Trusted Guidance and Life Solutions by Alzbeta Berka
Most Viewed Articles
- 3880 hits Bike Learning & Riding While Using Motorcycle Boots Houston & Leather Accessories by Motorcycle Accessories
- 2359 hits Shop a variety of trendy Muslim headscarf online by Lisa Stewart
- 2280 hits What To Know About Musician's Union Fees by Michael Welsh Productions
- 2145 hits Which is a right place to buy the 3D business cards? by E-plasticcards
- 1655 hits Importance of Custom-Designed Business Signs by Harry Landri
Popular Articles
In today’s competitive world, one must be knowledgeable about the latest online business that works effectively through seo services....
81694 Views
Walmart is being sued by a customer alleging racial discrimination. The customer who has filed a lawsuit against the retailer claims that it...
64137 Views
Are you caught in between seo companies introduced by a friend, researched by you, or advertised by a particular site? If that is...
37420 Views
Facebook, the best and most used social app in the world, has all the social features you need. However, one feature is missing. You cannot chat...
23698 Views
If you have an idea for a new product, you can start by performing a patent search. This will help you decide whether your idea could become the...
14970 Views
Moving becomes easy when you have the right moving accessories. These moving accessories help secure and protect your item by ensuring that no harm...
13326 Views
A lot of us look forward to the result of moving and not the process itself. It is pretty typical behavior, though. As modern people, many things...
13295 Views
Building a custom home is an exciting adventure. It’s your chance to bring your vision to life and create an area that sincerely displays...
13046 Views
Moving from one state, city, or even to a whole different county, is something that is either dictated by choice or circumstance. This is because,...
12137 Views
The report is titled as ‘Recombinant Cell Culture Supplements Market: Opportunity Analysis and Future Assessment 2022-2030’. An...
11936 Views
Statistics
| Members | |
|---|---|
| Members: | 17281 |
| Publishing | |
|---|---|
| Articles: | 80,018 |
| Categories: | 202 |
| Online | |
|---|---|
| Active Users: | 2501 |
| Members: | 3 |
| Guests: | 2498 |
| Bots: | 17170 |
| Visits last 24h (live): | 4824 |
| Visits last 24h (bots): | 46017 |
