Odoo ERP Integration (LEGACY)
Use the Odoo ERP Integration options to map the Product and BOM properties located in the Odoo ERP system to the attributes in your ATR CustomTools Database.
The Odoo ERP Integration options are located in the ATR CustomTools Profile Options.
Select the desired ATR CustomTools product from the table below to display further and product-specific instructions to find the Odoo ERP Integration options.
| CT product | Instructions |
|---|---|
| SOLIDWORKS Add-in |
Click Tools, ATR CustomTools, Options. The ATR CustomTools Options dialog box appear with the Profile Options tab active. Select the Odoo ERP Integration node to see the options. |
| ATR CustomTools Viewer |
Click the Options command located in the ribbon. The ATR CustomTools Options dialog box appear with the Profile Options tab active. Select the Odoo ERP Integration node to see the options. |
| ATR CustomTools Administration |
Login to your ATR CustomTools database, select the ATR CustomTools profile node from the Database View and then click the Profile Options command located in the Profile Settings group in the ribbon. The ATR CustomTools Options dialog box appear with the Profile Options tab active. Select the Odoo ERP Integration to see the options. |
The Odoo ERP Integration options are divided into three tabs by setting item types:
| Product | On the Product tab, you can determine field mappings for product-related fields in Odoo. |
| BOM | On the BOM tab, you can determine field mappings for a BOM header in Odoo. |
| BOM line | On the BOM line tab, you can determine field mappings for a single component (BOM line) in a BOM in Odoo. |
Each tab above has the following columns included in their main list of settings:
| CT property field | The CT property field column refers to the Label of the field in the associated ATR CustomTools Export Profile. |
| Odoo field | The Odoo field column refers to the name of the target field in Odoo. |
| Odoo field type | The Odoo field type column refers to the data type stored by the target field specified in the Odoo system. |
| Unique Odoo field | This field value is used to identify (search for) existing products in Odoo ERP. By default, the value is name but it can be another field depending on how Odoo is configured. |
| Create new products only | Select to only create new products in Odoo. When this option is selected, the integration creates only new product instances. Existing instances are not updated. |
| Upload image | Determines whether the component preview image is uploaded to Odoo. Select this option to retrieve a preview image of the component and upload it to Odoo ERP. |
| Process BOM structure | Process document structure and update BOM in Odoo. Select this option to make the ATR CustomTools Export feature process the SOLIDWORKS model structure and create and/or update the BOM in Odoo. |
The list in the BOM line tab operates the same way as the lists in the Product and BOM tabs. The only required field in the BOM line field mappings is the qty field, which is already mapped by default with the Odoo field called product_qty.
There is also a separate list named Linked product fields. Using the Linked product fields options, you may determine the Odoo product fields to be used as references to map the product to the BOM Lines in the Odoo ERP System.
| ATR CustomTools property | A dropdown box to select the ATR CustomTools property to link with the Odoo product field. ATR CustomTools Properties used in the associated ATR CustomTools Export Profile are automatically retrieved into the ATR CustomTools property box. |
| Odoo field | Type the name of the desired target field in the Odoo System into the Odoo field box. The target field name must be typed manually. |
| Odoo field type | Determines the data type of the field data exported to Odoo by this particular attribute mapping. |
The following general controls are included in all tabs described above.
| Add | Create a new item in the settings list. |
| Edit | Edit selected item in the settings list. |
| Delete | Delete the selected item from the Odoo ERP Integration settings. |
| Integer | Signed integer value. |
| Real | A numerical value that may have decimals. |
| String | Combination of various kinds of characters. |
| Boolean | A value of 1 or 0 representing whether the value is true or false. |
| YesNo | A data type used, for example, to represent the selection state of a checkbox control in Odoo. |
| IntegerList | Added to support mapping values that are single integer, but are stored in a list of several integers in Odoo. |