Magento Forum

   
Page 1 of 7
What does Refresh Layered Navigation Indices do? 
 
WebMonkey
Jr. Member
 
Total Posts:  27
Joined:  2008-06-05
 

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 smile
- 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 smile

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
Burton S.
Jr. Member
 
Avatar
Total Posts:  22
Joined:  2008-02-28
 

I also need an answer to this question.

 
Magento Community Magento Community
Magento Community
Magento Community
 
es5812
Jr. Member
 
Total Posts:  11
Joined:  2008-07-10
 

Need a solution to this problem as well

 
Magento Community Magento Community
Magento Community
Magento Community
 
es5812
Jr. Member
 
Total Posts:  11
Joined:  2008-07-10
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
finch8243
Sr. Member
 
Total Posts:  79
Joined:  2007-08-31
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
SimpleHelixcom
Enthusiast
 
Avatar
Total Posts:  906
Joined:  2007-08-31
Huntsville, AL
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
es5812
Jr. Member
 
Total Posts:  11
Joined:  2008-07-10
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
ylibrach
Sr. Member
 
Total Posts:  78
Joined:  2008-07-06
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
es5812
Jr. Member
 
Total Posts:  11
Joined:  2008-07-10
 

We currently have about 20,000 products online

 
Magento Community Magento Community
Magento Community
Magento Community
 
jeff.d
Sr. Member
 
Total Posts:  103
Joined:  2008-05-26
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
obione
Sr. Member
 
Avatar
Total Posts:  84
Joined:  2008-06-11
France
 

same here, with “only “ 3000 products.

confused

 
Magento Community Magento Community
Magento Community
Magento Community
 
TemplatesMaster
Guru
 
Avatar
Total Posts:  304
Joined:  2008-04-01
Switzerland
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
dracnet
Jr. Member
 
Total Posts:  17
Joined:  2008-03-14
Barcelona (Spain)
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
TemplatesMaster
Guru
 
Avatar
Total Posts:  304
Joined:  2008-04-01
Switzerland
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
jeff.d
Sr. Member
 
Total Posts:  103
Joined:  2008-05-26
 

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?

 
Magento Community Magento Community
Magento Community
Magento Community
 
TemplatesMaster
Guru
 
Avatar
Total Posts:  304
Joined:  2008-04-01
Switzerland
 
jeff.d - 17 October 2008 12: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.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
Page 1 of 7