Odoo is an open-source enterprise resource planning (ERP) software suite that encompasses various business management applications. It offers modules for functions like accounting, inventory management, sales, CRM, human resources, and more, providing a comprehensive and customizable solution for businesses to streamline their operations and improve efficiency.
Authorize Connection to Odoo
Authorize the connection so Dataddo can write to Odoo:
| Field | Description |
|---|---|
| A name for this authorizer in Dataddo | A label so you can recognize the connection later. |
| Host | Host |
| Username | Username |
| API Key | API Key |
| Database | Database |
Dataddo validates the connection when you save it.
Create an Odoo Destination
Go to Destinations, click Create Destination, and select Odoo. Give the destination a name, choose the authorizer, then set:
| Field | Description |
|---|---|
| Language | Language Shown when oAuthId is ``. |
| Model | Model Shown when language is ``. |
Click Save.
Fields that load from your account (such as the target object or module) appear after you choose the authorizer.
Write Modes
The write mode decides how each flow run changes your Odoo records. Odoo supports the modes below.
| Mode | Meaning |
|---|---|
insert |
Creates a new record for every row. |
update |
Updates existing records matched by their key; fails rows with no match. |
Flow columns are matched to Odoo fields by name. If a column has no matching field, it is ignored.
How to Create a Flow to Odoo
- Go to Flows and click Create Flow.
- Add one or more sources.
- Add Odoo as the destination and pick the authorizer.
- Select the target object and the write mode.
- Set the schedule and click Save.
Troubleshooting
Cannot connect to Odoo
Reauthorize the Odoo connection and make sure the account has permission to write the target object.
Rows are rejected
Odoo rejected rows that break its field rules (required fields, value formats, or duplicate keys). Fix the source data or the field mapping and restart the flow.