Magento 1.7 Product Collection – Wrong Price When Products Are Loaded from Collection

magento-1.7priceproduct-collection

I have a Magento site with several stores. Each store displays products in different currency. I'm trying to load products from one of the stores using product collection.

$_col = Mage::getModel('catalog/product')->getCollection();
$_col->addAttributeToSelect('*');
$_col->addIdFilter($product_ids_to_be_loaded);
$_col->setStoreId($store_id);
$_col->addFinalPrice();

Unfortunately when I try to 'display' the price using:

for($_col as $p) {
    echo $this->getPriceHtml($p, true);
}

it displays wrong price (I assume it's price in default currency).

When I load products using:

$model = Mage::getModel('catalog/product');
for($_col as $p) {
    $p = $model->load($_product->getId());
    echo $this->getPriceHtml($p, true);
}

it works fine. How come? What am I doing wrong?

Best Answer

I use the following which works well:

$collection = Mage::getResourceModel('catalog/product_collection');
$collection ->addMinimalPrice()
            ->addFinalPrice()
            ->addTaxPercents();

Try it without the store id filter, then with it.

Magento has also got the following method which can be used as filter:

public function addPriceData($customerGroupId = null, $websiteId = null)

Related Solutions

Magento 1.8 – Fixing Incorrect Values from getPriceHTML in Random Product Collection

Please take a look at the two implementations for getPriceHtml()

Mage_Catalog_Block_Product

public function getPriceHtml($product)
{
    $this->setTemplate('catalog/product/price.phtml');
    $this->setProduct($product);
    return $this->toHtml();
}

vs.

Mage_Catalog_Block_Product_Abstract

public function getPriceHtml($product, $displayMinimalPrice = false, $idSuffix = '')
{
    return $this->_preparePriceRenderer($product->getTypeId())
        ->setProduct($product)
        ->setDisplayMinimalPrice($displayMinimalPrice)
        ->setIdSuffix($idSuffix)
        ->toHtml();
}

extending from the Abstract block should help in getting the correct renderer.

Grouped Products – How to Check if a Product Has a Tier Price

To check the tier price of any product, you can use the following code in the conditions :

<?php
$tierprices = array();
if ($_product->getTypeId() == 'grouped'){
    $associatedProducts = $_product->getTypeInstance(true)->getAssociatedProducts($_product);
    foreach ($associatedProducts as $assoc_product) {
    //$assoc_product = Mage::getModel('catalog/product')->load($assoc_product->getId());// use this only if necessary
        if($assoc_product->getTierPrice()){
            $product_tier_prices = $this->getTierPrices($assoc_product);
            if(count($product_tier_prices) > 0){
                $product_tier_prices = (object)$product_tier_prices;
                foreach($product_tier_prices as $key=>$value){
                    $value = (object)$value;
                    $tierprices[] = $value->price;
                }
            }
        }  
    }
} ?>

In this way you will get tier prices of all the associated products of Group product. You need to use the following condition to display "minimum tier" or "as low as":

<?php if(count($tierprices) > 0){ ?>
    <span class="price" id="product-minimal-price-<?php echo $_id ?><?php echo $this->getIdSuffix() ?>">
        <?php echo $_coreHelper->currency(min($tierprices), true, false) ?>
    </span>

<?php } else { ?>
all your rest of normal price will come here.
<?php } ?>

Note: The code was not tested.

Best Answer

Related Solutions

Magento 1.8 – Fixing Incorrect Values from getPriceHTML in Random Product Collection

Grouped Products – How to Check if a Product Has a Tier Price

Related Topic