cancel
Showing results for 
Search instead for 
Did you mean: 

We can't find products matching the selection.

We can't find products matching the selection.

Hello,

 

I added a product in a freshly installed Magento 2.1.6 I've tried many ways to solve the problem making sure the product Visibility, Status, Qty, Manage stock, stock availability and categories also I flush the cache and reindex but is still not working

 

Please advise

 

Thanks  

2 REPLIES

Re: We can't find products matching the selection.

have you checked website?

Re: We can't find products matching the selection.

Check if you have data in the following tables:

 

catalog_product_index_price

catalog_category_product_index

 

And 

catalogsearch_fulltext_scope*store_id*

 

The last one is only if you are not using an external search service, for example in Magento EE you can use Solr or Elastic Search.

 

Otherwise make sure your MySQL user can create temporary tables but I think you would get another error if this wasn't the case.