I just uploaded around 2000 products to a magento store through dataflow. And it was pointed out that the Search function was not showing up the new products. If i go into each product individually and hit save it works not sure whats wrong. I tried searching here already haven’t seen anyone else with similar problem. Has anyone experienced this?
My problem is coming from the table ‘catalog_product_website’ which is not updated, with dataflow import or SOAP products creation.
I didn’t find a “correct” manner to fix it, so I’m dynamically inserting rows into the table.
I will be happy if someone can teach me the right way to proceed !
I am having the same problem on Magento 126.96.36.199. I used DataFlow to import products and now they do not show in search. Rebuilding search index does nothing. I have to go and manually re-save each product to make it show in search.
Can any one suggest smarter way to fix it??
I am using Import feature of Store Manager for Magento and I have the same issue. You can resolve this issue by running the Rebuilds in Magento>>Admin>>Cache page. You will need to run refresh Layered Navigation Indices first and then run the Search Index rebuild next (in that order). I import products daily for one of my customers with a automatic script because the prices, quantity on hand and some description items can change daily. I am in the process of writing a PHP script that will conduct the search rebuilds automatically. I will post this script when I complete it and you can set it up as a cron job based on your needs.
I have tried to re-index in the order mentioned in this thread and also tried the cron job, however none of these methods are working. I imported all the products using the Data Flow feature. The only way that work so far is to re-save the products but I have way to many products to go through manually.
If anyone else has any ideas that I can try that would be great.