🀝 Migrate customer data from Odoo v15 to v18

⚑ 389 views · 🀝 CRM & Sales Operations

Description

πŸ“„ Description: This workflow helps you migrate customer records directly from Odoo v15 to Odoo v18 without the need for manual exports or intermediate files.

πŸ”Ή It connects to your v15 instance, retrieves customer (res.partner) records, and pushes them directly into your v18 database. πŸ”Ή The workflow uses pagination (SplitInBatches) for efficient handling of large datasets. πŸ”Ή Ideal for teams upgrading their Odoo infrastructure and looking to automate data replication between environments.

⚑️ Note: Country and state ID mapping is excluded in this version for faster migration. If needed, logic can be added to map based on name lookup.

πŸ›  Setup Instructions: Configure Odoo API credentials for both v15 and v18. (https://docs.n8n.io/integrations/builtin/credentials/odoo/) Adjust domain filters in the β€œGet Customers” node if needed. Run the workflow to begin real-time customer syncing.

πŸ“Œ Compatibility: Works with Odoo Community & Enterprise Tested on n8n v1.17+ Requires access to Odoo’s JSON-RPC API

πŸ”— Nodes Used

Odoo

πŸ“₯ Import

Download workflow.json and import into n8n: Workflow menu β†’ Import from File

πŸ“– Importing guide Β· πŸ”‘ Credential setup