Getting Started

See Authentication + Configuration before continuing with the below.

It is important to start with something simple like Description and Quantity . Once you've confirmed that a Bill of Materials is being created according to your specifications and that is working to your liking, work your way up from there to more complicated mappings like routings, unique values, and generated values.

Add Property Mappings

After authenticating with Odoo, add the following Property Mappings

Name	Primary Accessor	Odoo accessor
Description	Description	product.template.description
Quantity	Quantity	mrp.bom.line.product_qty

Property Mapping settings

Description

Recommended settings for description

Setting name	Value
Update Odoo on Submit	Checked
Rendering Type	Free Text
Enabled	Checked
Prefer Odoo Value	(your choice) Recommended setting is unchecked
Visible	Checked

Leave all other fields as default

Quantity

Recommended settings for Quantity

Setting name	Value
Update Odoo on Submit	Checked
Rendering Type	Free Text
Enabled	Checked
Prefer Odoo Value	Unchecked
Is Read Only	Checked
Visible	Checked

Leave all other fields as default

Property mapping rules

To format the data coming from your Primary Source and Secondary Source (Odoo), we use import rules to massage the data.

Add the following rules, then click the save button for each rule.

Description

Description (mapped to product.template.description) in Odoo is an HTML field. So it comes with some HTML tags. It can be desirable to remove these tags, so the following import rule takes care of this by removing <p></p> paragraph tags

Rule	Value	Process for
Replace all instances	Match value <p> Replace with (leave empty)	Odoo
Replace all instances	Match value </p> Replace with (leave empty)	Odoo

Quantity

Quantity (mapped to mrp.bom.product_qty) in Odoo is an numeric field. We want to format it so that it displays as the same number of decimal digits as those coming from our Primary Data Source. This is an optional rule mapping.

Rule	Value	Process for
Format as decimal number	Number of decimals: 0	Odoo + Primary
Text is not empty	block	(Prevents empty values)

You are now ready to submit a new Bill of Materials and view it in SharpSync.

Below are some property mappings that can be imported when working with Odoo as a Secondary Source (right click > Save link as...)

CAD Source	Odoo version	Comment
Onshape	Odoo v17	download odoo-17-default-mapping-set.json