Delete Bestsellers & Search Terms Data from Magento Dashboard Article Realm.com Free Article Directory

Featured Articles

Boost Your Website Traffic with High Quality DA/PA 40+ Backlinks

Apr 7, 2023

The Latest Online Business

In today’s competitive world, one must be knowledgeable about the latest online bus...

Oct 12, 2018

by mageefy on Apr 18, 2023 Celebrities 346 Views

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

General
Link

Comments

No comments have been left here yet. Be the first who will do it.

Reviews

Guest

Most Recent Articles

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
Jun 4, 2026 Astrology Services in Kolkata for Accurate Guidance and Life Solutions by Alzbeta Berka
Jun 4, 2026 Best Astrologer Services in Kolkata for Holistic Astrology and Vastu Solutions by Alzbeta Berka
May 4, 2026 Best Astrologer Services in Kolkata for Vastu & Holistic Guidance by Alzbeta Berka

Statistics

Members
Members:	16440

Publishing
Articles:	77,603
Categories:	202

Online
Active Users:	410
Members:	6
Guests:	404
Bots:	11336
Visits last 24h (live):	1660
Visits last 24h (bots):	29152
Dipak Straits, Jane Tian, Kiran Aggarwal, Mbbsinblog, michael, My Gem Consultant

Latest Comments

Having a reliable account portal is very important, and this is exactly what Target red Card Login offers. The platform offers easy access to account details and payment instruments, enabling...

on Jun 5, 2026 about How to perform Inkjet Canon Printer setup?

Ready to stream? Just go to Amazon.com/mytv to activate your device with a few easy steps, and you'll be watching your favorite movies, TV shows and exclusive Prime Video content in no time!...

on Jun 4, 2026 about How to perform Inkjet Canon Printer setup?

As someone interested in technology, I appreciate how IDEs simplify complex development tasks and make programming more accessible. Reading about the challenge of choosing the right IDE reminds me...

on Jun 4, 2026 about 10 Best Java IDEs and Editors in 2023

Yes, great US Military force. Also, in his post you have given a chance to listen about US Military. I really appreciate your work. Thanks for sharing it. oak dining table

on Jun 3, 2026 about 8 Effective Strategies for Maximizing ROI with Local Classified Ads

It's worth noting that Facebook Messenger offers several cool features like managing multiple accounts, integrating SMS messages, and even a secret conversation mode for added privacy. So, if...

on Jun 3, 2026 about How to Download and Install Facebook Messenger on Firestick

Think of a friend who will not be intimidated by your request for something out of the ordinary. We have heard about every type of thing and done all of it in our Escort Delhi. She'll answer...

on Jun 3, 2026 about Python in 2026: Mastering the Free-Threaded Era and AI Agent Development

Our Delhi Escorts pick this work simply because they like it; and they feel fortunate to encounter genuine, interesting clients similar to you who can be trusted. Hauz Khas Escort Escort...

on Jun 3, 2026 about Why Aviator Predictor Bots Are in High Demand in 2026

An engaging post with logically presented ideas and smooth transitions. It enhances readability and makes understanding easier. While exploring Delhi Escorts your content was insightful and...

on Jun 3, 2026 about How to Start an Invention Idea

Target red Card Login is a handy resource for cardholders who want quick and safe access to their accounts. It’s easy to track your account activity, make payments, and receive special offers...

on Jun 1, 2026 about How to perform Inkjet Canon Printer setup?

This is so relatable! I remember trying to describe my product idea for a patent and struggling to articulate its unique selling points. Practicing articulating thoughts clearly, maybe even using...

on Jun 1, 2026 about How to Start an Invention Idea