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
  • But first, an overview of displaying the values from Odoo
  • Querying List Values for all attributes
  1. Data Sources
  2. Odoo
  3. Common Setup
  4. Map Attribute Values

Reading Attributes - Overview

Before reading the below, make sure to read Map Attribute Values

The following article describes how to show single value attributes in a column for SharpSync. It does not show how to write the values. Please make sure to mark columns showing single values as Read-Only

An Odoo product template can have many attribute mappings. To break these down into individual columns in SharpSync, make one or more of the following changes:

  • Map the attribute names

  • Map individual attribute values

  • Map all attribute values

But first, an overview of displaying the values from Odoo

When mapping to product.template.color

a value of Red AND Satin Black. will be displayed on screen.

But when mapping to product.product.color.

a value of Red OR Satin Black will be displayed on screen

When mapping to product.template.finish

a value of Matte AND Gloss. will be displayed on screen.

But when mapping to product.product.finish.

a value of Matte OR Gloss will be displayed on screen

Querying List Values for all attributes

To view the values of a product template's attributes in SharpSync, use the Property Mapping list product.attribute

product.template.atributes

Setting
Value

Primary Accessor

(Unmapped)

Secondary Accessor

product.template.attributes

List Name

product.attribute

List Value Selector

{id}:{name}

Prefer Odoo Value

checked

Update Odoo on submit

! enable only if mapping a single value !

[You have been warned!]

  • Open the Property Mapping > Settings and enter a List Name of

product.attribute

Click the Save button. The list preview will update with the values of all attributes available in Odoo. If you want to only map the attribute names, move to Display All Attribute Names

Choose what to display

You'll want to display one of the following:

  • The mapped attribute names (e.g. Color, Finish, Legs)

  • The mapped attribute values (e.g. Color: Black, Red, Satin Black)

For more complicated mappings, please contact us through the support portal.

Read the next articles in line to work with all attributes or single attribute names.

PreviousMap Attribute ValuesNextDisplay All Attribute Names

Last updated 1 month ago

Start by adding a for

Property Mapping