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 364 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:	16849

Publishing
Articles:	78,779
Categories:	202

Online
Active Users:	3102
Members:	16
Guests:	3086
Bots:	30639
Visits last 24h (live):	5441
Visits last 24h (bots):	57829
Administrator, Aiza Graves, Tim Wood, coherentmarketinsights, Coherent MI, Coheret Market Insights, James Wingston, Sayasai, Pramod Singh Parmar, ParTee Of18, Rahul Gautam

Latest Comments

Nice Post Good Work Mumbai

on Aug 11, 2026 about Activating Peacock TV on Fire TV:

Experience the joy of eggy car , where every level presents a new challenge! Navigate through tricky paths and keep your egg intact. With its simple controls and addictive gameplay, Eggy Car is...

on Aug 11, 2026 about Recombinant Cell Culture Supplements Market Report 2022 | Global Growth, and Forecast 2030 By R&I

Besides these intense study and training sessions, if you need a lighthearted form of management and constructive entertainment, a fun simulation game like monkey mart would certainly...

on Aug 11, 2026 about Top Prediction Market Development Companies Leading the Industry in 2026

The discreet professionalism of Escorts Ito ensures your private moments remain your own, allowing you to fully immerse yourself in the pleasure of their company.

on Aug 11, 2026 about Global Blockchain Government Market: 2025-2035 Policy Automation

asdasd

on Aug 11, 2026 about Why is Binance Clone Script Development a Smart Choice for Startups?

Thanks for sharing

on Aug 11, 2026 about Patricklamma

I really enjoyed going through your collection of articles. You have covered a wide range of useful topics, and the consistency of your writing shows genuine effort and knowledge. I especially...

on Aug 11, 2026 about Dr. Sam Khoury

A well-designed home also benefits from the right flooring and décor. TheRugShopUK offers rugs in various styles and sizes that can add comfort, warmth, and character to granny flats, bedrooms,...

on Aug 10, 2026 about Ways to Find the Best Custom Home Builders in Sydney

Quordle is like Wordle on steroids! Solving four words at once is a fun challenge that keeps me focused.

on Aug 10, 2026 about 5 Common Mistakes People Make When Moving House

Last weekend in Dwarka I finally decided to try something different and it was worth every rupee. The experience with VIP Dwarka Escorts felt genuinely premium, from the conversation to the...

on Aug 8, 2026 about Experts of Tourism Assignment Help Share Some Tips to do Assignments