Supabind

Odoo

Connect a transformed file to your Odoo ERP, map its fields to any Odoo module, and keep records in sync on a schedule.

Overview

The Odoo Sync Profile screen is where transformed data leaves your workspace and lands in Odoo. It has four tabs-Create Sync Profile, Sync Odoo Templates, Scheduled Sync, and Sync Monitoring-that cover setting up a sync, reusing it, automating it, and watching it run.

Connect Your Odoo Instance

Before you can sync data, add Odoo as a connector under Data Adapters → Odoo → Configure. This opens the Configure Odoo Connector dialog, where you enter your instance's connection details.

Connection Details

Configure the connection to your Odoo instance

Connection Name

e.g. My Odoo Production

Database Name

e.g. odoo_db

Odoo URL

e.g. https://your-odoo-instance.com

Username

Your Odoo login username

Password

Your Odoo login password

Description (Optional)

A short note to help you identify this connection later

Steps

  1. Fill in Connection Name, Database Name, and your Odoo URL.
  2. Enter the Username and Password Odoo should authenticate with, and add an optional Description.
  3. Click Test Connection to confirm Odoo accepts the credentials before saving.
  4. Click Save Connector to finish, or Cancel to discard the changes.

The optional Custom Odoo REST API Module section lets you push data in bulk via a custom REST endpoint instead of XML-RPC-expand it only if your Odoo instance has that module installed.

Create a Sync Profile

Every sync starts by pairing a source file with a destination connector.

Create Sync Profile

Configure and initiate the sync process

Select Source File

Choose from your completed export jobs and row-to-column transformations

Select a transformed file

Select Destination

Choose a connector as your data destination

Select a destination connector

Steps

  1. Open Odoo Sync Profile from Data Adapters and stay on the Create Sync Profile tab.
  2. Under Select Source File, pick a transformed file from a completed export or transformation job.
  3. Under Select Destination, choose Odoo as the destination connector.

Map Fields to an Odoo Module

Once a source and destination are selected, Target Module Discovery lists every module available in your connected Odoo instance so you can point the sync at the right one-such as Product (product.template).

Field Mapping Interface

Source Fields

Fields pulled from your transformed file

Target Fields

Every field on the selected Odoo module

Field Mappings

The source → target pairs you've confirmed

Steps

  1. In Target Module Discovery, search or select the Odoo module you want to sync into.
  2. Click a field in Source Fields, then its match in Target Fields-or click AI Auto-Map to have mappings suggested for you.
  3. Use Quick Map for identical field names, or Add Mapping to pair fields manually.
  4. Fields marked Required in the target list must be mapped before the profile is ready to save.

Use Export to save your current mappings as a file, or Import to load mappings you've exported before. The Preview Ready badge confirms the mapping set is complete.

Choose an Operation Method

Operation Method controls how each row in the source file is written to Odoo.

Create New Record

Always creates a new record in Odoo for each row in the source file.

Update Existing Record

Finds a record in Odoo using a match field and updates it. Rows with no match are skipped.

Upsert (Create or Update)

Checks whether a record exists using the match field-updates it if found, creates it if not.

Once your mappings and operation method are set, the summary panel confirms the source file, destination, target module, and number of field mappings before you save.

Save & Reuse Sync Templates

Clicking Save as Template stores your source, destination, module, and field mappings as a reusable configuration under the Sync Odoo Templates tab.

What you'll find there

  • Every saved template, with its source → target connector, number of field mappings, usage count, and last-used date.
  • A Start Sync button to run a template immediately.
  • Edit, preview, or delete icons for managing each template.
  • A search bar to find templates by name, description, source file, or connector.

Schedule Syncs

The Scheduled Sync tab automates a saved template so it runs without manual intervention.

Steps

  1. Go to Scheduled Sync and select a saved template to automate.
  2. Set a recurrence-such as Daily-and the time of day it should run, along with a start date.
  3. Review each schedule's Status, Next Run, and Last Run from the list, and use the edit or delete icons to manage it.
  4. Filter the list by status, or search by name, to find a specific scheduled sync.

A schedule showing Failed status will keep retrying at its next scheduled time-open Sync Monitoring to see why a run didn't complete.

Monitor Sync Runs

The Sync Monitoring dashboard shows every sync run-scheduled or manual-with live status and record counts.

What each run shows

  • The template name, sync run ID, and whether it was a Scheduled Sync or manual run, plus its current status.
  • Source and target for the run, along with Total Data, Processed, Failed counts, and run duration.
  • An error message when a run fails, plus View Logs and Download Logs for full detail.
  • An Auto-refresh toggle to keep the dashboard live, and a search and status filter to narrow the list by name, source, target, or ID.

Was this article helpful?

Need More Help?

If a sync isn't mapping the fields you expect, or a scheduled run keeps failing, our support team is here to help.

Contact Support