Turn spreadsheets into sales orders in minutes, not hours

Map any column layout, preview every order and line before it is created, and catch duplicates and invalid rows automatically. Import from Excel or CSV with confidence — no re-keying required.

The problem

Bulk orders arrive as spreadsheets from wholesale customers, e-commerce exports, and legacy systems, and someone on the sales team has to re-key every header and line by hand. Odoo's generic import tool is unforgiving about column order, gives cryptic errors after the fact, and does not understand what a sales order needs, so one bad row can jeopardize an entire batch.

The solution

A guided wizard maps the file to Odoo fields automatically, whatever the column order, then shows a full preview of every order and line before anything is written. Row-by-row validation flags errors, duplicates, and formatting issues up front, so valid rows import with confidence and only the rest need fixing.

Capabilities

Everything a bulk sales order import needs

Every capability below is implemented in the module.

01

Visual Column Mapping

Any column order is accepted. The wizard auto-detects which Odoo field each column belongs to, and every mapping can be adjusted by hand.

02

Full Orders or Lines Only

One wizard handles both cases: create complete orders with headers and lines, or append imported lines to an existing draft or quotation.

03

Pre-Import Preview

See a validation summary of total, valid, error, and duplicate rows before anything is written, so nothing is created blind.

04

Smart Product Matching

Match products by name, internal reference, or barcode, with auto-detection of which identifier a column holds.

05

Duplicate Detection

Rows that look like an existing order are flagged in the preview, with an option to skip duplicates automatically on import.

06

Skip or Block Invalid Rows

Choose to skip invalid rows and import the good ones, or block the whole import until the file is fixed — your call, every time.

07

Reusable Mapping Profiles

Save a column mapping and product-match preference as a named profile, then apply it instantly to future imports from the same source.

08

CSV and Excel, Equally

Reads .csv and .xlsx files with delimiter and encoding detection, plus a downloadable sample template for either format.

09

Import History & Audit Trail

Every run is logged with row counts, state, and notes, with a smart button straight to the orders it created.

Workflow

How it works

1

Upload your file

Choose CSV or Excel, pick full orders or lines only, and download a template if you need one.

2

Map your columns

Columns are auto-matched to Odoo fields; adjust as needed and optionally save the mapping as a profile.

3

Preview & validate

Review every order and line, with counts of valid, duplicate, and error rows before you commit.

4

Import & verify

Confirm to create the records, then drill into the import history or jump straight to the new orders.

Questions

Frequently asked

No sales fog. If your question isn't here, email us and we'll answer it the same way.

No. The wizard reads the header row and auto-matches each column to an Odoo field regardless of order; you can adjust any mapping manually and save it as a reusable profile.

Get the app

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 Sales Orders from Excel/CSV

Import sales orders and order lines from Excel or CSV with a guided wizard that maps any column layout, previews every row, and matches products by name, reference, or barcode.

Buy on Odoo App Store