cancel
Showing results for 
Search instead for 
Did you mean: 

Product missing on Backend

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.