we would like to check if products exists with the following code:

$foundProduct = Mage::getModel('catalog/product')->loadByAttribute('sku', $sku);

We only get positive results if "Use Flat Catalog Product" is disabled in the configuration.

  • try reindexing and recheck the results
    – MTM
    Aug 14, 2014 at 19:02

3 Answers 3


Try using $_product = Mage::getModel('catalog/product')->load($productSku, 'sku'); instead of Mage::getModel('catalog/product')->loadByAttribute('sku', $sku);

  • I don't know why, but this seems to help. Thank you very much! Aug 15, 2014 at 7:40
  • Remember to mark the question as resolved,
    – mbalparda
    Aug 15, 2014 at 10:02

the only working solution for both disabled and enabled products I found here: http://magentoexplorer.com/how-load-product-by-sku-or-id-in-magento

$_sku = 'leathershoes';

$_catalog = Mage::getModel('catalog/product');

$_productId = $_catalog->getIdBySku($_sku);

$_product = Mage::getModel('catalog/product')->load($_productId);


Just tested this on a category page, and it does work. On which page are u trying to do this, and in what code are you using $foundProduct?

Have you reindexed all indexes after enabling flat catalog? cleared all caches? Perhaps try to run the code with all caches disabled.

  • I use the line in a script to modify some product data. Yes, everything was reindexed, caches cleared. Aug 14, 2014 at 19:18
  • In a custom module? or existing page? what's the scope of the code? frontend/backend? Aug 14, 2014 at 19:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.