Get product details by sku. load product sku and fetch product name, price etc.
Here is code.....
$product = Mage::getModel('catalog/product')->loadByAttribute('sku','C499');
echo $product->getName() . "<br>";
echo $product->getShortDescription() . "<br>";
echo $product->getPrice() . "<br>";
echo $product->getSpecialPrice() . "<br>";
echo $product->getProductUrl() . "<br>";
echo $product->getImageUrl();
Labels: Magento