# Odoo connection setup: prepare database and API credentials

To set up and connect Odoo to Optiply, prepare your Odoo server address, exact database name and connection user's login. Use an API key instead of the password when the connection user uses two-factor authentication. Keep two-factor authentication enabled.

## Before you prepare the Odoo connection

Ask your Odoo administrator to confirm the server, database, connection user and permissions for the agreed data flows. For Odoo Online, external API access requires the **Custom** plan. The **One App Free** and **Standard** plans do not provide that access.

Confirm the Odoo version and connection route with Optiply Support. The database name, company name and website address are different values. Do not substitute one for another.

## Steps to prepare your Odoo connection details

1. Sign in to the Odoo account that manages the intended database.
2. Open your database manager and identify the exact database name.
3. For Odoo Online, open **My Databases** from your Odoo account to identify the database.
4. Sign in as the user your administrator assigned to the connection.
5. Open **Preferences** or **My Profile**.
6. Open **Account Security**.
7. Select **New API Key**.
8. Give the key a clear description for this connection.
9. Select **Generate Key**.
10. Store the key securely when Odoo displays it.

If your Odoo version asks for a key duration, choose one your administrator approves. Record its expiry so the connection owner can replace it before it expires. Odoo cannot show the same key again later.

The labels depend on your Odoo version. See Odoo's [external API and API-key instructions](https://www.odoo.com/documentation/19.0/developer/reference/external_rpc_api.html) for the credential model.

## Fields in the Odoo connection setup

| Detail | What to prepare |
| --- | --- |
| Server URL | The address of the intended Odoo instance. |
| Database name | The exact database identifier, not a company label. |
| Username or login | The connection user's Odoo login. An API key does not replace this value. |
| Password or API key | The authentication value for that user. With two-factor authentication, use the API key in the password field. |

Open **Settings** → **Integrations** in Optiply. If your Odoo source is offered, follow its displayed connection fields. Otherwise, use **Contact us** or contact Support for assisted setup. Ask Support for the approved secure channel before sharing authentication values. Never paste passwords or API keys into ordinary messages, screenshots or correction forms.

## What you see when Odoo preparation worked

You have the exact server, database and user details, with a securely stored authentication value. After connection, check the selected source and its **Import jobs** in Optiply. A connected label and a completed import are separate checks.

## Limits of preparing the Odoo connection

An API key grants the connection user's access. It does not grant extra database or model permissions. Connection preparation alone does not import records or enable purchase-order export.

## If Odoo authentication did not work

Check the database and login with your administrator. If a key is lost, deleted or expired, create a replacement and update the connection through its approved route. Ask Support to confirm the connection before deleting a working key. Do not disable two-factor authentication to troubleshoot.

## Related articles on Odoo data and orders

- [Odoo data mapping](/article/integrations-data-mappings-public-odoo).
- [Check a buy order missing from Odoo](/article/troubleshooting-failed-buy-order-to-odoo).
