SharpSync
  • Welcome
  • Fundamentals
    • Getting Started
      • Registration
      • Landing Page
      • Support
      • Subscription
    • Data Sources
    • Property Mappings
      • Adding Property Mapping
      • Property Mapping Settings
    • Rules
      • Import / Export
        • Append text
        • Calculate number
        • Export manipulation
        • Format as decimal number
        • Prepend text
        • Remove property
        • Replace all instances
        • Replace first instance
        • Round to nearest X
        • Select from JSON
        • Set cell value
        • Set empty cells
        • Text manipulation
      • Display
        • Number between
        • Text contains
        • Text ends with
        • Text evaluation
        • Text is a number
        • Text is exactly
        • Text is in list
        • Text is not a number
        • Text is not empty
        • Text is not in list
        • Text length between
        • Text length is exactly
        • Text maximum length
        • Text minimum length
        • Text not contains
        • Text not ends with
        • Text not starts with
        • Text starts with
      • Advanced Scripting
    • BOM Comparison
    • Data Safety
    • Troubleshooting
      • Duplicate component paths
      • OAuth 2.0
  • Data Sources
    • Autodesk Inventor
    • CSV
      • Getting Started
      • Importing a Bill of Materials (BOM)
    • MS Dynamics 365 Business Central
      • Getting Started
      • Item Fields Json & Internal Names
      • Resource Fields Json & Internal Names
      • List Names For nestedObject Mappings
    • NetSuite
      • OAuth Setup
        • Permissions
      • RESTlet Script Setup
        • SharpSync RESTlet Script
      • Thumbnail Folder Setup
      • Authentication + Configuration
      • Common setup
        • Configure quantity mapping
        • Configure accounts mappings
        • Configure itemType mapping
        • Configure isPhantom mapping
        • Configure subsidiary mapping
        • Configure price mapping
        • Configure Where Used Link mapping
        • Configure thumbnail mapping
        • Read-Only NetSuite Fields
        • Common Mapping Rules
        • Common List names
      • Advanced Bill of Materials
      • Configure Routings
      • Integration tips
      • Troubleshooting
    • Odoo
      • Getting Started
        • Authentication + Configuration
        • Debugging tips
      • Common Setup
        • Map BOM Codes
        • Map BOM Types
        • Map Attribute Values
          • Reading Attributes - Overview
          • Display All Attribute Names
          • Display Single Attribute Values
          • Writing attributes
      • Product Management
      • Hosting Options
      • List Names
      • Permissions
      • Troubleshooting
    • Onshape
      • Getting Started
      • Setting up Derivatives
    • Propel PLM
      • Getting Started
    • SolidWorks
    • SolidWorks PDM
      • Downloading and installing the add-in
      • Configure the add-in
      • Setting up the Solidworks PDM Web 2
      • Troubleshooting
      • Submitting a BOM for update
  • Advanced
    • Derivatives
  • User management
    • User Management
    • Application Permissions
Powered by GitBook
On this page
  • Add Property Mappings
  • Property Mapping settings
  • Property mapping rules
  1. Data Sources
  2. Odoo

Getting Started

PreviousOdooNextAuthentication + Configuration

Last updated 2 months ago

See 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 with Odoo, add the following

Name
Primary Accessor
Odoo accessor

Description

Description

product.template.description

Quantity

Quantity

mrp.bom.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

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 accounts for 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)

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

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

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

download

Authentication + Configuration
authenticating
Property Mappings
Primary Source
Secondary Source
Bill of Materials
odoo-17-default-mapping-set.json