Skip to content
TAQNIX
Odoo ModulesWordPress PluginsWordPress ThemesShopify ThemesApp TemplatesScripts & UtilitiesBlogSell on TAQNIX
ModuleOdooNew

Inventory Import from Excel / CSV for Odoo 19 Community – Stock Count and Opening Stock

Load opening stock or a physical count from Excel or CSV into Odoo Community: products by reference, barcode or name, locations, lots and serials, checked row by row before it is applied.

No reviews yet0 salesby TAQNIXUpdated Oct 23, 2026

Description

Load your stock count. Check it. Then apply.

The warehouse sent a spreadsheet. Inventory Import loads it in Odoo Community without typing a quantity.

Every row of the file checked before the import

From a spreadsheet

  • .xlsx, .xls and .csv, headers in English or Arabic, in any column order
  • Products found by reference, barcode or name; locations by name; lots and serial numbers used or created
  • Set the counted quantity (a physical count) or add to the on-hand quantity
An import that was applied as inventory adjustments

Checked before anything moves

  • Each row is ready, a warning or an error, with the reason
  • The on-hand, the new quantity and the difference of every row
  • Import the valid rows, or nothing if a row has an error
The check in an Arabic interface

Applied as adjustments

  • A stock move for each product that changes; the rows that already match are left alone
  • Or only set the counts and review them in Physical Inventory
  • A history of each file with the stock moves it made
Upload, check, apply

Tested

46 automated tests: the file and the headers, the checks, the two modes, lots and serial numbers, locations, the adjustments and the access rights.

Inventory import features

Documented

Illustrated guide in English and Arabic and an Arabic translation of the module.

What's included

  • taqnix_inventory_import.zip: the Odoo 19 module (with Arabic translation)
  • Illustrated documentation in English and Arabic (HTML and PDF)
  • Automated tests, licence file (OPL-1) and changelog

Requirements

Odoo 19.0 Community with Inventory.

What's in the download

The files in the archive you can download after you buy.

  • Full source code
  • Documentation
  • Installation guide
  • Automated tests
  • Licence file
  • Changelog

Customer reviews

Write a review

No reviews yet. Bought this item? Be the first to review it.

Usage

Install and use it in a few lines.

imp = env['taqnix.inventory.import'].create({'file': base64.b64encode(csv_bytes), 'filename': 'count.csv',
    'location_id': stock.id, 'mode': 'set', 'apply': True})
imp.action_check()
imp.action_import()
imp.state, imp.changed_count

Documentation

Setup, settings and troubleshooting, written by the author.

Open the documentation

Changelog

Every release, newest first.

v1.0.0

1.0.0 – Initial release

  • Import of stock quantities from .xlsx, .xls and .csv with English and Arabic headers
  • Products by reference, barcode or name; locations; lots and serial numbers
  • Set the counted quantity or add to the on-hand quantity
  • Check of every row before anything moves; apply the adjustments or only set the counts
  • History of the imports with their stock moves, template
  • Arabic translation, automated tests

Frequently asked questions

What files can I use?

Excel (.xlsx, .xls) and CSV files with a header row. The headers can be in English or Arabic and in any order; only a column that tells the product and a Quantity column are required.

How are products found?

By internal reference, barcode or name. If several products match, the row is reported as an error instead of guessing.

Is it a physical count or an addition?

Both: Set the counted quantity makes the quantity of the file the new on-hand quantity, and Add to the on-hand quantity adds it (a negative quantity takes stock out).

Does it handle lots and serial numbers?

Yes. Existing ones are used and missing ones can be created. A serial number accepts the quantity 0 or 1.

Can I check before the stock changes?

Yes. The check shows the on-hand quantity, the new quantity and the difference of every row, and nothing moves until you click Import.

Can I review the counts in Physical Inventory instead?

Yes. Untick Apply the adjustments now and the quantities are only set as counts, for you to review and apply.

Is there a history?

Yes. Each import is kept with its rows, who did it and the stock moves it created; an applied import cannot be deleted.

Does it work in Arabic?

Yes. Everything is translated and works right to left, and the documentation is in Arabic too.

More from TAQNIX

  • ModuleNew

    Shift Roster for Odoo 19 Community – Weekly Employee Scheduling

    Plan who works which shift in Odoo Community: shift templates, a weekly grid per employee, quick assignment, overtime and time-off warnings, publishing with notifications, my shifts and a calendar.

    by TAQNIX
    No reviews yet
    Sales:0$79.00
  • ModuleNew

    Timesheet Approval for Odoo 19 Community – Weekly Sheets, Submit and Approve

    Weekly timesheet approval in Odoo Community: employees submit, managers approve or refuse with a reason, submitted hours are locked, with expected hours, sheets for everybody and a printable sheet.

    by TAQNIX
    No reviews yet
    Sales:0$69.00
  • ModuleNew

    Stock Transfer Requests for Odoo 19 Community – Branch Requests with Approval

    Let branches request stock from another warehouse in Odoo Community: stock shown at the source, approval in full or in part, the internal transfer created for you, and a printable slip.

    by TAQNIX
    No reviews yet
    Sales:0$49.00
  • ModuleNew

    Vendor Rating & Scorecard for Odoo 19 Community – On-time Delivery and Fill Rate

    Know which vendors deliver in Odoo Community: on-time delivery and fill rate from your receipts, quality and service ratings, an overall score, grades and a ranked scorecard.

    by TAQNIX
    No reviews yet
    Sales:0$59.00

Similar items

  • ModuleNew

    Stock Transfer Requests for Odoo 19 Community – Branch Requests with Approval

    Let branches request stock from another warehouse in Odoo Community: stock shown at the source, approval in full or in part, the internal transfer created for you, and a printable slip.

    by TAQNIX
    No reviews yet
    Sales:0$49.00
  • ModuleNew

    Vendor Rating & Scorecard for Odoo 19 Community – On-time Delivery and Fill Rate

    Know which vendors deliver in Odoo Community: on-time delivery and fill rate from your receipts, quality and service ratings, an overall score, grades and a ranked scorecard.

    by TAQNIX
    No reviews yet
    Sales:0$59.00
  • ModuleNew

    RFQ Comparison for Odoo 19 Community – Compare Vendor Quotations and Award

    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.

    by TAQNIX
    No reviews yet
    Sales:0$59.00
  • ModuleNew

    Stock Aging & Dead Stock Report for Odoo 19 – Inventory Age Brackets, FIFO, Value and Slow Movers

    How old is the stock on your shelves? Quantity and value by age bracket, counted first in first out, dead stock flagged, as of any date, in PDF and Excel.

    by TAQNIX
    No reviews yet
    Sales:0$49.00