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 369 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:	16987

Publishing
Articles:	79,282
Categories:	202

Online
Active Users:	2812
Members:	9
Guests:	2803
Bots:	28012
Visits last 24h (live):	5505
Visits last 24h (bots):	63731
Bespoke PPF Solutions - Sarasota Paint Protection , coherentmarketinsights, Coherent MI, Jane Tian, Nueva Cash, henry bradely, Steve Jonas, tech carrer

Latest Comments

You did a fantastic job breaking down the topic. The examples made everything easy to understand and relatable. Thanks for sharing such valuable insights. by Hallucinogenics and Purecybin

on Sep 4, 2026 about The Latest Online Business

Excellent information providing by your Article thank you for taking the time to share with us such a nice article. Jack

on Sep 3, 2026 about Aircon Issues That Require A Crisis Fix

I once spent weeks meticulously documenting a software concept, fearing any oversight might jeopardize future protection, only to find the process even more daunting when a potential investor...

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

Opting for a Vip Escort Delhi professional is a commitment to a premium, secure, and discreet lifestyle. Their unwavering focus on your desires, set within a private and comfortable...

on Sep 2, 2026 about AI-Assisted Code Migration: 2026 Guide to Agentic Modernization

I really enjoyed exploring Article Realm because it covers a variety of useful topics for people interested in building an online presence. This article especially highlights how SEO, keywords,...

on Sep 1, 2026 about The Latest Online Business

I like the focus on identifying specific gains from personal content marketing because it makes the strategy feel more purposeful than simply posting regularly and hoping something sticks. In my...

on Aug 31, 2026 about Do You Know Your 6 Personal Content Marketing Gains?

I also liked the point about low-traffic websites. AI may identify behavioral patterns faster, but when the sample size is too small, the test results can still be unreliable. A tool can speed up...

on Aug 29, 2026 about How TrendWaltz Uses AI to Improve Conversion Rate Optimization

The article also made me think about something that's easy to overlook: backlinks should ultimately provide value to real users. If a link has no real context and exists only to increase the...

on Aug 29, 2026 about Boost Your Website Traffic with High Quality DA/PA 40+ Backlinks

FNAF Game is one of those games that can make even a quiet room feel terrifying. I really enjoy how the game builds tension slowly instead of relying only on sudden scares. Watching the cameras,...

on Aug 29, 2026 about Best Sportsbook Clone Provider Guide for Businesses

Deadshot IO is a really enjoyable FPS experience for players who like fast combat and competitive gameplay.

on Aug 29, 2026 about 5 Exciting Hens Games to Spice Up Your Hen Night