Migration guide
Odoo migration: records, codes and reconciliation
A migration is finished when the numbers match, not when the import runs. Inspect the source first, keep your existing item, customer and account codes, map every field, rehearse the import, then reconcile record counts, stock quantities and values, and financial balances before cutover, with a way back if something is wrong.
Inspect before you quote
The condition of the old data decides the effort. Duplicate customers, items with three units of measure and years of unreconciled balances are normal. Look before agreeing a price.
Legacy FoxPro systems
Many Pakistani businesses still run DOS FoxPro or Visual FoxPro applications. First establish which version it is. Then inventory the DBF tables and their companion files: FPT files hold memo fields and CDX or IDX files hold indexes. Collect the PRG source code if it exists, because business rules often live there. Check the character encoding and code page, since old Urdu or special characters can break if read with the wrong one.
What to reconcile
| Check | Source | Odoo | Pass when |
|---|---|---|---|
| Customer count | Old customer master | res.partner (customers) | Equal, or every difference explained |
| Item count and codes | Item master | Products | Codes preserved, counts equal |
| Stock quantity and value | Closing stock report | Inventory valuation | Quantities and values match |
| Receivables and payables | Ageing reports | Partner ledgers | Totals match by partner |
| Trial balance | Old ledger | Opening entries | Every account matches |
Never let a migration silently renumber customers, items or accounts. People, printed labels and old documents depend on those codes.
Rehearse, then cut over
- Run at least one full rehearsal into a test database.
- Reconcile it and fix the mapping, not the numbers.
- Freeze the old system at cutover.
- Keep the old data readable and a rollback plan ready.
Related services
Questions
No tool reliably converts the data and the business logic together. Data can be migrated with checks; logic is rebuilt deliberately.
Ready to talk through your project?
Send a voice note, spreadsheet or a plain description of where your business is struggling. We’ll help you find the right next step.

