Catalog search returns empty when searching a product name containing numbers and characters
I have product names like ' 8" X 6" cards ' they contain measurements i.e. numbers and characters. when I try to search these products on the frontend. the Ajax search returns the product fine and product with that name is displayed in the dropdown but when I try to search it with Mysql search gives "Your search returned no results.". Is there a way to make products with these type of names searchable.
I have created some products with this kind of names and tested at my end. I don't have any issue with this kind of products. Until the product visibility is set to 'catalog' only.
So, think you have same configuration for the products in your admin. Go to admin panel and edit these products. Check if the visibility of products is set to 'catalog' change it to 'catalog, Search'. And it will work for you.
-- If my answer is useful, pleaseAccept as Solution & give Kudos