Magento – Products (seemingly) randomly disappearing until reindex

ce-1.4.1.1indexingproductproducts-management

Curious question, one of my clients keeps noticing that randomly* individual products will disappear from the front end store view.

* Obviously, I know it isn't random, there must be something triggering it, but there is no common event that is immediately obvious.

I've read this question, however this deals with issues during reindex.

Theres 2 things that we've found we can do to bring the products back into the front end;

  • Simply go into the product and save it
  • Or run a reindex of the product & catalog related indexes

Has anyone run into anything similar before?

The site is fairly high traffic, but has only around 2000 products and 2 store views (only 1 accessible to the public) running 1.4.1.1

Best Answer

There's a really good chance that purchases are triggering a re-index that just never completes.

A quick fix

Try setting your indexes to "Manual Update" rather than "Update on Save" and see if it helps things as you progress.

Diagnosis

Diagnosis of the issue would be a case of looking at what products are missing, then looking at the respective index tables in the DB to identify where it is missing from.

Then observe/log when that index is being triggered/run and when - then backtrace from there.


There will be no 1 right answer here, but if you diagnose properly, you'll find the reason.

Related Topic