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.
The problem
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.
The solution
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.
Frequently asked
No sales fog. If your question isn't here, email us and we'll answer it the same way.
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.
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 Purchase Lines from Excel/CSV
Bulk-import purchase order lines from Excel or CSV with flexible mapping and a validating preview, built natively on Odoo.
Buy on Odoo App Store