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