Import Stock Inventory With Lot/Serial Number from CSV/Excel file

About Module

This module is useful to import stock inventory with lot/serial number from CSV/Excel file.


  • v13.0
  • v12.0
  • v11.0
  • v10.0
  • v9.0
  • v8.0


  • 1) Easy to import.
  • 2) Import CSV or excel.
  • 3) Import stock inventory by product Name, Barcode &Internal Reference.
  • 4) Import Lot/Serial Number and also create new Lot/Serial Number if never exist.
  • 5) No special configuration required, install it, use it.
  • 6) This module saves your important time.
  • 7) It reduces human efforts.


1) You will receive the link to download the zip file of the module pls download it.

2) Extract the zip file, you will see folder named ‘sh_import_inventory_with_lot_serial’.

3) Copy and paste this folder inside your Odoo Addons path / Custom Addons Path.

4) Now, open the odoo as Developer Mode.

5) Go to Apps menu and click on ‘Update Modules List’, Press Update Button.

6) In the search bar, search ‘sh_import_inventory_with_lot_serial’.

7) Click on ‘Install’ to install it.


 First, you need to tick the "Import Inventory With Lot/Serial Number" group in order to import stock inventory with lot/serial number.

"Import Inventory With Lot/Serial Number" menu in operations.

When you click "Import Inventory With Lot/Serial Number" menu, the wizard will open that looks like below.

Success message looks like below it shows successfully imported records and also provides a list of unimported records with row number in sheet and relative details of data invalidation.

 The following fields are imported.

New lot/Serial Number created if never exist.

Your CSV file format must match like below.

Your Excel file format must match like below.