POS Order Import
Access
Ebitda Solutions
Import POS Orders via Excel/CSV | Auto Tax & Totals Calculation | Smart Product & Session Matching
Seamlessly Import POS Orders into Odoo from Excel or CSV.
POS Order Import Access is a custom Odoo 19 module built by Ebitda Solutions that enables the standard Odoo import functionality for Point of Sale orders. It allows businesses to bulk-import historical or external POS orders directly via Excel/CSV files — with intelligent handling of sessions, customers, products, taxes, and order line subtotals. The module auto-calculates tax amounts and order totals post-import, resolves tax rates by name or numeric value, and prevents common import errors like duplicate product variant matches.
KEY HIGHLIGHTS
Auto Tax & Total Calculation
Automatically computes price_subtotal, price_subtotal_incl, amount_tax, and amount_total for every imported order — no manual calculation needed.
Standard POS Import Enabled
Unlocks the native Odoo import button on the POS Orders list view — import records just like any other Odoo model using Excel or CSV files.
Native Import Button on POS Orders
Enables Odoo's standard "Import records" option in the POS Orders list view gear menu — no custom wizard needed, works just like any other model.
Auto Tax & Subtotal Computation
Post-import hook recalculates all order line subtotals and order totals using Odoo's tax engine — tax-inclusive and tax-exclusive amounts are always accurate.
Excel Tax Rate Resolution
Resolves tax values stored as Excel decimals (e.g. 0.15 → 15%) or as percentage strings. Prioritizes Sales taxes and falls back to any active matching tax automatically.
Product Variant Deduplication
Prevents "multiple matches found" import errors by returning only the first matching product variant during import context — keeps bulk imports clean and error-free.
Before Module — No Import Option Available
Without this module, the POS Orders gear menu only shows "Export All" and "Spreadsheet" — there is no "Import records" option. This is Odoo's default behaviour which deliberately restricts POS order imports. This module safely re-enables it with proper field handling.
POS Orders List — Import Records Option Enabled
The gear (⚙️) menu on the POS Orders list view now shows the "Import records" option — unlocked by this module. Previously this option was absent from POS Orders. Clicking it opens the standard Odoo import wizard.
Import Wizard — Field Mapping & Validation
The standard Odoo import wizard maps Excel/CSV columns to POS Order fields: Session, Customer, Date, Order Lines/Product, Order Lines/Quantity, Order Lines/Unit Price, and Order Lines/Taxes. The "Everything seems valid" banner confirms the file is ready to import. Tax values like 0.15 are automatically resolved to 15% by the module.
Imported Records — Orders with Computed Totals
After a successful import, the "Imported records" view shows all 5 imported POS orders with their Session (ABC/00001), Date, Point of Sale (ABC), Receipt Number, and automatically computed Total amounts — including $209,790.36, $159,399.72, $112,962.41, $207.00, and $86.25. All order totals are calculated by the module's post-import hook, not entered manually.
🛒 Native Import Records Button on POS Orders List View
🧾 Auto Calculation of price_subtotal, price_subtotal_incl, amount_tax & amount_total
🔢 Excel Tax Rate Resolution (0.15 → 15%) — Name & Numeric Matching
📦 Product Variant Deduplication — Prevents "Multiple Matches" Import Errors
🔗 Order Line Name Search Disabled — Prevents Transactional Data Cross-linking
💡 Defaults Product List Price When price_unit is Missing During Import
📅 Flexible Date Field — Supports Both date and date_order Column Names in Excel
✅ Sales Tax Priority — Prioritizes Sale-type Taxes, Falls Back to Any Active Tax
Release 19.0.1.0.0
Initial Release- Enable standard Odoo import functionality for POS Orders list view
- Auto-calculate order line subtotals (price_subtotal & price_subtotal_incl) on import
- Post-import recalculation of amount_tax and amount_total per order
- Tax resolution by name, percentage string, or Excel decimal format (e.g. 0.15 → 15%)
- Prioritize Sale-type taxes; fallback to any active matching tax
- Product variant deduplication — returns first match to avoid blocking errors
- Disable order line name_search to prevent transactional record cross-linking
- Flexible date field — supports "date" or "date_order" column header in import file
- Default product list price when price_unit is missing from import row
- Zero-safe defaults for amount_tax, amount_total, amount_paid, amount_return
Related Modules
Our Services
| 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 | 473 |
| Technical Name |
esl_pos_import |
| License | LGPL-3 |
| Website | https://www.ebitdasolutions.com |
Please log in to comment on this module