Start here · Article 04
Data import
Applies to Odoo 19 · 20
Partners, products and prices from the old system come into Odoo by import from Excel or CSV files. Every list in Odoo has an import option: upload the file, match the columns to the Odoo fields, test and import. The test shows the errors before anything is written to the database.
When to use
- You go live on Odoo and bring the customers, suppliers and products from the old program.
- You add a large list of new products from a supplier.
- You update prices from a list received in Excel.
Before you start
- The company is set up: see Company setup and Chart of accounts, journals and taxes.
- The product categories (with their accounts) exist in Odoo: see the Inventory chapter, Configuration article.
- Export the data from the old system to Excel or CSV, with a header row.
Steps in Odoo
1. Prepare the file
One file per type of data: partners, products, prices. The first line contains the column names. Keep a unique code on each row (the CIF for companies, the internal reference for products): you will recognise the records by it in later imports.
2. Open the list and choose import
Open the list you import into (for example Contacts for partners), then from the gear menu next to the list title choose:
Odoo 19
Import records.
Odoo 20
Import.
3. Upload the file
Odoo 19
Click Upload File and choose the file.
Odoo 20
Click Upload and choose the file.
Odoo shows the file columns and the Odoo field proposed for each.
4. Match the columns
Check each column and choose the right Odoo field where the proposal is missing or wrong. Columns with no match are left unimported.
5. Test
Click Test. Odoo checks the whole file and shows the errors per row (unknown value, missing required field). Correct the file and test again until there are no errors.
6. Import
Click Import. The records appear in the list.
Variants
Order of imports
First import what other data uses: product categories before products, partners before customer pricelists. Opening balances come last: see Opening balances.
Romanian company partners
Fill in Tax ID and Country. With the Romania - Partner Create by VAT module, missing data (name, address) can be filled in later from ANAF by opening the partner form. The Romania - Partners Unique module prevents two forms with the same CIF.
Updating existing records
First export the list from Odoo with the external ID column, change the values in Excel and import the file back: Odoo updates the records instead of creating new ones.
Common mistakes
- The same partner imported twice. Duplicate forms appear and the balances are split between them. Clean up duplicates in the file before importing.
- Product categories spelled differently. "Marfuri" and "Mărfuri" are different categories for Odoo; products end up in the wrong category, with other accounts.
- Direct import, without a test. A file with errors can create half-finished records. Always test.
- A large file at once. For tens of thousands of rows, split the file into chunks.
For the accountant: what to check after the import
Checks
- Company partners have the correct CIF and the country filled in: the fiscal position, e-Factura (the Romanian e-invoicing system) and D394 (the domestic sales and purchases informative return) depend on them.
- Products have the correct category: the income, expense and stock accounts come from the category.
- Products have the right tax (goods "G" or services "S").
Importing partners and products does not create journal entries. Balances are taken over separately: see Opening balances.