How to Load a Product by SKU in Magento?
This is very simple work, just add below code and set your SKU value to get Product.
<?php
$sku = ‘your-sku-value’;
$product = Mage::getModel(‘catalog/product’)->load($sku, ‘sku’);
if ($product->getId()) {
echo $product->getName();
}
else {
echo ‘Product not found with reference of SKU= ‘ . $sku;
}
?>
Hope it will work.