Looking for honest answers from people doing this every day. When a client hands over their legacy data in Excel — product SKUs, customer records, stock lists — what's your process before it touches Odoo? Specifically interested in how you handle: Product IDs converting to scientific notation (8.91E+12) Dates turning into serial numbers (44796) Leading zeros stripped from SKU codes Trailing spaces breaking import matching Odoo's test import catches structural errors but not content corruption

Hello, Yes this is a very common issue in real-world Odoo implementations, especially with legacy Excel data. In most projects, the safest approach is to treat data preparation as a separate validation step before import. Typically this includes: Converting Excel files to clean CSV format Forcing text formatting for SKUs, barcodes, and IDs Validating dates before import Trimming leading/trailing spaces Running duplicate and consistency checks Performing small test imports first You're absolutel

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

How do you handle Excel data corruption before an Odoo import?

import data csv implementation dataerror spreadsheet

1 Vastaa

550 Näkymät

Jason Beedle

Looking for honest answers from people doing this every day.

When a client hands over their legacy data in Excel — product SKUs, customer records, stock lists — what's your process before it touches Odoo?

Specifically interested in how you handle:

Product IDs converting to scientific notation (8.91E+12)
Dates turning into serial numbers (44796)
Leading zeros stripped from SKU codes
Trailing spaces breaking import matching

Odoo's test import catches structural errors but not content corruption from Excel. Most people I've spoken to use custom scripts or manual checking.

Curious whether there's a consistent approach across the community or whether everyone is solving this differently.

Jason Beedle

Tekijä

Thanks — this is exactly the pattern I keep hearing. The fragmentation is the problem. I've built something that handles all of this automatically — scientific notation, leading zeros, date coercion — in 60 seconds, with a Certificate of Integrity as the output. Happy to share if useful

Zehntech Technologies Inc.

Hello,

Yes this is a very common issue in real-world Odoo implementations, especially with legacy Excel data.

In most projects, the safest approach is to treat data preparation as a separate validation step before import. Typically this includes:

Converting Excel files to clean CSV format
Forcing text formatting for SKUs, barcodes, and IDs
Validating dates before import
Trimming leading/trailing spaces
Running duplicate and consistency checks
Performing small test imports first

You're absolutely right that Odoo’s import validation mainly checks structure, not silent Excel corruption. Because of that, many teams use a combination of preprocessing templates, validation rules, and sometimes custom scripts for large datasets.

There isn’t one universal method across the community, but the overall best practice is definitely: “clean, validate, test import, then migrate.”

Hope this works for you! If you need any help implementing this or want a more optimized approach, feel free to reach out for further discussion.

Regards,

Zehntech Technologies Inc.

santosh.sekwadia@zehntech.com

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How to import CSV data in OpenERP 7.0 import data csv	1 maalisk. 15	11092
IMPORT DATA in OpenERP 7 import data csv	3 maalisk. 15	12233
Adding constant data to a model failure Ratkaistu module import data csv	2 toukok. 23	4441
Lookup multiple values in data csv file odoo v13 data csv	0 syysk. 20	4518
Disable automatic follow when importing res.partner csv import csv	3 kesäk. 20	6760

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!