Magento

My issue is that the Price Sort and Advanced Search are not working.  This has been discussed in other threads, but not for Magento ver. 1.3.2.3.  The code is different so the fixes do not apply.  The Position Sort and Name Sort and Search both function.

I looked at my database and discovered that the catalogindex_price table is empty, unlike functioning older versions of Magento.  How can I get the data in the fields?  I am also unable to rebuild the search index even if I delete the var/cache files and refresh the cache.

I solved it in admin (System->Cache Management->Layered Navigation Indices->Refresh now)

Had the exact same problem. In our case, the solution above was the fix . Thanks!

This solution also worked for me! Thank you.

The above solution did not work for me, however what worked for me was:

On the same place as in the description above click Search Index: Rebuild

This was what solved the problem for me.
Thanks for the hint to the cache!

I’m still having this problem - no refreshing cache nor rebuilding of indices helped. Price and price alone not working for search, advance search, sort, nor layered nav filters (all my other searches and sorts function).

Any other suggestions?

I solved it in admin (System->Cache Management->Layered Navigation Indices->Refresh now)
Thanks for the posts

When you try
(System->Cache Management->Layered Navigation Indices->Refresh now)

Serwer show error 500

When I try
(System->Cache Management->Layered Navigation Indices->Refresh now)

Serwer show error 500

Same issue here on two seperate sites
On one site I get an error when trying to refresh the other tries to load for about 2 minutes then goes to a blank white screen

I can’t sort by price or use advanced search

I had the same problem: couldn’t sort by price ascending or descending. I tried the fix for System --> Cache Management --> Refresh Layered Navigation Indices, and after 30 seconds I received this error message:

“Fatal error: Maximum execution time of 30 seconds exceeded in /home/edigital/public_html/lib/Zend/Db/Select.php on line 848”

I’m not really sure if that’s some kind of programming error or what, but the solution DID fix my “sort by price” problem. Thanks!

This is a strange error.  I am having the sort by price issue.  I rebuilt the search index.  It worked....momentarily.  Just long enough for me to check the prices and url several times, write my boss and notified them I fixed it.  Turned around and it was a complete mess again.

Has anyone experienced this??  What breaks it?  Thank you for the information thus far, it was helpful.

Anyone found a resolution for this on 1.4.0.1 stable? The above option is not there in Cache Management any longer.

Hi,

I have added may custom attributes but some of them are not working in Advance search. I am looking for it solution is any body have an idea please replay.

I tried re indexing and clearing cache options not worked for me.

Thank you.

Hi,

I found solution for my problem. My problem was occurred because i imported my local database at live.

Due to import the tables that have first Id zero was set to its highest id not to zero. This happens in “customer_group”, “core_store”, “core_store_group” and “core_website” tables.

to solve this problem in “customer_group” table set the “Not Logged In” rows id to zero and update the “catalog_product_index_price” tables “customer_group_id” value with zero where the rows are with the newly generated id.

Then do re indexing of “Catalog Search Index” from index management.

Its worked for me. Please give you response if helps to any one.

Thank you.

THANK YOU! I had a store for months that was not upgraded and still had this problem. This worked for me.