Magento: Remove best seller products from admin dashboard
Use the below MySQL queries:
TRUNCATE `sales_bestsellers_aggregated_daily`;
TRUNCATE `sales_bestsellers_aggregated_monthly`;
TRUNCATE `sales_bestsellers_aggregated_yearly`;
Related articles
- How Do I Optimize Magento? | Knowledge Center | Rackspace Hosting (rackspace.com)
- Mastering Magento – A Magento User’s Manual (stephanmiller.com)
Posted on September 14, 2012, in Magento and tagged Database, Magento, MySQL. Bookmark the permalink. 2 Comments.
Thanks for that. Edited the post.
TRUNCATE `sales_bestsellers_aggregated_yealry`; <= should read:
TRUNCATE `sales_bestsellers_aggregated_yearly`;