Fill a quotation, sales order or purchase order from an Excel or CSV file: products by reference, barcode or name, every row checked first, with a template.
No reviews yet0 salesby TAQNIXUpdated Oct 23, 2026
A customer sends a spreadsheet with 150 items and you type them in one by one. Import Order Lines from Excel / CSV adds them to a quotation, sales order or purchase order from the file.
A button on quotations and draft purchase orders, with the prices, discounts and taxes of Odoo.
48 automated tests: Excel and CSV files, the three ways to find a product, the checks, the duplicate options, purchase orders and vendor codes, the template, and access rights.
Illustrated guide in English and Arabic and an Arabic translation of the module.
Odoo 19.0 Community with Sales and Purchase.
The files in the archive you can download after you buy.
No reviews yet. Bought this item? Be the first to review it.
Install and use it in a few lines.
wizard = env['taqnix.order.import'].create({'res_model': 'sale.order', 'res_id': order.id, 'file': base64_content, 'filename': 'lines.xlsx', 'duplicates': 'add'})
wizard.action_check()
wizard.action_import()Setup, settings and troubleshooting, written by the author.
Every release, newest first.
Excel (.xlsx, .xls) and CSV (comma, semicolon or tab separated, UTF-8). The first row is the header.
By internal reference, then barcode, then product name, without regard to case. On a purchase order the vendor's product code also works.
A column for the product (Internal Reference, Barcode or Product) and Quantity. Price, Discount, Description and Unit are optional.
The price in the file if there is one; otherwise the price Odoo computes from the price list (sales) or the vendor (purchases).
You choose: import the valid rows only, or nothing at all. The check always comes first and shows the reason of each error.
Add a new line, add to the quantity of the existing line, or skip the row.
Yes. Download the template in the wizard: an Excel file with the right headers.
Yes. Arabic headers are recognised, everything is translated and works right to left, and the documentation is in Arabic too.
Compare vendor quotations on one grid in Odoo Community: an RFQ per vendor from one list, the lowest price highlighted, award line by line or to one vendor, with the savings and a comparison sheet.
Customer returns in Odoo Community: an RMA from the sales order, the return receipt, stock back or to scrap, then a credit note or a replacement, with an authorisation slip.
Print payment, receipt and journal vouchers from Odoo Community: the amount in words in English or Arabic, the invoices settled, the payment details and the signature boxes.
The aged receivable and aged payable reports for Odoo Community: each customer or vendor by age of the open balance, the invoices behind each figure, as of any date.
Customer returns in Odoo Community: an RMA from the sales order, the return receipt, stock back or to scrap, then a credit note or a replacement, with an authorisation slip.
Change the sales price or cost of many products at once: percentage, amount, fixed price or margin, rounding and .99 endings, an editable preview, a history and one-click undo.
See on every sales and purchase order line the last price this customer paid or this vendor charged, the difference in percent, and the full history in one click.
Set targets for salespeople and teams, and see at once what was invoiced or sold, the percentage, what is left and who is on track.
Import Order Lines from Excel / CSV for Odoo 19 – Sales and Purchase Orders, Checked Before Import
$34.00