Catalog search returns empty when searching a newly added product

[kvnwong0gm7474]

I have inserted new products and put under the category "simple". But when I tried to search "simple" it will just return "Your search returned no results." Any idea how I can resolved this?

The product actually exist as I tried to reach it directly by the url link and it works. Just seems to be missing from the search.

[Bhanu Periwal]

Hi @kvnwong0gm7474 

Please check following points:

1. Product is set to enabled under status
2. Product is set to catalog (and search) under visibilty
3. Product has qty (in stock) and set to in stock
4. Product is attached to a category
5. Then run a "Empty cache" and a re-index.

php bin/magento indexer:reindex
php bin/magento cache:flush

It may help you to resolve issue.
If issue resolve, please click on 'Kudos' & Accept as Solution!

[kvnwong0gm7474]

@Bhanu Periwal I did everything as followed. The issue seems to still persist.
Hmm could it be something else? I checked the query that it runs, seems to limit to the first 100 products only to index into the catalogsearch_fulltext_scope table

[Manish Mittal · Accepted solution]

@kvnwong0gm7474 

Please check your elastic search connection Magento admin> store>configuration > catalog > catalog search and check elastic search connection is fine or not. It might be the issue.

[kvnwong0gm7474]

@Manish Mittal upon checking, seems like I am not using elastic search. I am using MySQL search. Any idea what could affect this?

[Manthan Dave]

Hi @kvnwong0gm7474 

I understand that you are not using elastic search and using only the MySQL search of the Magento.

As you mentioned that you have created the products and that product you have added into the category name called "Simple", So here you are searching by category name, not by-products name.

So I would suggest you enter the product name in the search and then check it will return your products in the search results. (Ex: your product name is "ABC" then search for ABC) it will showcase your products into the search results.

Also don't forgot to run indexer and cache clean command after saving all your products/categories.

I hope it helps! 

[Manish Mittal]

@kvnwong0gm7474 

Is this product showing in listing product?

[Sagar P Panchal]

---

@kvnwong0gm7474 wrote:

@Manish Mittal upon checking, seems like I am not using elastic search. I am using MySQL search. Any idea what could affect this?

---

Might possible you have missed to execute indexer command

[kvnwong0gm7474]

Hi @Manthan Dave,

I have tried searching for exact product name and it still showing "no results".

Reindexed and cache cleaned, still getting "no results".

[kvnwong0gm7474]

@Manish Mittal 

Unfortunately, it does seems to appear there either. But it does appear at the storefront when I featured it. Any idea what might caused it?