FEATURE REQUEST: Improved Search

Provide search capability to match the phrase first then each word second in the results. For example, 'Nike Shoes' would return matches for 'nike shoes' first then 'nike' or 'shoes' underneath the more relevant results. This will provide the customer with more results to look through and increase the liklihood of the customer finding what he or she is looking for.

Singular versus plural - the search also needs to search both singular and plural versions of a term. For example, 'shoes' would also search for any products with the word 'shoe'

Hi Bruce,

Thanks a lot for suggestion. But not sure how it could be implemented. It could quite complex. Maybe, some SQL Server full-text experts could contribute such changes

breakskater wrote:

Hi,

We are working on the advanced search plugin for nopCommerce that you might like to see.

Lets take the same example of what you give.. instead taking a "adidas shoes".

nopAccelerate Advance Search Results for adidas shoes

- It's blazing fast even if its a full text search with appx. 80,000 products in demo store. It works just fine with even larger catalogs.
- It works exactly in the same way which you described.. "match the phrase first then each word second in the results"
- The term weight-age is completely configurable
- Advanced language analysis including stemming, singular, plural, fuzzy, synonym, etc. - although it needs to be configured as per store actual store requirements
- Results for singular - plural - ex: battries, battery should be treated as same... example here
- Treat different variations of words as same - advanced analysis using stemming- ex: treating stabilizing, stabilizer, stabilized as stabilize.
- Spell Check / Spell Suggest - offers correct term for wrongly spelled search term - example
- Offers sorting on search result page


Oh, sorry I forgot to mention that it offers you advanced facet filters on Search result page, which gives option to your site visitors to drill down search results by Category, Manufacturer, Spec. Filters & Attribute Filters. This actually helps site visitors to find the product easily in lesser time, which helps improve Conversion Ratio.

We would like to have your suggestions to improve it further (actually most of the features are added this way, and we added this plural-singular stemming analysis just two days back after a suggestion received from one of our client).

Thanks

This should be native to nopCommerce as searching the store is an integral part of any e-commerce solution. The better the search and filter capability the better the e-commerce platform. It makes sense to integrate a better search natively or risk the chance of losing customers looking for 'washers' but no results found because all the products use the singular form 'washer'. I will conduct research into the full text capabilities of SQL Server.

Through minimal research, it seems very simple to implement full-text inflectional searches (search by different forms of a term). Just perform a full-text index on the columns that need to be searched then use the CONTAINS or FULLTEXT keywords. A simple example is as follows:

SELECT Name
FROM Product
WHERE CONTAINS (Name, 'FORMSOF(INFLECTIONAL, "foot")')

The above query would search for products that have both the singular 'foot' and plural 'feet' in the product's name.