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 357 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:	16727

Publishing
Articles:	78,399
Categories:	202

Online
Active Users:	1325
Members:	1
Guests:	1324
Bots:	5441
Visits last 24h (live):	3905
Visits last 24h (bots):	36866
Oleg Suru

Latest Comments

If you are looking for a top-tier Russian Delhi Call Girls Service , browse our verified profiles for the best experience.

on Jul 21, 2026 about Nice Girls Do It, Too!

When the demands of your schedule leave little room for error, booking a VIP Delhi Escorts Service becomes the most logical choice. True luxury is found in the sanctity of privacy, and these...

on Jul 21, 2026 about Top 10 Cryptocurrency Exchange Development Companies in India, USA & UK

Stickman Hook is suitable for all ages, appealing to everyone from casual players to those who enjoy challenging their skills and chasing speed records.

on Jul 21, 2026 about How Lesbian at Chat Lines Can Spice Up Dating Life in 2024?

We are a party with people we know because they are both really warm and interested in fun. Our Dwarka Escorts Service connections are genuine with each and every client. This authenticity...

on Jul 20, 2026 about Best SAP Training in Mumbai

Are you looking for excitement and pleasure tonight? Escorts Service in Gurgaon offers instant booking with beautiful escorts available. Our girls provide an exceptional experience tailored to...

on Jul 20, 2026 about How to Use Moving Blankets to Protect Your Items When Moving

There will be fresh difficulties for all players, from those with zero runs under their belts to those with hundreds. moto x3m

on Jul 20, 2026 about Ensure Event Success with Professional Event Stewards

This is such a well-written and inspiring post! I love the way you present your ideas, and the visuals you included make it even better. In today's digital world, having high-quality, crisp images...

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

이 기사는 기사 역사상 최고 중 하나입니다. 나는 골동품 'Article'수집가이고 때때로 그것들을 흥미롭게 읽습니다. 마리오 도메인 주소

on Jul 18, 2026 about Aircon Issues That Require A Crisis Fix

Thank you for your blog. It's awesome! 마리오토토

on Jul 18, 2026 about Aircon Issues That Require A Crisis Fix

Planning to apply for a personal loan? Knowing the Paytm personal loan documents required can help you prepare your application in advance. Keep the necessary identity, address, income, and...

on Jul 18, 2026 about Casing cementing process