0

Magento Search Not Working. Search Result: Your search returns no results.

What I have already done.

  1. Visibility of the Product is set to Catalog, Search
  2. Product Attribute name, SKU, color is set to Yes in Quick Search and is Global.
  3. Tried with all Like,FullText,Combine in System->Catalog->Catalog Search.
  4. Cleared Cache and Reindexing done several times.
  5. Every Category including the root category is set to Yes is_anchor
  6. And Did most of the solution given on StackOverflow.

Currently Using Theme Zorka.

Result After I search for a Product or Sku

enter image description here

SQL Query -->

SELECT e.*, search_result.relevance, price_index.price, price_index.tax_class_id, price_index.final_price, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS minimal_price, price_index.min_price, price_index.max_price, price_index.tier_price, cat_index.position AS cat_index_position FROM catalog_product_entity AS e INNER JOIN catalogsearch_result AS search_result ON search_result.product_id=e.entity_id AND search_result.query_id='111' INNER JOIN catalog_product_index_price AS price_index ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN catalog_category_product_index AS cat_index ON cat_index.product_id=e.entity_id AND cat_index.store_id='19' AND cat_index.visibility IN(3, 4) AND cat_index.category_id = '2'

  • Your product is salable? stock ok? – Nolwennig Dec 5 '17 at 13:06
  • Yes the product appears on the site. Just the Search is not Working. Inventory is more than 50. Product is in Stock. – Utkarsh Joshi Dec 5 '17 at 13:24
  • Fine, nothing in var/log/*.log ? – Nolwennig Dec 5 '17 at 16:14
  • Flat tables enabled ? – Nolwennig Dec 5 '17 at 16:15
  • Done enabling the flat tables, reindexed , cleared cache, and got the same result. In log I debuged and got the query and fired using mysql but there were no result. Please Help – Utkarsh Joshi Dec 6 '17 at 5:44
0

I think there are many attributes have Use in Quick Search value Yes.

Please check and set value for Use in Quick Search to Yes only for Name, Sku and Description (if you want).

Set No for Use in Quick Search for all other attributes.

After doing so, do the reindexing and then check by searching again.

  • This seems already done – Nolwennig Dec 7 '17 at 14:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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