I recently added a large volume of products to Magento, however when I then began looking through the product listing, it was acting in a really strange way.
All products were displaying correctly however the order was all wrong. Instead of being ordered or sorted by price by default as they should of been, the order was all over the place.
After a bit of searching I eventually found the problem is in the Magento cache system and specifically in the Layered Navigation indexes.
Logging in as admin and using the “System->Cache Management->Layered Navigation Indices->Refresh now” option resolved the issue. However this process took a long time to complete on my server, so some patience may be required.
Thanks for the solution, this worked for me (1.3.2.3). The price sorting gets reset to alphabetized sorting every time I delete an item or add one.
Comment by Natalie — December 23, 2009 @ 1:18 pm
Hi Allan,
Wow, thank you sooooo much! You just saved me a ton of headache. I’ve searched all over the web for the answer that would help me solve this problem, and this is the one that got it all fixed!
Thanks so much again!
Thea
Comment by Thea — February 13, 2010 @ 11:25 pm
[...] allanbrown.me Posted in Magento [...]
Pingback by Sort by Price not work in Magento — April 17, 2010 @ 6:29 am
Thanks to you I quickly resolved this issue.
Tim
Comment by Tim De Vits — June 7, 2010 @ 6:31 pm