SharpSync
  • Welcome
  • Fundamentals
    • Getting Started
      • Registration
      • Landing Page
      • Support
      • Subscription
    • Data Sources
    • Property Mappings
    • Rule Templates
    • 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
      • Suite API Setup
      • Create an uploads folder
      • Setting up a thumbnail folder
      • 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
        • Common Mapping Rules
        • Common List names
      • Advanced Bill of Materials
      • Configure Server Side Script
        • Example Server Side Script
      • Configure SharpSync to use Server Side Script
      • 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
    • 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
  • Property Mappings
    • Property Mapping Settings
      • Rendering Types
    • Rule Templates
      • 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
    • Derivatives
    • Advanced Scripting
  • User management
    • User Management
    • Application Permissions
Powered by GitBook
On this page
  1. Data Sources
  2. Odoo
  3. Common Setup

Map BOM Types

PreviousMap BOM CodesNextMap Attribute Values

Last updated 19 days ago

In Odoo the default values for BOM types can be in the range

  • Manufacture this Product

  • Kit

  • Subcontracting

[These can depend on your installation, but it is a common theme]

To update this from SharpSync, start by adding a for

mrp.bom.type

Setting
Value

Primary Accessor

(Unmapped)

Secondary Accessor

mrp.bom.type

Prefer Odoo Value

checked

Update Odoo on submit

checked

Rendering Type

Advanced List **see setup below

The type of the Odoo property will be array . This is an indication that you can typically select from a list of values in Odoo. In my example the value of this array looks like this

bundle (Bundle)|normal (Manufacture this product)|phantom (Kit)

This means there are 3 internal values in Odoo:

Value a user may select
User sees in Odoo

bundle

Bundle

normal

Manufacture this product

phantom

Kit

To view these values in Odoo, navigate to

Settings > Technical > Database > Fields Selection

Search for BOM Type

Let's setup an Advanced Selection list to present this to the user in SharpSync.

  • Copy the values in the Array Enum Values field

  • Using ChatGPT, Claude, Copilot or similar, convert it to a text json list using the prompt

Convert this to a json list with string kv pairs using the value before parenthesis as 'name' and the value in the parenthesis as 'value'

  • Copy the output

Back in SharpSync, make the following edits to the property mapping for Bom Type:

Setting
Value

Rendering Type

Advanced List

List Display Selector

value

List Value Selector

name

Prefer Odoo Value

checked

For the list items, paste the value in your clipboard specified in the previous step. It should look like the following:

[
  { "name": "bundle",  "value": "Bundle" },
  { "name": "normal",  "value": "Manufacture this product" },
  { "name": "phantom", "value": "Kit" }
]

I'm now able to display + update the values from Odoo

Property Mapping