Odoo connector

What the connector does

The connector is a free Odoo module that exposes manufacturing orders, work centers, BOMs, routings, calendars and inventory through an authenticated API. APS pulls from these endpoints and pushes scheduled dates back when you publish.

Supported versions

• Odoo 17.0 — Community & Enterprise
• Odoo 18.0 — Community & Enterprise
• Odoo 19.0 — Community & Enterprise

Older Odoo versions are not supported. The connector depends only on the free mrp, sale_mrp, stock, purchase and resource modules — all included in Community. No Enterprise modules required.

Community-specific: enable work orders

Work orders (the per-operation rows within a manufacturing order) are available in both Community and Enterprise, but they're off by default in Community. To enable:

1. In Odoo, open Manufacturing → Configuration → Settings
2. Switch on Work Orders (sometimes labelled “Operations” or “Manufacturing Routings”)
3. Save
4. Add routings/operations to the BOMs you want to schedule at WO-level

Without this, APS still works — it just plans at MO-level (one bar per manufacturing order on the Gantt) instead of per-operation. Enable WOs if you need finite-capacity scheduling across work centers.

Installation

From the Odoo App Store (recommended):

1. Open the Apps menu in Odoo.
2. Click Update Apps List if you haven't recently.
3. Search for APS Connector and install.

Configure APS

In APS, open Settings → Odoo Connection. You need to provide three values:

• Odoo URL — full URL to your Odoo instance, e.g. https://yourco.odoo.com (no trailing slash)
• Database — the Odoo database name
• API Key — generated in APS, then pasted into Odoo (see below)

How to find your database name

The database name is required because a single Odoo server can host multiple databases. Common cases:

• Odoo Online (yourco.odoo.com) — the subdomain is your DB name. So yourco.odoo.com → database is yourco.
• Odoo.sh — visible at the top-left of the project dashboard, under the project name.
• Self-hosted — whatever name was used during setup. Open https://your-odoo/web/database/manager to see all databases on the server.
• Any setup — after logging in, the URL often contains ?db=name as a query parameter.

Generate the API key

The API key is created in APS, not in Odoo — this is a common point of confusion. The flow:

1. In APS Settings, click Generate New Key.
2. Click Copy Key — the generated value is shown only once.
3. Save APS settings.
4. In Odoo, open Manufacturing → Configuration → APS Integration (this menu appears after the connector module is installed).
5. Paste the same key into the API Key field and save.

Test connection

Back in APS Settings, click Test Connection. A green tick means APS can reach Odoo and authenticate. If you see an error, see Troubleshooting below.

Also set the production facility's timezone on the Organization tab — APS uses it to interpret work-center week patterns and render Gantt working hours correctly.

First sync

After saving connection details, click Run Full Sync in Settings. This pulls everything from Odoo and is a one-off step. Subsequent syncs only fetch changes.

For ongoing sync (interval, manual vs auto, sync status), see Settings.

What gets synced

• Manufacturing orders (MOs) and their work orders (WOs)
• Work centers and their alternative resources
• Working calendars (week patterns, leaves, public holidays, maintenance)
• Products and BOMs
• Inventory levels and incoming purchase orders (for material-aware scheduling)

APS reads via SELECT only — the connector never modifies your Odoo data unless you explicitly publish a schedule.

Troubleshooting

Connection test fails

• Make sure the URL has no trailing slash and includes https://
• The API key is case-sensitive — copy the full value
• Self-hosted Odoo: confirm the server is reachable from the public internet (APS is hosted)

Some MOs don't appear

APS only pulls MOs in active states (confirmed, in progress, to-close). Cancelled and very old completed MOs are filtered. If a known MO is missing, check its status in Odoo.

Working hours look wrong

Set the organisation timezone correctly. Work-center week patterns are stored in local wall-clock and need a reference timezone to convert to absolute time.