Here is a quick code to get product information with SKU value.

Get product information by sku

$sku = "microsoftnatural";
$product = Mage::getModel('catalog/product')
			->loadByAttribute('sku', $sku);
			
echo "<pre>"; 
print_r($product->getData()); 
exit;

Get product id by sku

$productIdBySku = Mage::getModel('catalog/product')
					->getIdBySku('microsoftnatural');
					
echo $productIdBySku;

Hope it helps. Thanks.

Get New Post by Email

Subscribe RSS Feed Follow @chapagain