OdooWiki OCA HUB

Stock Picking Import Serial Numbers

stock_picking_import_serial_number folder_open OCA/stock-logistics-workflow open_in_new
stock License: AGPL-3

This module extends the functionality of stock module to allow import serial numbers from an excel file.

auto_awesome What this module does

AI-generated from the code · Odoo 18.0

Import serial numbers (and optional packages) for incoming stock transfers from an Excel file, instead of typing each one by hand. Configure which columns hold the product, serial number and package.

This module adds an "Import S/N" button on incoming stock transfers (stock.picking) that are ready to be processed. It opens a small wizard where you upload an Excel file (.xls or .xlsx) containing the serial numbers to register.

  • The wizard reads the first sheet of the file and matches each row to a product, using either the product Reference or the Barcode, depending on your setting.
  • For incoming transfers, it fills the serial number on the existing detailed operations lines; if a line already has a serial number, it is kept unless you tick "overwrite serial".
  • For other transfer types, it creates new detailed operation lines with the serial number.
  • If a package name is given in the file, the package is reused when it already exists for the company, otherwise it is created.

In Settings, under the production lot section, a new "Import S/N" block lets you define the default search field (Reference or Barcode) and the column indexes for product, serial number and package in the file. These defaults are pre-filled in the wizard.

The import is refused if the transfer type does not allow creating lots/serial numbers, or if no file is uploaded. The feature is available to all internal users.

Depends on

stock
Models and fields (2)
  • res.config.settings · extends an existing modeldefault_sn_serial_column_index (Column index for S/N), default_sn_package_column_index (Column index for Package), default_sn_product_column_index (Column index for product), default_sn_search_product_by_field (Search product by field)
  • stock.picking.import.serial.number.wiz · new modelfilename, data_file (File to import), picking_ids, overwrite_serial, sn_serial_column_index (Column index for S/N), sn_package_column_index (Column index for Package), sn_product_column_index (Column index for product), sn_search_product_by_field (Search product by field)

Text generated by AI (DeepSeek) from reading the Odoo 18.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 6 confirmed, 3 with no information of 9 versions.

Sources · Odoo 17.0

Confirmed on 2026-11-03 in branch 17.0 of OCA/stock-logistics-workflow.

terminal Installation and usage

OCA documentation · Odoo 18.0

Configuration

Source · Odoo 18.0

To configure this module, you need to:

  • Go to a Inventory \> Configuration \> Settings.
  • Choose the product field which yo want to search products.
  • Choose the file column index where product reference is stored.
  • Choose the file column index where serial number reference is stored.

Usage

Source · Odoo 18.0

To use this module you need to:

  • Go to Inventory \> Incoming and create one.
  • Click on button "Import S/N".
  • Select an excel file.
  • Click on import button.

No verified information in OCA: Installation.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.