OpenBOM™ Integration for Odoo Help Documentation

 

Introduction – What Can OpenBOM’s Integration for Odoo Do?

If you’re using Odoo for your Inventory Management, OpenBOM gives you a direct integration with Odoo. The integration extracts data from OpenBOM and uploads it to Odoo to create a bill of materials.

In addition to sending BOMs, the integration can send derivatives or any reference files in the item like neutral 3D PDF/ Drawings PDF, STEP, DXF files to Odoo Documents. This is a one way Integration from OpenBOM to Odoo.

Functions and Benefits

  • Integrated OpenBOM and Odoo for BOMs, Thumbnails, Item properties, Documents
  • Send multi-level BOMs with hi-resolution thumbnails for product structures with ONE CLICK
  • Send derivative files (PDF, STEP, DWG, DXF etc.) and put link in BOM
  • Manage which and how properties from OpenBOM  are sent to Odoo 
  • Exclude unwanted or empty properties
  • Add columns and rows on-the-fly to the BOM
  • Non-model items (eg. Glue, tape, etc) can easily be included and managed in a BOM
  • Supports auto part number methods and custom properties
  • Manage Part or Assembly using OpenBOM catalogs with any custom attributes

Data Flow Diagram

OpenBOM for Odoo

Installation

Odoo connecting to OpenBOM

Odoo supports API access using the JSON-RPC or XML-RPC protocols. While traditionally you authenticate using a username and password, Odoo (since v16) allows you to use API keys instead of passwords for better security.

Important Hosting Requirement

In order for OpenBOM services to connect to s Odoo instance:

You must host Odoo on a publicly accessible server
 OR properly configure their local/virtual environment to allow inbound HTTP(S) traffic.

This is mandatory. If Odoo is running on localhost, or a private IP with no port forwarding or reverse proxy, OpenBOM will not be able to connect.

For local-host it’s possible to expose user’s local services to the internet ex: https://localtonet.com/documents

Step 1

Oddo Apps required, in Apps find app Manufacturing and Activate it.

Step 2 – Enable developer mode

BEFORE CONTINUE – IMPORTANT STEP TO ENABLE DEVELOPER MODE!

Go to Settings → Find Developer Tools → Click Activate the developer mode

Step 3 – Create API Key

 An API key is a long, secure token generated per user. It acts as a password replacement for external access to Odoo. API keys:

  • Are tied to a specific user
  • Can be created/revoked individually
  • Do not reveal the actual user password
  • Work in the Community Edition via standard JSON-RPC

How to get → Go to My Profile → Account Security tab → New API key


Set it to more than 1 day (1 year for example )

Step 4 – Authentication Flow

After creating API key, you can export BOM to Odoo by passing next parameter below in settings UI on OpenBOM Export to Odoo

Open a BOM in OpenBOM and you see the Odoo button

  • Odoo host – link to access odoo UI
  • Odoo Database – name of the database you created in Odoo and currently working in
  • Odoo Login – user name / email of the Odoo account you registered
  • Odoo API Key – api key string

Settings

Authentication Settings

1) Setup Odoo Credentials (Host Address, Database Name, Odoo user email, API Key).

Use Save Settings to save Authentication Settings and connect to Odoo with the Connect to Odoo button. 

2) Setup Odoo Credentials (Host Address, Database Name, Odoo user email, API Key).

Setup Properties to Map OpenBOM Properties to Odoo.

Use Filter to show mapped properties already set or see mandatory required.

Product default_code and product: name are required.

3) Use Search to find properties ex image map to Thumbnail image.

4) Use Files to send referenced properties with attachments to Odoo Documents.

First switch to a view with Reference Properties visible to Export.

Send derived Files to Odoo will show all possible properties to send, check and select the ones to send.

5) Use Export to Send data to Odoo.

The above Properties are a good minimal sample for testing. Click Export.

A progress wheel will show you can close it. 

Once complete this Dialog Show up:

Open the Odoo link to open the Created/Updated BOM.

Recommendations

Test in a test environment.

Gradually understand the Integration capabilities Start with BOMs first with a minimal required properties map ex: only product code, product name and thumbnails  then move to update BOM with more added properties and to send files.

Troubleshooting

Files are not being sent to Odoo

Check the View shows the Reference Properties with Document links you want to Export, and make sure they are in OpenBOM Storage.

Check Logs and send to support@openbom.com.

Loading...