cancel
Showing results for 
Search instead for 
Did you mean: 

Product missing on Backend

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Product missing on Backend

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.

5 REPLIES 5

Re: Product missing on Backend

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

----
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution" as appropriate. Thanks!

Re: Product missing on Backend

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.

If Issue Solved, Click Kudos/Accept As solutions. Get Magento insight from
Magento 2 Blogs/Tutorial

Re: Product missing on Backend

Hi,

 

Thanks for the reply.

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

 

Please let me know.

 

Thanks

Re: Product missing on Backend

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.

m1.png

If Issue Solved, Click Kudos/Accept As solutions. Get Magento insight from
Magento 2 Blogs/Tutorial

Re: Product missing on Backend

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.