title: magento: fetching MPN( manufacturer part no ) or UPC (Universal product code)
body: <p>I tried searching for MPN and UPC in the magento 1.4 - 1.5  database. Seems they're non existent or may be named differently. In which table can i find these values? i tried this</p>
  
  <pre><code>Mage::app();
  $products = Mage::getModel('catalog/product')-&gt;getCollection();
  $products-&gt;addAttributeToSelect('*');
  $products-&gt;load(); 
  
      &lt;mpn&gt;&lt;![CDATA['. $product['mpn'] .']]&gt;&lt;/mpn&gt;
  </code></pre>