Clear Temporary Data Tables TRUNCATE `log_customer`; TRUNCATE `log_quote`; TRUNCATE `log_summary`; TRUNCATE `log_url`; TRUNCATE `log_url_info`; TRUNCATE `log_visitor`; TRUNCATE `log_visitor_info`; TRUNCATE `index_event`; TRUNCATE `report_event`; TRUNCATE `report_viewed_product_index`; TRUNCATE `dataflow_batch_import`; TRUNCATE `dataflow_batch_export`; TRUNCATE `sendfriend_log`; ALTER TABLE `log_url` AUTO_INCREMENT=1; ALTER TABLE `log_url_info` AUTO_INCREMENT=1; ALTER TABLE `log_visitor` AUTO_INCREMENT=1; ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1; ALTER TABLE `report_event` AUTO_INCREMENT=1; ALTER TABLE `report_viewed_product_index` AUTO_INCREMENT=1; ALTER…

To remove or Edit magento Footer links Site Map, Search Terms, Advanced Search and Contact us is very simple,By default your Magento 1.7.0.2 store will have various links such as Site Map, Seach Terms and Advanced search and Contact Us.You can remove these links from the footer in Magento follow these steps To remove Site…

In some situation when you want to re-index Magento catalog you will get an error message or reindex process will be broken. This problem is appearing when you have a lot of products in database and limited server resource. You can try to reindex from command line or shell. In Magento there is folder with…