How to clear up the Dashboard stats in Magento 1.9, which shows a lot of total sales? I got hold of some mysql statements, but in Magento 1.9 the table names don't match.
Instead of using Raw queries or script use one of the extension listed below:
They will delete all the unwanted and dummy orders. To remove search terms, you can goto Catalog->Search Terms and delete all of them.