Maximum price display first collection

Question

I want to display Maxprice display first how to get that collection

$categoryIds = array(469);//category id
$products = Mage::getResourceModel('catalog/product_collection')
->addCategoryFilter(Mage::getModel('catalog/category')->load($categoryIds));
$Collection = Mage::getModel('catalog/product')->getCollection()->addFieldToFilter('entity_id', array('in' => $products->getAllIds()));;
$Collection->addAttributeToSelect(array(
                                   'image','small_image',
                                   'name',
                                   'short_description'
                   ))
->addFieldToFilter('visibility', array(
                               Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH,
                               Mage_Catalog_Model_Product_Visibility::VISIBILITY_IN_CATALOG
                   )) 


->joinField('qty',
             'cataloginventory/stock_item',
             'qty',
             'product_id=entity_id',
             '{{table}}.stock_id=1',
             'left')
 ->addAttributeToFilter('qty', array("gt" => 0))

->addFinalPrice()
->getSelect()
->where('price_index.final_price' < 'price_index.price')->Order('price_index.final_price', 'DESC');

Answer 1

try that

$categoryIds = array(469);//category id


      $products = Mage::getResourceModel('catalog/product_collection')
->addCategoryFilter(Mage::getModel('catalog/category')->load($categoryIds));
$Collection = Mage::getModel('catalog/product')->getCollection()->addFieldToFilter('entity_id', array('in' => $products->getAllIds()));;
$Collection->addAttributeToSelect(array(
                                   'image','small_image',
                                   'name',
                                   'short_description'
                   ))
->addFieldToFilter('visibility', array(
                               Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH,
                               Mage_Catalog_Model_Product_Visibility::VISIBILITY_IN_CATALOG
                   )) 


->joinField('qty',
             'cataloginventory/stock_item',
             'qty',
             'product_id=entity_id',
             '{{table}}.stock_id=1',
             'left')
 ->addAttributeToFilter('qty', array("gt" => 0))

->addFinalPrice()
->getSelect()
->where('price_index.final_price' < 'price_index.price');
$Collection->addAttributeToSort('price', 'desc');

Answer 2

In Magento,you can sort a product collection by addAttributeToSort().

If you want to sort product collection by final price,then Use getSelect()->order("price_index.final_price DESC") , as final_price is not an attribute.

Also, if you want to sort by price then you can use addAttributeToSort('price','DESC');