Odoo
Read Odoo's sales orders and CRM leads, with the campaign Odoo recorded on each, so revenue meets the visits behind it.
Updated
What we read
- Confirmed and cancelled sales orders, with their amount and campaign
- Leads and opportunities: new, won and lost, with the campaign
How it connects
Open Sources > Odoo in your project, fill in Odoo address and Database (only if needed), paste your API key, and click Connect.
To find the key: in Odoo: click your avatar, My Preferences, Account Security, New API Key. Needs Odoo 19 or later and a plan with the external API.
We check the key with the vendor at once. It is kept encrypted for this project, never shown again, and deleted when you disconnect.
Requirements
- Odoo 19 or later, on Odoo Online, Odoo.sh or your own server. Older versions don't have the API we use.
- A plan that includes the external API.
- The Sales app, the CRM app, or both, and a user who can read them. We recommend a user made only for nextanalytica.
- The address of your Odoo (
https://yourcompany.odoo.com). Name the database only if your server has several.
To make the key: click your avatar in Odoo, then My Preferences > Account Security > New API Key.
What does it sync, and how often?
We sync every hour and read the last 30 days again each time, since an order can still be cancelled and a lead won or lost.
| What | When it counts | As |
|---|---|---|
| A confirmed sales order | The day it was confirmed | Revenue, in its currency |
| A cancelled sales order | The day it was confirmed | Not revenue |
| A new lead or opportunity | The day it was created | A lead, with its expected revenue |
| A won opportunity | The day it closed | Revenue, unless it already became sales orders |
| A lost opportunity | The day it closed | A lost deal |
Each comes with the Source and Campaign Odoo recorded on it. Odoo Website records them from the visit's UTM tags on its own. If another site sends leads to Odoo, send the visit's UTM tags with them.
Troubleshooting
"This Odoo doesn't have the JSON-2 API"
The server runs Odoo 18 or older, or the address points elsewhere. Check the address; the source needs Odoo 19 or later.
"This server has several databases: name the one to read."
Fill in Database with the database's name, as it shows on Odoo's sign-in page.
"Odoo didn't accept this key"
Make a new key under My Preferences > Account Security and paste it.
"This Odoo user can read neither Sales nor CRM"
Give the key's user access to Sales or CRM in Odoo, or connect with another user's key.