| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Purchase (purchase)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 1022 |
| Technical Name |
cerevantix_import_purchase_lines_from_excel_csv |
| License | OPL-1 |
| Website | https://cerevantix.com |
| Versions | 17.0 18.0 19.0 |
Purchase orders from a spreadsheet, in seconds
Import purchase order lines from any Excel or CSV file with flexible column mapping, product matching by code, barcode or name, and a validating preview you confirm before anything is written.
Suppliers send quotes and reorder sheets as spreadsheets, and a 200-line order can take an hour to re-key by hand — with transposition mistakes on quantity, price, or tax. Odoo's generic import exposes internal field names, and rival apps demand rigid column layouts with no preview.
Drop in the file, map any column to any field, and review a dry-run preview of every line, tax, and total — with a consolidated list of problem rows — before you commit. Confirm once and the purchase order is built for you.
Everything a bulk import needs
Every capability below is implemented in the module.
Bulk Excel & CSV Import
Upload CSV, XLS, or XLSX files and turn hundreds of supplier lines into purchase order lines at once, eliminating manual re-keying.
Flexible Column Mapping
Map any column to any field in any order. Headers are auto-detected on upload, so real-world spreadsheets import as-is — no fixed layout required.
Validating Dry-Run Preview
See exactly what will be created — every line, tax, and total — and explicitly confirm before a single record is written to the order.
Consolidated Error List
Every problem row is reported at once with its row number, value, and reason, so you fix the whole file in one pass instead of iterating blindly. Failed rows export to CSV.
Product Matching
Match products by internal reference, barcode, or name — or let the auto mode try each in turn — so inconsistent supplier spreadsheets still resolve.
Automatic Taxes & Totals
Taxes resolve by name or percentage, and each line's discount, subtotal, tax, and total are computed automatically for a financially correct order.
Optional Product Creation
When an identifier does not match, choose to create the product automatically or report it — a clear decision at import time, off by default.
New or Existing Orders
Import into a brand-new RFQ or append lines to an existing draft order, keep the file row order, and optionally confirm the purchase order in the same step.
Reusable Mapping Profiles
Save a mapping and its options as a named profile for each recurring supplier format, and download a sample template that matches your configuration.
How it works
Upload & Map
Pick the vendor, drop in the file, and confirm the auto-detected column mapping.
Review the Preview
Check matched products, taxes, and totals, and read the list of any problem rows.
Import
Confirm to build the purchase order lines with correct quantities, prices, and taxes.
Save & Reuse
Store the mapping as a profile so the next import from that supplier is one click.
See it in action
Real screens from the module, captured on Odoo 17.
Choose the vendor, upload the file, set your options, and map any column to any field — columns are auto-detected on upload.
The validating preview: summary totals, ready rows, warnings, and errors — each with its row number and reason — before you commit.
A clear confirmation of how many lines were imported and into which purchase order.
The finished RFQ — every imported line with its quantity, discount, taxes, and computed totals, ready to review and send.
Saved mapping profiles, one per recurring supplier format.
A profile stores every option and column mapping, so repeat imports are one click.
Frequently asked
Do my spreadsheet columns have to be in a fixed order?
No. You map any column to any field, and headers are auto-detected on upload, so files import as they are — there is no required layout.
What happens to rows with errors?
The preview lists every problem row with its number, value, and reason, and valid rows still import. You can export the failed rows to CSV, fix them, and re-import.
How are products from the file matched to Odoo products?
By internal reference, barcode, or product name — individually, or with an auto mode that tries each in turn. Unmatched rows can be reported or, if you choose, create a new product.
Can I import into an order that already exists?
Yes. Import into a new RFQ or append the lines to any existing draft order, and optionally confirm the purchase order in the same step.
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.
Explore our other apps
A growing suite of Odoo apps.
Empowering growth through technology.
Bulk-import purchase order lines from Excel or CSV with flexible mapping and a validating preview, built natively on Odoo.
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Purchase (purchase)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 1022 |
| Technical Name |
cerevantix_import_purchase_lines_from_excel_csv |
| License | OPL-1 |
| Website | https://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