Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 3 of 3
Sort by price broken after Magento Connect upgrade to 1.2.0.1
 
shmk
Sr. Member
 
Total Posts:  297
Joined:  2009-10-28
 

I’ve tried last fix.

Now the price is sorted correctly also for guests of the site (not logged in users),
BUT the price still not visible in the layered navigation column (is not filtrable) for guests (while is visible to logged in users).

 
Magento Community Magento Community
Magento Community
Magento Community
 
shmk
Sr. Member
 
Total Posts:  297
Joined:  2009-10-28
 
shmk - 25 January 2010 06:20 AM

I’ve tried last fix.

Now the price is sorted correctly also for guests of the site (not logged in users),
BUT the price still not visible in the layered navigation column (is not filtrable) for guests (while is visible to logged in users).

Anyone know where the layered navigation is made by the system?

If I could find where it is, maybe it could be created a bugfix similar to the one that fixed the sorting for the not logged in users.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Rameez
Jr. Member
 
Total Posts:  21
Joined:  2010-01-26
 

Hi Guys,

If Layered Navigation Indices rebuilding doesn’t work then why not try the following:

App\code\core\mage\catalog\model\resource\eav\mysql4\product\collection.php line:1155
change this:

$this->getSelect()->joinLeft(
array(’_price_order_table’=>$this->getTable(’catalogindex/price’)),
“{$entityCondition} AND {$storeCondition} AND {$groupCondition} AND {$attributeCondition}”,
array()
);
to:

$this->getSelect()->joinLeft(
array(’_price_order_table’=>$this->getTable(’catalogindex/price’)),
“{$entityCondition} AND {$storeCondition} AND {$attributeCondition}”,
array()
);
This resolved all the problems with the price sorting for me.

Regards,
Roland

HI...... THIS WORKS GREAT FOR ME… YOUR POST SOLVE MY PROBLEM.... MILLIONS OF THANKS to YOU RON..
GOOD ON YOU MATE.....

 
Magento Community Magento Community
Magento Community
Magento Community
 
oakstreetman
Jr. Member
 
Total Posts:  6
Joined:  2010-04-28
 
miromedia - 22 January 2010 03:12 AM

Hi Guys,

If Layered Navigation Indices rebuilding doesn’t work then why not try the following:

App\code\core\mage\catalog\model\resource\eav\mysql4\product\collection.php line:1155

<code change>

This resolved all the problems with the price sorting for me.

Regards,
Roland

Worked perfectly for me on 1.3.2.4! Thanks for your help!

 
Magento Community Magento Community
Magento Community
Magento Community
 
maryjspiegel
Jr. Member
 
Total Posts:  1
Joined:  2011-02-15
 

I am new here and read this article and agree with this article.
Resvibrant

 
Magento Community Magento Community
Magento Community
Magento Community
 
developerindia
Member
 
Total Posts:  58
Joined:  2009-06-25
 
miromedia - 22 January 2010 03:12 AM

Hi Guys,

If Layered Navigation Indices rebuilding doesn’t work then why not try the following:

App\code\core\mage\catalog\model\resource\eav\mysql4\product\collection.php line:1155

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

to:

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

This resolved all the problems with the price sorting for me.

Regards,
Roland
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 3 of 3