- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Magento 2 Blogs/Tutorial
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Magento 2 Blogs/Tutorial
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.