Magento Get Product ID from SKU

Load magento product by its sku. This is the fastest way to get product by sku.

$_product = Mage::getModel('catalog/product')->loadByAttribute('sku',$sku);

How to reset Magento admin password

If you need to change your magento admin password, go to phpMyAdmin, select your Magento database, click the SQL tab and paste this query:

UPDATE admin_user SET password=CONCAT(MD5('sGnewpass'), ':sG') 
WHERE username='AdminUsername';

You have to change newpass in the MD5('sGnewpass') with your new password, and change 'AdminUsername' to your Magento admin username.

Execute the query and your password will be changed.

Enable Search Engine Friendly URLs in Magento

To enable Search Engine Friendly URLs in Magento, you have to log in to the Magento admin area and click on the Configurations button. Under the System navigation menu, go to Web page from the sub-navigation panel on the left.

Click on the Search Engines Optimization tab and turn on the Use Web Server Rewrites (mark as Yes). Click on the Save Config button and your Magento SEF URLs will be enabled.

Remove Estimate Shipping and Tax box

If you need to remove the Estimate Shipping and Tax from shopping cart page on magento, follow these instructions:

Open /app/design/frontend/YOUR_PACKAGE/YOUR_THEME/template/checkout/cart.phtml file

Find the line that mentions shipping

Delete it and save file.

Clear cache and refresh page to see result.

Magento Print Collection Query

There come several situations where you need to print the collection query in magento and here is the way how to print collection query:

Print Collection Query

$collection->printLogQuery(true);