Skip to content
ODOOVATIONShome

Migration guide

Odoo migration: records, codes and reconciliation

7 min read·Published by ODOOVATIONS, October 2026

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

CheckSourceOdooPass when
Customer countOld customer masterres.partner (customers)Equal, or every difference explained
Item count and codesItem masterProductsCodes preserved, counts equal
Stock quantity and valueClosing stock reportInventory valuationQuantities and values match
Receivables and payablesAgeing reportsPartner ledgersTotals match by partner
Trial balanceOld ledgerOpening entriesEvery 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.

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.