Odoo Customer Data Migration Across System Versions - n8n Workflow

IT Administrators and DevOps teams needing to perform systematic ERP data migrations.
Business analysts responsible for upgrading Odoo versions while maintaining data integrity.
Users looking for reliable n8n templates for handling large data transfers between systems.
Automation specialists seeking practical examples of using the Odoo n8n node in production.

Migrating substantial customer datasets during an ERP version upgrade (like moving from Odoo v15 to v18) can be complex and prone to timeouts or errors. This specialized n8n workflow addresses this challenge by providing a structured, repeatable migration process.

By utilizing the dedicated Odoo n8n node for both reading and writing operations, and integrating a core flow control mechanism—the SplitInBatches n8n node—this solution ensures that even very large databases of customers are processed in manageable chunks. This prevents system overload and drastically improves the reliability of the overall data transfer. If you are searching for dependable n8n templates for system migration, this scalable n8n workflow is ideal.

This n8n workflow follows a reliable three-step process designed for robust data handling:

1. Initiation (n8n Trigger): The process begins with the When clicking ‘Test workflow’ n8n trigger, allowing the user to manually initiate the migration process exactly when required.


2. Data Extraction: The workflow immediately executes the Get Customers from v15 Odoo n8n node. This node connects to the source (v15) Odoo instance, retrieves all specified customer records, and outputs them as a large data set.


3. Batch Processing: The dataset is piped into the SplitInBatches n8n node. This crucial flow control step breaks the potentially massive list of customer records into smaller, manageable batches. This is essential for preventing API rate limits or timeout errors on the target system.


4. Data Insertion: Finally, the workflow uses the Create Customers in v18 Odoo n8n node. For each batch received from the previous step, this n8n node connects to the target (v18) Odoo system and creates the corresponding customer records, completing the systematic migration of all contact information. This architecture makes the entire n8n workflow highly scalable.

To deploy this powerful n8n workflow, follow these steps:

1. Import: Copy the provided JSON code and import it directly into your self-hosted or cloud n8n instance using the 'New' -> 'Import from JSON' option.


2. Credentials Setup: This n8n workflow requires two separate Odoo credentials:

1. Configuration: Verify the Odoo n8n node parameters (Resource and Operation) match your intended database structure.


2. Execution: Since this uses a Manual n8n trigger, click 'Test workflow' or activate the n8n workflow and execute it manually to begin the migration.

When clicking ‘Test workflow’ (Manual n8n Trigger):
Function: Serves as the immediate start point for the n8n workflow, ideal for planned, non-scheduled migrations.
Key Configuration: Standard manual execution trigger.
Get Customers from v15 (Odoo n8n node):
Function: Connects to the legacy Odoo system to retrieve the full list of customer records targeted for migration.
Key Configuration: Requires specific Odoo v15 credentials and configuration for the desired Odoo resource (likely Contact).
SplitInBatches (Core Logic n8n node):
Function: Breaks the potentially massive input list of customer data into smaller, manageable chunks. This is vital for the reliability of the n8n workflow when interacting with large external APIs.
Key Configuration: Default batch size is typically used, optimized for reliable throughput.
Create Customers in v18 (Odoo n8n node):
Function: Iterates over the batches and uses the data to create new customer records in the target Odoo v18 environment.
Key Configuration: Requires separate Odoo v18 credentials and is configured for a 'Create' operation on the specified resource.