How to show the Exact searh result in Magento

If you want to show the exact search reuslt for your products Two things need to be changed 1) In admin system->configuration->catalog->catlogsearch->Search Type Make it as Like 2)Just copy the fulltext.php file in local folder as given app/code/local/Mage/CatalogSearch/Model/Resource/Fulltext.php and just replace the above code foreach ($words as $word) { $like[] = $helper->getCILike(‘s.data_index’, $word, array(‘position’ => … More How to show the Exact searh result in Magento

How to import products to magento using maento’s advanced data profile product import

So, I’m writing this and such because, for the life of me, I could not find proper instructions to import a bunch of items into Magento via their native importer–maybe another day I’ll write up a guide on how to do this with a 3rd party interface… Either way, here’s what I did to get … More How to import products to magento using maento’s advanced data profile product import

Magento : Delete All Orders and Customers

SET FOREIGN_KEY_CHECKS=0; — Here’s where we reset the orders TRUNCATE `sales_flat_order`; TRUNCATE `sales_flat_order_address`; TRUNCATE `sales_flat_order_grid`; TRUNCATE `sales_flat_order_item`; TRUNCATE `sales_flat_order_status_history`; TRUNCATE `sales_flat_quote`; TRUNCATE `sales_flat_quote_address`; TRUNCATE `sales_flat_quote_address_item`; TRUNCATE `sales_flat_quote_item`; TRUNCATE `sales_flat_quote_item_option`; TRUNCATE `sales_flat_order_payment`; TRUNCATE `sales_flat_quote_payment`; TRUNCATE `sales_flat_shipment`; TRUNCATE `sales_flat_shipment_item`; TRUNCATE `sales_flat_shipment_grid`; TRUNCATE `sales_flat_invoice`; TRUNCATE `sales_flat_invoice_grid`; TRUNCATE `sales_flat_invoice_item`; TRUNCATE `sendfriend_log`; TRUNCATE `tag`; TRUNCATE `tag_relation`; TRUNCATE `tag_summary`; TRUNCATE `wishlist`; … More Magento : Delete All Orders and Customers