Odoo Help

Welcome!

This community 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.

1

How can Odoo Connect to datapools for Product Information Import?

By
Emiel van Bokhoven
on 9/13/15, 3:09 PM 859 views

Description

For Odoo to be a real competitor for SAP, Syntess, Unit 4 and other software there is need for product information management. And the ability to connect to data pool providers. For the import of a large quantity of products and real time stock levels in the supply chain.

Use case:

I will use the Netherlands, and the installers and construction sector as an example, as of my background.

For the Installer & Construction sector we need to be able to easily acces product data from manufacturers and distributors. For example a house is assembled from over more than 100 products. Like Roof tiles, Faucets, Electrical sockets and so on. For each product there are different sizes, models, and colors. Multiple Brands and suppliers.
To add all this information manually in an ERP system, would be a massive task.
Imagine even keeping the prices up to date. 
We are lucky that in this day and time a lot off this data is already at our disposal.


Reliable Data sources and Standards

In Europe there is the ETIM standard. (European Technical Information Model.) https://en.wikipedia.org/wiki/ETIM_(standard)

In the Netherlands there is a non-profit data pool connector called 2BA (2ba.nl).
2BA is Offering Product specs, Stock levels, pricing and digital assets (datasheets) from one single source.

  • 1.2 million products

  • 280+ Data suppliers( Manufacturers & Wholesalers)

  • 1200 Installer companies.

  • 45% of the market is using 2BA and growing.

I assume there are similar organisations in other countries which offer data pools according to the ETIM standard as well.

That Leads me to the question.

How to get odoo to connect to these types of datapools?

2BA is offering a JSON API, which allows acces to real time data.
(And XML files, but those would not deliver real time stock availability.)

So theoretically it should be possible to let it interact with Odoo.

  • Is there already a module which allows the connection to other datapool collecors?

Like BAB, GS1 DAS, PS in Foodservice, EZ-Base, BME Cat, Icecat.

  • Are there some people here who have experience gathering product information from external web services?

  • Is some kind of API already developed?

Are you interested in developing such a (universal) data pool connector?

Please respond below.

1

Axel Mendoza

--Axel Mendoza--
10203
| 7 7 8
Camaguey, Cuba
--Axel Mendoza--

DevOps - Full stack - Software Architect - Developer - Technology Integrator

I could help you to develop anything and solve complex problems based on technologies, integrations and tricky stuffs mostly in Python with OpenERP/Odoo, Zato, Django and many others frameworks programming languages and technologies.

I offers consulting services to anyone with an unanswered questions or needs for customizations. Think about it, maybe it's better to have an expert to solve your issues and projects than having a full time employee trying to understand what to do an how

Reach me at aekroft@gmail.com

Axel Mendoza
On 9/14/15, 3:42 AM

I think that Odoo don't need to support every kind of integration or standard out-of-the-box, SAP didn't too. But with Odoo everything is possible, just need to develop the right connector or integrator and you are done with your requirement. What you are describing is very particular case of Netherlands.

0
Vladimir Knobel
On 8/29/16, 11:09 AM

It's actually not a very particular case of the Netherlands. You probably need that kind of information in any country for a that specific use case or other similar to it.

@Emiel: How did you solve the issue of importing product/stock data from an external source? 

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 9/13/15, 3:09 PM
Seen: 859 times
Last updated: 8/29/16, 11:09 AM