Product missing on Backend

[gkarthick87]

Hi,

i have imported around 25000 products when I check in 'catalog_product_entity' table it's showing all but 'catalog_product_flat' table showing around 24000 products.. some random products are not inserted on flat table.

What could be the reason behind of this?

Please let me know.

[Tom Robertshaw]

Products that are disabled, or not visible individually will not be in the flat product table. 

[Rakesh Jesadiya]

Flat Products only contains active products and flat products reside under 'catalog_product_flat' table so you cant get disable products or Indivisually invisible products collection in 'catalog_product_flat' table.

[gkarthick87]

Hi,

Thanks for the reply.

How do we know that those products are disable products or individually invisible products?

Please let me know.

Thanks

[Rakesh Jesadiya]

You need to login with backend of your magento,

Just go to Catalog -> Manage Product

Now you can see product grid,

You can see status of Product like Enable or disable.

[gkarthick87]

Hi,

It's not showing on the Grid. Whereas, product count is showing without those products.
When, I check the status for those products on Database it showing 2(Disabled) but not coming to backend. Even if its Disabled it should show on Backend but nothing is coming.