Magento

Goal: getting advanced search to work with configurable products after import
---------------------------------------------------------------------------

After importing a load of products, the advanced search only finds the simple products, not the configurable ...

There is a checkbox in the admin -> System -> cache management called “Refresh Layered Navigation Indices” which seems to fix the problem, but with the amount of products we have the web interface takes literally at least 5 hours to refresh (and I don’t know how to check to see if it has finished properly or timed out), so I wanted to write a command line app to whiz through them.

Here is what I have done so far:

- Import products
- do an advanced search for say all products available in Black, only simple products returned
- Make a note of the number of rows in all tables in the DB
- I run the admin script for only a few seconds before killing it
- The same advanced search (refresh browser window) returns some configurable products
- I compare the number of rows in each table, the “Refresh Layered Navigation Indices”, only catalogindex_eav has increased
- use the DB docs to figure out the fields, I believe it works out as this:

catalogindex_eav.entity_id = catalog_product_entity.entity_id
catalogindex_eav.store_id = core_store.store_id
catalogindex_eav.attribute_id = eav_attribute.attribute_id

- so I wrote a command line script that can do in 3 minutes what it takes the web side to do in 3 hours

There is obviously a big BUT! It doesn’t work! now the question is, do I have the structure wrong, the data wrong, or is the admin script doing something extra?

Refreshing the caches didn’t work

any ideas? thanks

I also need an answer to this question.

Need a solution to this problem as well

*Bump* Anyone have a faster way to Refresh Layered Navigation Indices?

Or a way to trigger it via cronjob would be nice. . . thoughts?

Any one know why Layered Navigation refresh take so long to finish?
This is a problem for those who have over 5k+ products.

No solutions yet? this is quite the problem I would think. Unless there aren’t many experiencing this issue for some reason.

Out of curiosity, how many products are we talking about here? 5 hours seems very excessive. Do you have 20,000+ products?

We currently have about 20,000 products online

I’m running into the same problem with about 10k items. I’d be interested to see if any progress was made dealing with the database directly.

same here, with “only “ 3000 products.

We have same problem with 1K products at 1.1.6. We have added new products but layered navigation index can’t be refreshed. We still see same old index even cache manager says that index was refreshed.

same problem here.
hosted on simplehelix (400 products. 50 categories)

We have just found that our bug was caused by other reason. We imported products using Magento Data Flow into “admin” store. Also all filterable attributes where global but we were not able to see new indexes. So we fixed this bug importing same products using Data Flow directly into the store using “store code” in cvs file.

Just a bump to see if any progress has been made.

TemplateMaster: Do you use more than one store? If so, did you do a separate import for each store?

jeff.d - 17 October 2008 01:34 PM

TemplateMaster: Do you use more than one store? If so, did you do a separate import for each store?

We used one store but after that bug we created second empty store so we can see dropdown store menu. We were able to see that import was not completed in right way and we imported again same data but with store code. Strange thing that all this filterable values have “Global” value.