Bulk-import POS orders safely from any spreadsheet
Upload Excel or CSV, map your own columns, preview every row before anything is written, and keep a full audit log of every import. Built for Odoo 19 Point of Sale.
Loading historical or externally-held POS sales into Odoo usually means hours of manual re-entry, or a rigid import tool that demands one exact spreadsheet layout, enforces a single date format, and fails loudly mid-import with no way to see what will happen before it happens.
A guided four-step wizard maps your own columns, runs a full dry-run preview showing every row's status before anything is committed, and leaves a persistent audit log behind — so bulk loads stay transparent, safe and easy to reconcile.
This app speaks your language.
Tell us the language your team works in and we translate this module for you, free of charge — so everyone works in the language they know best.
Request my free translation →No hidden fees. No subscription.
Everything a bulk POS import needs
Every capability below is implemented in the module.
Excel & CSV Import
Upload XLS, XLSX or CSV files and bulk-create many orders with multiple lines in a single operation.
Your Own Column Layout
Map spreadsheet columns to Odoo fields by header text, column index or Excel letter — no fixed template required.
Dry-Run Validation Preview
Review every row's OK, Warning, Error or Skipped status, plus resolved product/customer matches and computed totals, before a single record is written.
Per-Row Error Reporting
Failed rows list exactly what went wrong, so you can fix the source file and re-upload instead of guessing from a raised exception.
Tolerant Date Parsing
Accepts common real-world date and time formats instead of enforcing one rigid layout.
Flexible Matching
Products match by name, barcode or internal reference; customers match by name, reference or ID, with auto-creation for customers that do not yet exist.
Duplicate & Conflict Handling
Detects order references that already exist and lets you skip, update or reject them, preventing silent double-imports on re-runs.
Draft or Confirmed Import
Choose whether imported orders land as draft for review or go straight to confirmed/paid, with automatic session handling.
Persistent Audit Log
Every import leaves a log with created/updated/skipped/error counts and a per-order breakdown you can revisit at any time.
How it works
Upload your file
Choose an Excel or CSV file, set the target POS, company and session, and pick your import options.
Map your columns
Match spreadsheet columns to order and line fields by header text, index or Excel letter.
Preview every row
Run the dry-run validation and review OK, Warning, Error and Skipped rows with resolved matches and totals before committing.
Import & audit
Confirm the import and get a persistent audit log with a full per-order breakdown to reconcile against.
See it in action
The four-step import wizard and the audit log it leaves behind.
Step 1 — upload your Excel or CSV file and set the target POS, company, session and import options.
Step 2 — map your spreadsheet columns to order and line fields by header text, index or Excel letter.
Step 3 — the dry-run preview shows every row's OK, Warning, Error or Skipped status with resolved matches and totals before anything is written.
Every import leaves a persistent audit log, with error counts flagged at a glance.
Drill into any log for a full per-order breakdown of created, updated, skipped and error rows.
Frequently asked
Does this import go straight into the POS without any checks?
No. Every import runs through a dry-run preview first, showing the status, resolved matches and totals for every row so you can fix problems before anything is written.
What file formats and date formats are supported?
Excel (XLS, XLSX) and CSV files are supported, along with common real-world date and time formats — you are not forced into one rigid layout.
What happens if an order reference already exists?
The import detects existing references and lets you choose to skip, update or reject the conflicting rows, so re-running an import never silently duplicates orders.
Do I need an in-progress POS session or a pricelist configured first?
No. Unlike some competing apps, this module does not require a pre-existing session or a mandatory pricelist — it works out of the box on a standard Odoo 19 Point of Sale install.
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.
Import POS Orders from Excel — bulk-load historical or external Point of Sale orders from a spreadsheet with a guided wizard, a full dry-run preview, and a persistent audit log.
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Point of Sale (point_of_sale)
• Discuss (mail) • Inventory (stock) • Invoicing (account) |
| Lines of code | 1075 |
| Technical Name |
cerevantix_import_pos_orders_from_excel |
| 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