I deleted all search terms in catalog/search terms/select all/delete to clear but then in few minutes later it reappears in the dashboard.I want to show new search terms in the dashboard from scratch.

Same thing is happening to report/shopping cart/Products in carts.After I cleared with sql script.

How can I prevent this problem?


Also simple enough – go into Catalogue / Search Terms, select all, and delete.

or set all search results views to 0

UPDATE catalogsearch_query SET num_results=0, popularity=0;

  • in the database a query – Klettseb Feb 20 '15 at 7:54
  • cache cleared also? – Klettseb Feb 20 '15 at 9:34
  • Yes cache is cleared for Magento.After execution in the database's sql:UPDATE catalogsearch_query SET num_results=0, popularity=0; the search terms slowly reappears again. – n01 Feb 20 '15 at 9:44
  • Also for clearing reports for product in shopping cart I did: TRUNCATE sales_flat_quote_item; but same thing happens..Once everything is gone but in few min./hours later it reappears.Some never came back but some did.. – n01 Feb 20 '15 at 9:48
  • I guess it stops when I enable Magento maintenance extension.When disable it starts again..I'm sure no one is searching when its on live. – n01 Feb 20 '15 at 10:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.