Connect a transformed file to your Odoo ERP, map its fields to any Odoo module, and keep records in sync on a schedule.
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.
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
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.
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 Destination
Choose a connector as your data destination
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
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.
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.
Clicking Save as Template stores your source, destination, module, and field mappings as a reusable configuration under the Sync Odoo Templates tab.
The Scheduled Sync tab automates a saved template so it runs without manual intervention.
A schedule showing Failed status will keep retrying at its next scheduled time-open Sync Monitoring to see why a run didn't complete.
The Sync Monitoring dashboard shows every sync run-scheduled or manual-with live status and record counts.
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