Skip to main content
2 of 3
edited body; edited tags; edited title
sv3n
  • 11.7k
  • 7
  • 41
  • 73

Get product FINAL price without loading entire product

I can get product attributes efficiently without loading the entire product by using:

Mage::getResourceModel('catalog/product')->getAttributeRawValue($productId, 'attribute_code', $storeId);

However, I can only do this with the pric' attribute, since final_price is technically not an attribute. Since I'm grabbing a few hundred products on one page load, and the only data I need is the product's final price, doing this is very inefficient:

foreach($productIds as $productId) {
    $finalPrice = Mage::getModel('catalog/product')->load($productId)->getFinalPrice();
    ....
}

Since I'm loading the entire product. If anybody can suggest a more efficient way, I would really appreciate it. Cheers!