An Odoo data migration checklist
- Define the scope. Record target version, company, models and installed modules. Use a sandbox with representative configuration.
- Preserve the original. Keep the source file and identify its worksheet, encoding and date/number conventions.
- Choose stable identities. Validate that source keys are present and unique. Keep external ID namespaces consistent across retries.
- Resolve dependencies. Plan categories, units and related records before dependent rows. Avoid matching by display name alone.
- Review the proposal. Read the reasoning behind mapping suggestions, including AI-assisted ones. Check required values, defaults, create versus update behavior and the exact target records.
- Execute deliberately. Approve the reviewed content and use a controlled target window.
- Reconcile outcomes. Investigate uncertain results before retrying. Save the outcome report with the engagement.