David Ansermot Web Developer / TYPO3 Integrator

Magento : Product price list sort bug

A Magento bug exists on 1.3.xx (and maybe 1.4) on the product list.

When you want to sort the products by price, it does’t works.
To fix this, here’s the way :

Open the file : app/code/core/mage/catalog/model/resource/eav/mysql4/product/collection.php
Go to line 1156 – 1158

It should looks like

 $this->getSelect()->joinLeft(
                    array('_price_order_table'=>$this->getTable('catalogindex/price')),
                    "{$entityCondition} AND {$storeCondition} AND {$groupCondition} AND {$attributeCondition}",

Remove the “AND {$groupCondition}”.
Save then test.

Now the sort works logged in and out

Posts that maybe you want to read ::

• Magento – Actives CMS pages dynamic menu
• Magento : Undefined index after restore/moving site
• Magento : Add sorting condition