Errors occurring when importing into Odoo 19 often imply just one thing: the information in the file that you use does not meet Odoo's requirements in some way. This can mean the absence of a certain field, its incorrect format, duplication of data, or a reference to an inexistent record. The great thing about most import errors is that they are easily solvable once you find out their source.
For those of you who upload customers, products, invoices, stock information, or other mass data, this guide will be very useful in solving your problems with importing into Odoo.
Why Import Errors Happen in Odoo 19
Many users believe that importing only involves uploading an Excel sheet. But that’s far from the case.
Once you’ve imported your document, Odoo will validate every single row against the conditions of the destination model.
As such, a single wrong value may bring the entire process to a halt.
Some of the most common causes include:
- Required columns are missing
- Date or number values are invalid
- Customer or product names cannot be matched
- Selection fields contain unsupported values
- User permissions are limited
- Custom rules block the data
In most cases, the issue is in the file, not in Odoo itself.
How to Find the Real Import Problem
The quickest way to solve the import issue is to carefully read the message instead of uploading the file over and over again.
Odoo will generally provide information about:
- Which line fails
- Which field caused the error
- What value was not accepted
- Whether there was a related record missing
- Whether access rights prevented the operation
A Better Way to Test
Instead of importing 5,000 rows immediately, try a file with 3 or 4 rows first. If something is broken, you will find it faster and fix it with less effort.
Common Import Errors in Odoo 19 and How to Fix Them
1. Missing Required Fields
There are required fields, and their absence may cause Odoo not to create the record at all.
Example
- You try to import contacts, but fail to provide a Name field.
Solution
- Add the missing field,
- Ensure that cells are filled
- Delete rows where there are blank cells on the sheet
2. Wrong Data Type
Each field has a specific data type, and mixing text into a number field, etc., is an error.
Example
- Unit Price = abc
- Quantity = five
- Date = 32/12/2026
Solution
Input valid numbers like:
- Number: 15, 99.50
- Date: 2026-04-25
- Boolean: True or False
- If the field has mixed types of data, clear it and import again.
3. Related Record Doesn’t Exist
This problem occurs if your file has a reference to a record that cannot be found by Odoo.
Example
- You have a sales order that has a reference to a contact that wasn’t imported yet.
Solution
- Import the contact first,
- Check names for typos
- Remove unnecessary space characters
- Using External IDs whenever possible
- This problem often happens during migrations.
4. Duplicate Records
In some cases, importing works, but the outcome is a mess of duplicate records.
Example
- A vendor occurs thrice with slight variations in names
Solution
- Normalize names before import
- Utilize unique values such as email or reference
- Utilize the External ID for the update
- Ensure to clean duplicates from the source file
5. Invalid Selection Value
In some cases, only a selection of predetermined values can be inserted in a particular field.
Example
Order status accepts the following values:
However, your file contains Completed.
Solution
- Ensure to use the values predetermined in Odoo. When in doubt, view the form view and see the list of allowed values.
6. Permission Errors
The file may be accurate; however, the user attempting to import does not have the appropriate level of permission.
Solution
See if the user can:
- Create records
- Update records
- Import records
- Access related models
When importing sensitive information, it is recommended to use an administrator account.
7. Validation Rule Blocking Import
Odoo and customized Odoo modules may contain validation rules for rejecting invalid business data.
Example
- Negative quantity not allowed
- Duplicate internal reference not allowed
- End date earlier than start date
- Invalid tax combination
Solution
- Change the source data to conform to the validation rule.
Odoo 19 import errors occur frequently, although most of them happen due to faults in the import file and not in Odoo itself. Spending a little bit of time to examine your data, check for any validation issues with fields, and test on a small sample will save you lots of time during the importing process. Having knowledge of the most frequent import errors and how to deal with them will help you do a better job of importing clients, products, bills, and other business information.
To read more about Overview of Error Management in Odoo 19, refer to our blog Overview of Error Management in Odoo 19.