Read BOM Operations

BOM operations are individual operations that are performed on the item. This means that, despite having the same name as other operations on other BOMs, the items shown are unique.

So even if you see duplicates in Odoo, they each have their own underlying unique operationId for that line in the BOM.

Summary of article's major steps

• Create a new Property Mapping

• Add an import rule to format the object and make it ready for SharpSync

The best way to manage operations is to be consistent in your naming convention for your operations.

In other words, if you are going to assemble something, always give it the exact same name (e.g. Assembly or Assemble).

Choose what to display

The work centers and operations both depend on mpr.bom.operation_ids. You'll want to display one of the following:

• The mapped work center or stations, read-only (e.g. Drill Station 1, Galvanization, Powder Coating)

• The mapped operation names (e.g. Drill, Galvanize, Powder Coat)

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

BOM operations can often include one or more of the following items in the table below:

Destructive operation	Non-Destructive operation
Punching	Painting
Welding	Assembling
Galvanizing	Powder Coating
etc.	Wiring

To read these operations from the BOM, we map to the Odoo property

mrp.bom.operation_ids

Create a new Property Mapping

Create a new Property Mapping with the following settings (create one for each one you would like to map. So if the first is bomOperation1, then the last would be bomOperationN) :

Setting	Value
Property Name / Header	BOM Operation 1 (or 2, 3..n)
Accessor	bomOperation1
Primary Property	(Unmapped) (or a related property in the Primary Source)
Secondary Property	mrp.bom.operation_ids
List Name	mrp.workcenter
List Value Selector	{id}:{name}
Update Odoo on Submit	false
Rendering Type	Advanced List
List Display Selector	operationName
List Value Selector	workCenterId
List items	Here is a sample of what you can insert, but it can be anything, whatever you use most frequently [more on this below]** [ { "workCenterId": 1, "name": "Drill", "operationName" : "Drill", "value": { "sequence": 10, "name": "Drill", "workcenter_id": 2, "time_mode": "manual", "time_mode_batch": 10, "time_cycle_manual": 60 } }, { "workCenterId": 2, "name": "Galvanize", "operationName" : "Galvanize", "value": { "sequence": 20, "name": "Galvanize", "workcenter_id": 1, "time_mode": "manual", "time_mode_batch": 10, "time_cycle_manual": 60 } }, // add as many as you like.... ]
Enabled	true
Prefer Odoo Value	true

Once you have the property mapping set up, create a 2nd, 3rd and 4th Property Mapping for each additional operation you would like to map (you don't have to create this many, they just serve as place holders).

Add an import rule

For each of these Property Mappings, add the following Text Manipulation (import) rule which parses the value of mrp.bom.operation_ids and converts it into a value in the column

Writing BOM operations is explained in the next topic Write BOM Operations

Setting	Value
Type	import
Name	Text Manipulation
Process for {Primary}	false
Process for Odoo	true
JavaScript expression	if (!s || s.length === 0) return ""; const operationToSelect = 1; /* change this to 1, 2,3,4... based on the number of operations*/ if (Array.isArray(s)) { if (s.length == 0) return ""; if ( s.length > operationToSelect && s[operationToSelect].workcenter_id && s[operationToSelect].workcenter_id.length > 0 ) { return Number(s[operationToSelect].workcenter_id[0]); } return ""; } if (typeof s === "string") { try { console.log("Parsing operationWorkCenters JSON string:", s); const parsed = JSON.parse(s); if (Array.isArray(parsed)) { /* If the parsed string is an array, return the workcenter ID of the first element */ if ( parsed.length > operationToSelect && parsed[operationToSelect].workcenter_id && parsed[operationToSelect].workcenter_id.length > 0 ) { return Number(parsed[operationToSelect].workcenter_id[0]); } return ""; } else { console.log("Parsed operationWorkCenters JSON is not an array, it is " + typeof parsed, parsed); return ""; } } catch (e) { console.log("Invalid operationWorkCenters JSON string:", s, "Error:", e.message); return ""; } } return "";

After adding the new Property Mapping, add an import rule