Our client is a eCommerce store which has catalog of about 100,000 products. The store is based on Magento and uses MySql as RDBMS. The store was using full text and LIKE to find matching products. For attribute filters GROUP BY sql queries were being used which was putting a lot of load on servers and causing a performance degrade. Despite putting so much resources into search the search results were inaccurate.
Client reached to us for help in improving the search results and speed of the search. We recommended Solr 6 to be used as search tool. Our team designed and implemented the Solr part and the client’s development team integrated it into Magento.
Once Solr was integrated for search the improvements were immediately visible. The accuracy improved along with the performance of search. Solr facets made it easy to provide attribute and category based navigation with ease. We also implemented synonyms to improve the results further and reduced zero results pages.
The final out come of this project were accurate search results, increased conversions and increased revenue for customer. You can see the search in action here.