Magento - Sort by Price Issue - Magento 1.3.0 Upgrade Issues - eCommerce Software for Growth

Log In

Username or Email

Password:

Forgot Password

or
Register

Skip to site navigation »
Skip to main content »
Skip to footer content »

Magento Forum

Sort by Price Issue

GuyGadbois Total Posts: 10 Joined: 2008-12-04 Ignore user	Anyone else have problem with sort by price in product catalog after upgrading to 1.3.0? Had problems with this before but thought this issue was resolved.
	Posted: April 1 2009 \| top

GuyGadbois Total Posts: 10 Joined: 2008-12-04 Ignore user	I suspect this has to do with the Layered Navigation Indices issue since everything works on my local test environment. Sort by price seems to be completely random, I think catalogindex_price and catalogindex_minimal_price needs to be updated in the db and the Layered Navigation Indices script crashes on shared hosts since the script takes too long to run… Read about this issue somewhere. Can’t see any other difference between local installation and production site.
	Posted: April 1 2009 \| top \| # 1

GuyGadbois Total Posts: 10 Joined: 2008-12-04 Ignore user	Yes, that was the problem. Semi-manually updating Layered Navigation Indices by calling plainReindex for each product entity in a PHP loop solved the sort by price issue. I guess i need to convince my host to extend allowed maximum execution time or switch to a VPS.
	Posted: April 1 2009 \| top \| # 2

proteinshake Total Posts: 42 Joined: 2008-05-12 Ignore user	I am having this issue as well. It seems when I update a product, it gets bumped to the bottom of the page. Can you explain a little more detailed on how to fix this issue?
	Posted: April 1 2009 \| top \| # 3

proteinshake Total Posts: 42 Joined: 2008-05-12 Ignore user	Nevermind I fixed this by simply refreshing the Layered Navigation Indices under cache managment
	Posted: April 1 2009 \| top \| # 4

GuyGadbois Total Posts: 10 Joined: 2008-12-04 Ignore user	Yes, sorry… I was not explaining well. The problem I had was that since I’m using a shared host the script crashes with “maximum execution time exceeded”.
	Posted: April 1 2009 \| top \| # 5

john-michael Total Posts: 22 Joined: 2009-03-05 Ignore user	I’m having a related issue. Prior to the upgrade I was running ver.1.2.1.2 I had a custom sort option (newest) which I created via: app\code\local\Mage\Catalog\Block\Product\List\Toolbar.php `$this->_availableOrder = array( 'entity_id' => $this->__('Newest'), 'name' => $this->__('Name'), 'price' => $this->__('Price') );` After upgrading to ver.1.3 the applied custom sort option doesn’t appear. I have a never seen option of “Position”. I took a look at the core file of ver1.2.1.2 and compared it to ver1.3 and here is the difference: ver1.2.1.2 app\code\core\Mage\Catalog\Block\Product\List\Toolbar.php `$this->_availableOrder = array( 'position' => $this->__('Best Value'), 'name' => $this->__('Name'), 'price' => $this->__('Price') );` ver1.3 app\code\core\Mage\Catalog\Block\Product\List\Toolbar.php `$this->_orderField = Mage::getStoreConfig( Mage_Catalog_Model_Config::XML_PATH_LIST_DEFAULT_SORT_BY );` I’m not entirely sure what is going on, but my guess is that magento no longer uses the custom option app\code\local\Mage\Catalog\Block\Product\List\Toolbar.php and now requires the user to define the sort by names/order in the XML_PATH_LIST_DEFAULT_SORT_BY. Can anyone confirm/deny this and also shed some light on where to find XML_PATH_LIST_DEFAULT_SORT_BY? Thanks. Signature JM. Blacklisted Cards Real Job Descriptions Funny Ass Blog
	Posted: April 9 2009 \| top \| # 6

john-michael Total Posts: 22 Joined: 2009-03-05 Ignore user	Threads that answer my question: http://www.magentocommerce.com/boards/viewthread/37333/ http://www.magentocommerce.com/boards/viewthread/37324/ http://www.magentocommerce.com/boards/viewthread/37402/ Signature JM. Blacklisted Cards Real Job Descriptions Funny Ass Blog
	Posted: April 9 2009 \| top \| # 7

deggertsen Total Posts: 30 Joined: 2008-12-17 Utah Ignore user	GuyGadbois - 01 April 2009 10:09 AM Semi-manually updating Layered Navigation Indices by calling plainReindex for each product entity in a PHP loop solved the sort by price issue. I guess i need to convince my host to extend allowed maximum execution time or switch to a VPS. How did you manually update the Layered Navigation Indices? Can you give more details on how you did this? I suspect that I have the same problem with the max execution time, however I increased it on the server to 3000 and it still isn’t working properly. If you could explain in detail how you manually updated that would be very helpful. Thanks.
	Posted: June 24 2009 \| top \| # 8

GuyGadbois Total Posts: 10 Joined: 2008-12-04 Ignore user	deggertsen - 24 June 2009 01:24 PM GuyGadbois - 01 April 2009 10:09 AM Semi-manually updating Layered Navigation Indices by calling plainReindex for each product entity in a PHP loop solved the sort by price issue. I guess i need to convince my host to extend allowed maximum execution time or switch to a VPS. How did you manually update the Layered Navigation Indices? Can you give more details on how you did this? I suspect that I have the same problem with the max execution time, however I increased it on the server to 3000 and it still isn’t working properly. If you could explain in detail how you manually updated that would be very helpful. Thanks. I did something similar to this: http://chrismckee.co.uk/magento-commerce-layered-navigation-cache-error-part-deux/ It probably works better than what I did, I had to run my script more or less every day so it was a major headache. Also, make sure that max execution time is set to 3000 when calling phpinfo, in our case the host didn’t allow that setting to be overwritten. We eventually decided to switch to a VPS.
	Posted: June 24 2009 \| top \| # 9

ChrisMK Total Posts: 28 Joined: 2008-12-22 Manchester UK Ignore user	http://chrismckee.co.uk/magento-commerce-layered-navigation-cache-error-part-deux/ The trick is to run the process whilst monitoring the memory usage (hence the script output in bash (SSH) ) To work out at which point you should restart. Your essentially limited by PHP’s set memory limit; and the fact MAGE+ZEND crammed together leaks like a sieve. Signature --------------------------------------------- chrismckee.co.uk
	Posted: July 9 2009 \| top \| # 10

ChrisMK Total Posts: 28 Joined: 2008-12-22 Manchester UK Ignore user	-> Layered Navigation Fix http://chrismckee.co.uk/magento-commerce-layered-navigation-cache-error-part-badger-part-duck/ I’ve recently Updated it, Now a Browser version and a PHP-CLI Version (aka SSH runnable) that will let you run the layered navigation refresh in chunks. Please lot all issues on the post in the comments section. Signature --------------------------------------------- chrismckee.co.uk
	Posted: July 24 2009 \| top \| # 11

Rickc Total Posts: 16 Joined: 2008-09-18 Canada Ignore user	proteinshake - 01 April 2009 12:21 PM Nevermind I fixed this by simply refreshing the Layered Navigation Indices under cache managment thanks for mentioning it! I have the “magento absolute” theme installed and the items i have selected as “featured” to display on home page were not sorting by price properly until i tried your step of refreshing Layered Navigation Indices in Cache Management…
	Posted: October 30 2009 \| top \| # 12

Magento Community

Magento Community

Back to top

There has been an error processing your request.

1.3 upgrade SQL error