Odoo Help


10 Answers

Luke Branch Hong Kong

--Luke Branch--
| 7 8 8
Wanchai, Hong Kong
--Luke Branch--


Luke Branch Hong Kong
7/25/14, 8:42 AM

I have been considering getting a module built for connecting to the API for searchanise.com to allow for FTS (full-text search) for the postgresql database to allow for better product search and a auto-complete suggestion box while typing for the frontend E-Commerce and CMS modules. Please vote on this if you would like to see it become a reality so that I can gauge interest in the project from the community before committing the time and money required to get it built.

You can see a demo of this in action on a Magento demo store here (type something like 'mobile' into the search box):


You can see the same demo store at the following link without the extension as follows:


The implementation would be identical in regards to the auto-complete/auto-suggest box while typing and would allow for far greater relevance and accuracy (as well as error correction) for full text search queries with Odoo on the frontend.

I would release the module as a community module for free as we would be getting it built for ourselves, however the services from Searchanise are as per their terms. The module would simply act as a bridge for their services which include (at the time of writing) both a free option with very useful basic functionality and a pro/enterprise option with features that require a subscription.

I have found the extension and service (using their Magento extension) incredibly useful in returning more accurate, relevant results in my current Magento stores and am considering getting a module built that would allow for a connection through their API. If there is enough interest in the project I will move forward with it.

Please post back with comments if you have any questions regarding the proposed implementation, or if you would like to get involved with the project. Developer documentation is here:


DevBranch Company Limited, Luke Branch Hong Kong
2/9/15, 1:51 AM

for anyone following this thread, it looks like a substantial amount of work has been done already on a fully-integrated search module:


While I have not yet been able to get it working in 8.0 development instances (it gives a traceback due to syntax), I think it is close to handling my requirements above with a little tweaking.

I'll be doing my best to troubleshoot with the developer and will report back here once I have a working installation.

DevBranch Company Limited, Luke Branch Hong Kong
2/9/15, 3:50 AM

I can confirm that with some minor modifications at the time of writing (follow this issue: github.com/OpenSur/Odoo_addons/issues/7) this module is working in 8.0.

There is still some work to do in expanding the module's feature set and usability (eg. search by blog title for example and styling), but there has been a huge amount of work put into it already and it looks like a fantastic open-source addition to the community.

Alex Morco United States
6/25/18, 4:08 AM

I had thousands of products in my Magento store, my customers were having some difficulties while finding the products on my store that's why I have configured Magento elasticsearch (https://www.cloudways.com/blog/configuring-elasticsearch-magento/) in it and now its working good with the core search within my store.

ashish-greycube India
8/4/17, 2:38 AM

How to call fuzzystrmatch postgres method for odoo ecommerce product search

Hi, I am looking for natural language search and for that postgres provides fuzzystrmatch https://www.postgresql.org/docs/9.1/static/fuzzystrmatch.html

I would like to implement it for product search in odoo ecommerce.

Two questions

(a) Is there any addon or already solution available for this. Does this solve it...i am not sure


(b) If not, how to call fuzzystrmatch function from odoo

Guillaume Pothier Chile
9/24/16, 3:35 PM

I just submitted an issue (with a proposed patch) regarding the eCommerce side of this problem:


What I propose there is an implementation of the search feature that uses the Lunr full-text search engine. It is actually quite a simple patch.

Shimon United States
7/30/14, 5:23 AM

There is a very high probablity that this is on the todo list for v9. Luke, it would be interesting to see if you can contact the developers and find out.

BTW, I visit Hong Kong often. It would be nice to meet you on my next trip. I very much admire you figuring out spirit. Kudos on all the wonderful replies you have written on these help forums.

1 Comment
DevBranch Company Limited, Luke Branch Hong Kong
7/30/14, 6:17 AM

Hi Shimon, Thanks for the reply, it's great to hear that there is a possibility that it's on the roadmap for v9. In regards to developers i'll be focusing mainly on sphinx (search) due to the fact in my opinion it will be the easiest to implement and a much more approachable learning curve as far as further development is concerned. I've spoken to the developers at Searchanise (they're a SaaS company that runs their service on Sphinx (search)) as they already have a mature and incredibly useful product. They've released free modules for Magento, OpenCart, and a few other platforms already. They offer a free service (for basic, but already incredibly useful features) as well as some pro/enterprise tiers for those who need the extra features and functionality. They have mentioned that I am free to develop a module that works with their API, obviously with some basic terms of usage. I'd be happy to forward you the conversations i've had with them if you're interested in getting a dialogue going. I'll be looking at getting a complete Sphinx search module developed for 8.0 as well as creating a basic module that plugs into the Searchanise API in the meantime. The complete sphinx module will likely be a significant investment of time and money however, but I would be happy to share information in regards to the project as it comes along. In regards to meeting up in Hong Kong, i'd be happy to do so as long as my schedule allows, however I am frequently in and out of the country. I'm sure we can organise to meet up for a coffee at some point when time permits.

Ask a Question
Keep Informed
4 follower(s)
About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now