// Load by name $_category = Mage::getModel('catalog/category')->loadByAttribute('name', 'Ruby Ring'); $_product = Mage::getModel('catalog/product')->loadByAttribute('name', 'emerald earring'); // Load by SKU $_product = Mage::getModel('catalog/product')->loadByAttribute('sku', 'Eram18j4'); //Load by ID (just load): $_product = Mage::getModel('catalog/product')->load($productID); example: <?php $productID = $this->getProduct()->getId(); $_product = Mage::getModel('catalog/product')->load($productID); //echo '<pre>'; //print_r($_product); ?> <img src="http://54.219.137.93/magento/media/catalog/product<?php echo $_product->getSmallImage(); ?>" width=100 height=100 /> <?php echo '<br/>'; echo "List Price"; echo $_product->getPrice(); echo '<br/>'; echo "Sale Price"; echo...