Bulk import pricelists, the safe way
Import sales, vendor, and product pricelists from Excel or CSV with guided column mapping, a preview before anything is written, and row-level errors you can actually act on.
Supplier quote sheets and rate cards arrive as spreadsheets, but Odoo's native import expects you to already understand External IDs and the pricelist data model. A single mismatched row fails the whole file with a generic error, and there is no way to preview what will happen before you commit.
A guided wizard that auto-detects your columns, shows exactly what will be created or updated before you commit, and reports every failed row with a plain-language reason — with rollback and resume built in for when things go wrong.
Everything a bulk pricelist import needs
Every capability below is implemented in the module.
Excel & CSV Import
Upload XLS, XLSX, or CSV files with automatic delimiter and encoding detection, so the file just works.
Guided Column Mapping
Source columns are auto-detected and pre-mapped to pricelist fields, with a sample value shown for every column so you confirm with confidence.
Sales, Vendor & Product Pricelists
One app covers all three pricelist types, so you are not buying and juggling separate apps for sales and vendor pricing.
Preview Before Commit
See the exact count of rows to create versus update, and every row that cannot be matched, before a single record is written.
Row-Level Error Reporting
Every failed row gets its own actionable message, such as which product reference or barcode could not be matched, instead of one generic failure.
Rollback & Resume
Undo a completed import in one click, or resume a stopped one from the last successful row — a large file is never lost to a single bad cell.
Flexible Product Matching
Match rows to products by internal reference, barcode, or name, so the import works with whatever identifiers your source file already has.
Create-or-Update Mode
Re-running an import updates existing pricelist rules instead of duplicating them, matched by pricelist, product, and minimum quantity.
Full Import Audit Trail
Every import is logged with who ran it, when, from which file, and the created / updated / failed counts for later review.
How it works
Upload
Pick a pricelist type, attach your Excel or CSV file, and set the destination and import mode.
Map Columns
Confirm the auto-detected column mapping against the target pricelist schema.
Preview
Review the create / update / error breakdown row by row before anything is written.
Import & Track
Run the import and follow live progress, then audit, roll back, or resume from the history log.
See it in action
Real screens from the module, captured on Odoo 17.
Upload step: choose Sales, Vendor, or Product pricelist, attach the file, and set the destination, import mode, and price safeguards.
Map Columns step: all source columns auto-detected against the Sales Pricelist schema — pricelist, product, minimum quantity, computation method, fixed price, discount percentage, and validity dates.
Preview step: rows to create versus update and zero errors, with a full row-by-row outcome table and resolved product names — before anything is committed.
Imported step: the wizard confirms completion with a direct link to the resulting audit log.
Import History list spanning every status: Done, Queued, and Failed — a complete audit trail of who imported what and when.
A finished import's detail: created / updated / failed counts and a Roll Back button to undo the whole import in one click.
A stopped import's detail: a clear alert banner with Resume and Roll Back buttons, so a partial failure is never a dead end.
Import Rows grouped by status: a row-level, actionable error message sits right next to the successfully created rows — no generic whole-file failure.
Frequently asked
Does it support both Excel and CSV pricelist imports?
Yes. XLS, XLSX, and CSV files are all supported, with delimiter and encoding auto-detection for CSV files.
What happens if my import file has a bad row?
The preview step flags it before anything is written. If an import stops partway through, every row processed so far is logged, and you can resume from the last successful row or roll back the whole import.
Can I import sales, vendor, and product pricelists with one app?
Yes. All three pricelist types share the same wizard, mapping screen, and preview — you do not need separate apps for each.
Do I need to know External IDs to update existing pricelist rules?
No. Create-or-update mode can match existing rules by pricelist, product, and minimum quantity, so non-technical users can safely re-import an updated file without ever touching an External ID.
Get in Touch
Have questions or need customization? Every purchase includes 30 days of free support — we are here to help.
Visit Our Website
www.cerevantix.comExplore our apps, services, and portfolio.
Empowering growth through technology.
Bulk import sales, vendor, and product pricelists from Excel or CSV, with preview, row-level errors, and rollback built in.
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 2233 |
| Technical Name |
cerevantix_import_pricelist |
| License | OPL-1 |
| Website | https://www.cerevantix.com |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module