Skip to Content

Data migration to Odoo: a step by step guide

How to move master data, opening balances, open documents and history into Odoo from any legacy system, with the order of imports, cleaning rules, Arabic names and tax numbers, test rounds, reconciliation and sign-off.
November 7, 2026

Data migration is the part of an ERP project that everyone underestimates. The old system has five versions of the same customer, products with no barcodes, VAT numbers in the wrong field, and balances that do not quite tie to the trial balance. If that data goes into Odoo unchanged, the new system inherits every old problem on day one. A disciplined migration, done in rounds with clear owners, is what makes go-live calm.

FlexCode Middle East is part of FlexCode Systems GmbH, an Odoo Silver Partner. We implement Odoo, so Odoo is the system we describe, next to an honest look at the topic itself.

Key points

  • Decide what moves. Master data, opening balances and open items; history stays behind.
  • Clean at the source. Fix duplicates, names and tax numbers before importing.
  • Migrate in rounds. Two or three test migrations before the final one.
  • Reconcile and sign. Totals checked against the old system and signed by owners.

Decide what to migrate

DataMigrate?Notes
Customers and vendorsYes, active onesWith VAT numbers, addresses, payment terms
ProductsYes, active onesCodes, units, taxes, costs, barcodes
Chart of accountsMapped, not copiedTo the Odoo localization
Opening balancesYesTrial balance at cut-over date
Open invoices, bills, chequesYesSo collections and payments continue
Opening stockYesBy product, location, lot and value
EmployeesYesContracts, salaries, leave balances, end of service
Historical transactionsUsually noKeep the old system read-only
Data analyst cleaning records on a laptop
Clean data at the source, or the new system inherits every old problem.

Cleaning rules

  • Merge duplicate customers and vendors, keeping one master record.
  • Store names in both Arabic and English where documents need both.
  • Validate VAT and tax registration numbers: 15 digits in Saudi Arabia and the UAE, 9 digits in Egypt.
  • Complete addresses with building number, street, district and postal code for e-invoicing.
  • Give every stocked product a unique code and unit of measure.
  • Archive customers and products with no activity in two years instead of migrating them.

Saudi e-invoicing requires buyer details such as VAT number and a structured national address on standard tax invoices. Clean these before go-live, not after the first rejected invoice.

The order of imports

  1. Configuration: companies, taxes, chart of accounts, warehouses, users.
  2. Contacts: companies first, then individual contacts linked to them.
  3. Products, categories, units, pricelists and vendor prices.
  4. Employees and contracts.
  5. Opening stock quantities and values.
  6. Opening trial balance, with receivables and payables cleared to open items.
  7. Open invoices, bills and post-dated cheques.

Opening stock value must agree with the ledger; see inventory valuation in Odoo. Cheques are covered in cheques in Odoo.

Test rounds and reconciliation

  1. Round 1: structure test on a copy
  2. Fix and clean
  3. Round 2: full dry run with reconciliation
  4. Users test with migrated data
  5. Final migration at cut-over
  6. Reconcile and sign off

After each round, totals are compared with the old system: number of customers and products, total receivables and payables by party, stock quantity and value by warehouse, and the trial balance by account. The finance lead, the warehouse lead and the sales lead each sign off on their part. Only then is the old system frozen.

2 to 3

Test rounds before the final

0

Unexplained differences at sign-off

3

Owners: finance, stock, sales

Read-only

Old system after cut-over

Source-specific guides: from Excel, from QuickBooks or Tally, from Zoho. Then follow the go-live checklist.

Migrate cleanly with FlexCode

We scope what moves, give you cleaning templates, run test rounds, reconcile every total with your team and sign off before go-live.

Book a free call

Frequently asked questions

What data should I migrate to Odoo?

Active master data, opening balances, open documents and opening stock.

Should I migrate historical transactions?

Usually not; keep the old system read-only or import summary balances.

How many test migrations are needed?

Two or three before the final migration.

Who should clean the data?

The business owners of each area, with templates from the partner.

How do I know the migration is correct?

When totals reconcile with the old system and owners sign off.

Talk to us about how Odoo fits your business. Book a free call

Run invoicing, stock and accounts from one system.

FlexCode Middle East implements Odoo in Arabic and English for companies in Egypt, Saudi Arabia and the UAE.