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.
See how OdooMap supports this workflow. If a test fails, start with our import troubleshooting notes.