Odoo

[docs in progress]

This document is a work in progress

Limitations at the time of writing

SharpSync supports different versions of Odoo:

  • Odoo version 17.

  • Odoo version 16. Should you require access to a different version, please contact us at SharpSync

Odoo is an open-source ERP available in a self-hosted or cloud-hosted option. Please also see:

To configure an Odoo intance you need 4 things

  • Odoo version number

  • Database name (case sensitive)

  • Username

  • Password

Setup steps

  • In the Navigation Bar, select Data Sources

  • On the right (in Data Sources), select Odoo as the Data Source and click ADD DATASOURCE

  • Change the Server URL to:

    https://{myEnterprizeInstance}.dev.odoo.com
  • Scroll to the bottom of the page and click UPDATE

  • Click CONFIGURE

  • On the first tab (Authentication), change the Base API Path to: https://{myEnterprizeInstance}.dev.odoo.com

  • Leave the Authentication Types dropdown on Basic Authentication.

  • Enter the Database name.

To find the database name navigate to https://{myEnterprizeInstance}/web/database/selector

  • Enter the username and password.

  • The configuration should look something like the image below:

  • On the second tab (BOM Configuration) enter the version number (Only version 17 is supported at the time of writing, but contact us if you require access to an older version)

  • Click the Save button to save and close the form.

  • Click AUTHENTICATE. If the configuration is successful, the Authentication Status will update and show Connected.

  • Configure the Primary and Secondary Identifiers as follows:

    • Primary Identifier: name

    • Secondary Identifier: product_tmpl_id

After successfully authenticating with Odoo, the update should automatically trigger. If it does not, click the Update button.

The custom fields from Odoo have now successfully been pulled into SharpSync.

If you ever add new properties to Odoo, make sure to come back to the property mapping page and click the Update button again.

SharpSync requires the MRP module (mrp) at a minimum in order to support an Odoo integration. This is because of BOM information, more specifically the Quantities of individual items.

Routings are not currently supported but we are working towards it.

Please make sure to set up your Secondary Data Source. For more information, refer to the other Data Sources listed in the Navigation Bar.

Once completed with the setup for both Primary and Secondary Data Sources, proceed to setup Property Mappings.

Extra information

For additional information please see:

Last updated

#48:

Change request updated