Magento 1.9 – Get Min and Max Price with Special Price in Product

catalogconfigurable-productproduct

We need min. and max. price from specific category products,

we have tried this query,

$productColl_1 = Mage::getModel('catalog/product')->getCollection()
                        ->addCategoryFilter($categoryModel)
                        ->addAttributeToSort('final_price', 'desc')
                        ->setPageSize(1)
                        ->load();
         echo $max_price = $productColl_1->getFirstItem()->getPrice();

Issue is in this its giving only base on base price but not considering special price for getting minimum price.

Best Answer

Try this:

<?php
  $productColl_1 = Mage::getModel('catalog/product')->getCollection()
    ->addCategoryFilter($categoryModel)
    ->addAttributeToSort('price', 'desc')
    ->setPageSize(1)
    ->load();

    echo $maxPrice = $productColl_1->getFirstItem()->getPrice();
    echo $minPrice = $productColl_1->getFirstItem()->getMinimalPrice();
         //OR
    echo $minPrice = $productColl_1->getFirstItem()->getSpecialPrice();
?>

Related Solutions

Magento – Get the lowest and highest possible price for a configurable product

Try this approach. use the config array that the attribute dropdowns use to change the price of the configurable product. Let's assume that $productId is the ID of the configurable product.

$product = Mage::getModel('catalog/product')->load($productId);
$block = Mage::app()->getLayout()->createBlock('catalog/product_view_type_configurable');
$block->setProduct($product);
$config = json_decode($block->getJsonConfig(), true);
$basePrice = $config['basePrice'];
$min = null;
$max = null;
foreach ($config['attributes'] as $aId=>$aValues){
    foreach ($aValues['options'] as $key=>$value){
        if (is_null($min) || $min>$value['price']){
            $min = $value['price'];
        }
        if (is_null($max) || $max<$value['price']){
            $max = $value['price'];
        }
    }
}
//until here we have the min and max price differences. Now just add the base price.
$min += $basePrice;
$max += $basePrice;

Magento 1.9 – Select All Products with Special Price

For Magento 1.9. Here 76 is attribute_id for special_price attribute.

select cpe.sku,cpe.type_id, cped.store_id, cped.value from catalog_product_entity_decimal cped
RIGHT OUTER JOIN catalog_product_entity cpe on cpe.entity_id = cped.entity_id 
where cped.attribute_id=76
order by cpe.type_id

Best Answer

Related Solutions

Magento – Get the lowest and highest possible price for a configurable product

Magento 1.9 – Select All Products with Special Price

Related Topic