I currently have 2 stores running in 1 instance of Magento 1.1.6. I have imported a few hundred products so far into 1 of the stores (I specified the particular store & website as columns in my import file). The products themselves appear to have imported just fine. All the fields are correct and the products appear on the storefront.
The problem I’m having is that the products don’t appear if I do an advanced search using one of the dropdown product attributes that I added. For example, I have a dropdown attribute called “sport” in the Advanced Search page where a shopper can choose which sport they are interested in (ie. Baseball, Football, etc). When they choose a sport from the dropdown box (leaving all other search fields blank) and click Search, there are no results found although many such products exist in the catalog. When I go into the catalog via the Magento admin panel to check the products, they all have the correct value for the Sport attribute.
After staring at the database for a while, the problem appears to be that after an import finishes, no records are inserted into my catalogindex_eav table. So basically downdown product attributes aren’t getting indexed since they are supposed to be stored in this table, from what I can gather. I have some other varchar product attributes which produce search results correctly. If I manually insert a record into this DB table, everything works fine, but I’m not going to manually insert thousands of records into this table
So as it stands right now, my catalogindex_eav table is ALWAYS empty (as are my catalogindex_minimal_price and catalogindex_price tables). I suppose I could write my own script to populate these tables after doing an import, but I’d rather not have to do that since this is a feature that is supposed to work out of the box in Magento and I’m probably just doing something wrong
There are a couple other things I’ve discovered.
1) The problem only exists for products I import into Magento. If I create the product via the Magento admin interface, no problem!
2) The problem only exists on my hosting environment (Crucial Web Hosting), not on my local dev environment. So it must be something to do with the differences in my Magento configuration or hosting setup (although I can’t find anything that might be causing this).
3) After importing a product, if I edit it via the Magento admin interface and save it (without making any changes), then search works fine. However, if I import that same product again afterwards, it deletes the record from catalogindex_eav and the problem comes back again.
I’d greatly appreciate any help from you guys & gals!