Map, preview, and import with confidence
A guided, resumable wizard that maps any spreadsheet to Odoo contacts, validates before it commits, and recovers cleanly from large-file failures.
The problem
Customer and vendor spreadsheets rarely match Odoo's expected columns. Odoo's native import forces users to reformat their file first, offers no visual mapping aid, and times out or silently truncates on large files — forcing painful manual splitting with no way to resume a failed run.
The solution
Import Customers & Vendors lets you map your existing columns to Odoo fields visually, previews exactly what will be created before you commit, and auto-batches large files with a resumable checkpoint — so a stalled import continues instead of restarting from zero.
Everything a real migration needs
Every capability below is implemented in the module.
Visual Column Mapping
Map any spreadsheet header to an Odoo field on screen — no rigid predefined template required.
Auto-Detected Field Suggestions
Headers like "E-mail" or "Pays" are pre-matched to the right Odoo field automatically, so you confirm rather than build mappings from scratch.
Sample Preview & Validation
See a sample of interpreted rows before committing, with a mandatory-field gap alert if required data is not mapped.
Typed Field Conversion
Text, Integer, Float, Boolean, Date, Many2one, Many2many, and Image columns are all converted to the correct Odoo type.
Relationship Resolution with Fallback
Many2one and Many2many lookups (country, state, tags) resolve by name, with a clear fallback note when a value cannot be matched.
Duplicate Detection & Update Modes
Match existing contacts by email, tax ID, reference, or name, then choose to create only, update only, or both.
Vendor-to-Product Linking
Link vendor rows to existing products by internal reference, barcode, or name, creating validated supplier price records automatically.
Image Import
Attach a contact photo from a URL or an embedded value in the same column-mapped operation as the rest of the data.
Batching, Progress & Resume
Large files auto-batch at a recommended size, show live progress, and resume a stalled import instead of restarting — with a downloadable per-row error report pinpointing every failure.
How it works
Upload
Choose Customers, Vendors, or both, then upload your CSV, XLS, or XLSX file.
Map & Suggest
Confirm the auto-suggested column-to-field mapping, adjusting types and relations where needed.
Preview & Validate
Review interpreted sample rows and catch mandatory-field gaps or unresolved lookups before anything is written.
Import & Resume
Start the batched import, watch live progress, and resume automatically if it stops partway through.
Frequently asked
No sales fog. If your question isn't here, email us and we'll answer it the same way.
CSV, XLS, and XLSX, with automatic encoding (UTF-8, Latin-1, Windows-1252) and delimiter detection so real-world exports parse correctly.
Buy it on the Odoo App Store
Purchase, download and install directly from the official Odoo Apps Store — you'll always get the latest supported build.
Import Customers & Vendors
Guided CSV, XLS and XLSX contact imports with visual column mapping, auto-detected field suggestions, sample validation, duplicate handling and batched, resumable runs.
Buy on Odoo App Store