I have a configurable product which is enabled, and visible in catalog, search. It has a child product which is also enabled, and in stock. But the product is not visible on the frontend.
I have found that this is because it is not in the flat table. Not does it appear in any of the index tables. What could cause a product it be ignored by magento like this?