Got an issue with displaying the products in frontend although they all can be seen in backend. Products also can't be searched but can be accessed via url e.g. example.com/catalog/product/view/id/111769 so the product page works.

Things I've done so far:

  • Cleared Cached
  • Re-indexed everything
  • Remove/Re-added products to the same category
  • Removed/Reimported the products
  • Made sure the products are enabled
  • Made sure the items are in stock
  • Made sure the inventory qty is more than 0
  • Made sure the product visibility is set to "Catalog, Search"
  • Made sure the products are assigned to website
  • Disabled all custom modules
  • Changed the custom theme to luma
  • Upgraded Magento to 2.3.1
  • Looked through magento, apache, mysql logs

Do you have an idea what the problem could be or what else could I try?

Update 15.05:

Figured out that records in catalog_product_index_eav are not being generated and when I add the product record there manually it shows up in frontend.

Does someone has any idea how I could fix this?

  • i know you have checked he stock status but have you set the inventory qty to more than 0 May 14, 2019 at 15:31
  • yeah, checked that too, I'll add it to the list, thanks
    – abcd
    May 14, 2019 at 15:35
  • is your instance in production or development? if production please switch so gives out errors. May 14, 2019 at 15:37
  • it's in developer mode
    – abcd
    May 14, 2019 at 15:39
  • Have you checked the category permissions that come as part of the Magento2 B2B module?
    – mlunt
    May 14, 2019 at 19:46

1 Answer 1


The issue was in the search index tables and there's an easy solution:
Magento admin -> Configuration -> Catalog -> Catalog Search
- in Search Engine select, choose Mysql option and save
- refresh cache
- reindex, products should be there

Thanks to everyone who tried to help :)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.