This question has been flagged
10 Replies
10465 Views
searchforumcmsfrontendsolrlucenesphinxelasticsearchblogsSearchanise
Avatar
Luke Branch

I'm interested in enhancing or overriding the inbuilt search functionality of Odoo v8.0, specifically in the frontend for allowing a unified search field for all frontend modules (ie. CMS, E-commerce, forum, blogs, etc.). Unfortunately I have not been able to find any projects while searching through github, google, launchpad and similar areas.

I'm looking for any information on implementing any of the following search platforms linked with Odoo v8.0:

  • Sphinx (http://sphinxsearch.com/)
  • Solr/Lucene (http://lucene.apache.org/solr/)
  • ElasticSearch (http://www.elasticsearch.org/)
  • OpenSearchServer (http://www.opensearchserver.com/)

 

Avatar
Discard
Zahin

ODOO CMS is ugly with content management unable to manage complexity, even can't add complex html and new tags

Luke Branch
Author

@Zahin, While Odoo CMS is currently not as feature rich as some other platforms currently, this is due to the fact that it is an initial release for the CMS. The beauty of Odoo CMS & E-commerce is the ability to tie all of the ERP features into the frontend without complicated connectors (integrated, not interfaced). I believe that the basic building blocks for the CMS and E-commerce are there and that more modules will be designed over time to extend the functionality of both the CMS & E-commerce modules to allow for far greater enterprise websites than would ever be possible with a standalone CMS or E-commerce platform. In regards to adding complex HTML, you can add whatever XHTML you require by building a module to override certain parts of the layout to accomplish whatever you require. In regards to tags, this could be easily accomplished by building a module that works on a similar level to the forum tags. I'm actually very interested to see what I can build with the new modules (CMS & E-commerce). As with any platform in it's initial release stages you will see far greater functionality being built in by the community as time goes on.

Avatar
Luke Branch
Author Best Answer

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):

http://demo.searchanise.com/magento/

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

http://community.user.magentotrial.com/

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:

http://docs.searchanise.com/dev/index.html

Avatar
Discard
Luke Branch
Author

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

https://github.com/OpenSur/Odoo_addons/tree/8.0/website_search

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.

Luke Branch
Author

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.

Avatar
Alex Morco
Best Answer

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.


Avatar
Discard
Avatar
ashish-greycube
Best Answer

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

https://apps.odoo.com/apps/modules/9.0/base_name_search_improved/

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

Avatar
Discard
Avatar
Guillaume Pothier
Best Answer

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

https://github.com/odoo/odoo/issues/13585

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.

Avatar
Discard
Avatar
Shimon
Best Answer

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.

Avatar
Discard
Luke Branch
Author

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.