Many Magento users find it very disappointing not to be able to delete test orders or at least to make them removed from the Admin Sales page. It's a required step that merchants or developers place several test orders before they officially launch the site. Obviously, they don't want their test sales mixed in the regular sales reports. It's hard to believe, but there is no easy solution for this in Magento Admin panel. These MySql queries can be handy when you want a fresh start with your Magento store. This is not a definite solution because you ...

Magento saves visitor and URL access information in its log tables (log_url, log_url_info, log_visitor and log_visitor_info). These tables can be quite large and affect site performance if they are not maintained. Majority of people already have some kind of traffic analysis tool - one of the most popular tools is free Google Analytics - and they don't necessarily find Magento log tables very efficient. You can set up a log cleaning cron job through Magento Admin panel. Go to System -> Configuration. Click on System from the left menu (almost at the bottom). Open Log Cleaning area and change ...