Stock Picking Import Serial Numbers

stock_picking_import_serial_number
REPOSITORY
REPOSITORYOCA/stock-logistics-workflow
GIT
GIThttps://github.com/OCA/stock-logistics-workflow.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/stock-logistics-workflow/tree/18.0/stock_picking_import_serial_number
VERSION
VERSION 1.0.0
CATEGORY
CATEGORYstock
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSTecnativa, Odoo Community Association (OCA)
MAINTAINERS
MAINTAINERSTecnativa, Odoo Community Association (OCA)
COMMITTERS
COMMITTERSWeblate, OCA-git-bot, oca-ci, eduezerouali-tecnativa
WEBSITE
WEBSITEhttps://github.com/OCA/stock-logistics-workflow
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 19:30:15
ODOO DEPENDENCIES
ODOO DEPENDENCIES odoo/odoo:
    - stock
    - product
    - base
    - mail
    - base_setup
    - web
    - bus
    - web_tour
    - html_editor
    - uom
    - barcodes_gs1_nomenclature
    - barcodes
    - digest
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES xlrd
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
This module extends the functionality of stock module to allow import
serial numbers from an excel file.

Code Analysis

Views touched (3)
XML IDNameModelTypeStatus
res_config_settings_view_form res.config.settings block Inherits stock.res_config_settings_view_form
stock_picking_import_serial_number_wiz stock.picking.import.serial.number.wiz.form stock.picking.import.serial.number.wiz form New
view_picking_form stock.picking button Inherits stock.view_picking_form
Models touched (2)

New fields (4)
  • default_sn_package_column_index Integer
    default=2 default_model='stock.picking.import.serial.number.wiz' string='Column index for Package'
  • default_sn_product_column_index Integer
    default=0 default_model='stock.picking.import.serial.number.wiz' string='Column index for product'
  • default_sn_search_product_by_field Selection
    default='default_code' default_model='stock.picking.import.serial.number.wiz' required=True string='Search product by field' args: [('default_code', 'Reference'), ('barcode', 'Barcode')]
  • default_sn_serial_column_index Integer
    default=1 default_model='stock.picking.import.serial.number.wiz' string='Column index for S/N'
Public methods (0)

No public methods.

New fields (8)
  • data_file Binary
    string='File to import'
  • filename Char
  • overwrite_serial Boolean
  • picking_ids Many2many → stock.picking
    args: 'stock.picking'
  • sn_package_column_index Integer
    default=2 string='Column index for Package'
  • sn_product_column_index Integer
    default=0 string='Column index for product'
  • sn_search_product_by_field Selection
    default='default_code' string='Search product by field' args: [('default_code', 'Reference'), ('barcode', 'Barcode')]
  • sn_serial_column_index Integer
    default=1 string='Column index for S/N'
Public methods (2)
  • action_import(self)
  • default_get(self, fields)
    @api.model
REPOSITORY
REPOSITORYOCA/stock-logistics-workflow
GIT
GIThttps://github.com/OCA/stock-logistics-workflow.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/stock-logistics-workflow/tree/17.0/stock_picking_import_serial_number
VERSION
VERSION 1.0.0
CATEGORY
CATEGORYstock
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSTecnativa, Odoo Community Association (OCA)
MAINTAINERS
MAINTAINERSTecnativa, Odoo Community Association (OCA)
COMMITTERS
COMMITTERSOCA-git-bot, oca-ci, juancarlosonate-tecnativa, cristina-hidalgo-tecnativa
WEBSITE
WEBSITEhttps://github.com/OCA/stock-logistics-workflow
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 19:20:07
ODOO DEPENDENCIES
ODOO DEPENDENCIES odoo/odoo:
    - stock
    - product
    - base
    - mail
    - base_setup
    - web
    - bus
    - web_tour
    - uom
    - barcodes_gs1_nomenclature
    - barcodes
    - digest
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES xlrd
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
This module extends the functionality of stock module to allow import
serial numbers from an excel file.

Code Analysis

Views touched (3)
XML IDNameModelTypeStatus
res_config_settings_view_form res.config.settings block Inherits stock.res_config_settings_view_form
stock_picking_import_serial_number_wiz stock.picking.import.serial.number.wiz.form stock.picking.import.serial.number.wiz form New
view_picking_form stock.picking button Inherits stock.view_picking_form
Models touched (2)

New fields (4)
  • default_sn_package_column_index Integer
    default=2 default_model='stock.picking.import.serial.number.wiz' string='Column index for Package'
  • default_sn_product_column_index Integer
    default=0 default_model='stock.picking.import.serial.number.wiz' string='Column index for product'
  • default_sn_search_product_by_field Selection
    default='default_code' default_model='stock.picking.import.serial.number.wiz' required=True string='Search product by field' args: [('default_code', 'Reference'), ('barcode', 'Barcode')]
  • default_sn_serial_column_index Integer
    default=1 default_model='stock.picking.import.serial.number.wiz' string='Column index for S/N'
Public methods (0)

No public methods.

New fields (8)
  • data_file Binary
    string='File to import'
  • filename Char
  • overwrite_serial Boolean
  • picking_ids Many2many → stock.picking
    args: 'stock.picking'
  • sn_package_column_index Integer
    default=2 string='Column index for Package'
  • sn_product_column_index Integer
    default=0 string='Column index for product'
  • sn_search_product_by_field Selection
    default='default_code' string='Search product by field' args: [('default_code', 'Reference'), ('barcode', 'Barcode')]
  • sn_serial_column_index Integer
    default=1 string='Column index for S/N'
Public methods (2)
  • action_import(self)
  • default_get(self, fields)
    @api.model
REPOSITORY
REPOSITORYOCA/stock-logistics-workflow
GIT
GIThttps://github.com/OCA/stock-logistics-workflow.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/stock-logistics-workflow/tree/16.0/stock_picking_import_serial_number
VERSION
VERSION 1.0.1
CATEGORY
CATEGORYstock
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSTecnativa, Odoo Community Association (OCA)
MAINTAINERS
MAINTAINERSTecnativa, Odoo Community Association (OCA)
COMMITTERS
COMMITTERSVíctor Martínez, Weblate, OCA-git-bot, oca-ci, Quirino Leone
WEBSITE
WEBSITEhttps://github.com/OCA/stock-logistics-workflow
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:53:51
ODOO DEPENDENCIES
ODOO DEPENDENCIES odoo/odoo:
    - stock
    - product
    - base
    - mail
    - base_setup
    - web
    - bus
    - web_tour
    - uom
    - barcodes_gs1_nomenclature
    - barcodes
    - digest
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES xlrd
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (3)
XML IDNameModelTypeStatus
res_config_settings_view_form res.config.settings div Inherits stock.res_config_settings_view_form
stock_picking_import_serial_number_wiz stock.picking.import.serial.number.wiz.form stock.picking.import.serial.number.wiz form New
view_picking_form stock.picking button Inherits stock.view_picking_form
Models touched (2)

New fields (4)
  • default_sn_package_column_index Integer
    default=2 default_model='stock.picking.import.serial.number.wiz' string='Column index for Package'
  • default_sn_product_column_index Integer
    default=0 default_model='stock.picking.import.serial.number.wiz' string='Column index for product'
  • default_sn_search_product_by_field Selection
    default='default_code' default_model='stock.picking.import.serial.number.wiz' required=True string='Search product by field' args: [('default_code', 'Reference'), ('barcode', 'Barcode')]
  • default_sn_serial_column_index Integer
    default=1 default_model='stock.picking.import.serial.number.wiz' string='Column index for S/N'
Public methods (0)

No public methods.

New fields (8)
  • data_file Binary
    string='File to import'
  • filename Char
  • overwrite_serial Boolean
  • picking_ids Many2many → stock.picking
    args: 'stock.picking'
  • sn_package_column_index Integer
    default=2 string='Column index for Package'
  • sn_product_column_index Integer
    default=0 string='Column index for product'
  • sn_search_product_by_field Selection
    default='default_code' string='Search product by field' args: [('default_code', 'Reference'), ('barcode', 'Barcode')]
  • sn_serial_column_index Integer
    default=1 string='Column index for S/N'
Public methods (2)
  • action_import(self)
  • default_get(self, fields)
    @api.model
REPOSITORY
REPOSITORYOCA/stock-logistics-workflow
GIT
GIThttps://github.com/OCA/stock-logistics-workflow.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/stock-logistics-workflow/tree/15.0/stock_picking_import_serial_number
VERSION
VERSION 2.0.0
CATEGORY
CATEGORYstock
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSTecnativa, Odoo Community Association (OCA)
MAINTAINERS
MAINTAINERSTecnativa, Odoo Community Association (OCA)
COMMITTERS
COMMITTERSVíctor Martínez, Weblate, OCA-git-bot, oca-ci, Carolina Fernandez
WEBSITE
WEBSITEhttps://github.com/OCA/stock-logistics-workflow
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:46:37
ODOO DEPENDENCIES
ODOO DEPENDENCIES odoo/odoo:
    - stock
    - product
    - base
    - mail
    - base_setup
    - web
    - bus
    - web_tour
    - uom
    - barcodes
    - digest
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES xlrd
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (3)
XML IDNameModelTypeStatus
res_config_settings_view_form res.config.settings div Inherits stock.res_config_settings_view_form
stock_picking_import_serial_number_wiz stock.picking.import.serial.number.wiz.form stock.picking.import.serial.number.wiz form New
view_picking_form stock.picking button Inherits stock.view_picking_form
Models touched (2)

New fields (4)
  • default_sn_package_column_index Integer
    default=2 default_model='stock.picking.import.serial.number.wiz' string='Column index for Package'
  • default_sn_product_column_index Integer
    default=0 default_model='stock.picking.import.serial.number.wiz' string='Column index for product'
  • default_sn_search_product_by_field Selection
    default='default_code' default_model='stock.picking.import.serial.number.wiz' required=True string='Search product by field' args: [('default_code', 'Reference'), ('barcode', 'Barcode')]
  • default_sn_serial_column_index Integer
    default=1 default_model='stock.picking.import.serial.number.wiz' string='Column index for S/N'
Public methods (0)

No public methods.

New fields (8)
  • data_file Binary
    string='File to import'
  • filename Char
  • overwrite_serial Boolean
  • picking_ids Many2many → stock.picking
    args: 'stock.picking'
  • sn_package_column_index Integer
    default=2 string='Column index for Package'
  • sn_product_column_index Integer
    default=0 string='Column index for product'
  • sn_search_product_by_field Selection
    default='default_code' string='Search product by field' args: [('default_code', 'Reference'), ('barcode', 'Barcode')]
  • sn_serial_column_index Integer
    default=1 string='Column index for S/N'
Public methods (2)
  • action_import(self)
  • default_get(self, fields)
    @api.model
REPOSITORY
REPOSITORYOCA/stock-logistics-workflow
GIT
GIThttps://github.com/OCA/stock-logistics-workflow.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/stock-logistics-workflow/tree/14.0/stock_picking_import_serial_number
VERSION
VERSION 1.0.1
CATEGORY
CATEGORYstock
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSTecnativa, Odoo Community Association (OCA)
MAINTAINERS
MAINTAINERSTecnativa, Odoo Community Association (OCA)
COMMITTERS
COMMITTERSWeblate, OCA-git-bot, sergiocorato, oca-ci, Ryan Cole
WEBSITE
WEBSITEhttps://github.com/OCA/stock-logistics-workflow
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:41:04
ODOO DEPENDENCIES
ODOO DEPENDENCIES odoo/odoo:
    - stock
    - product
    - base
    - mail
    - base_setup
    - web
    - bus
    - web_tour
    - uom
    - barcodes
    - digest
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES xlrd
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (3)
XML IDNameModelTypeStatus
res_config_settings_view_form res.config.settings div Inherits stock.res_config_settings_view_form
stock_picking_import_serial_number_wiz stock.picking.import.serial.number.wiz.form stock.picking.import.serial.number.wiz form New
view_picking_form stock.picking button Inherits stock.view_picking_form
Models touched (2)

New fields (3)
  • default_sn_product_column_index Integer
    default=0 default_model='stock.picking.import.serial.number.wiz' string='Column index for product'
  • default_sn_search_product_by_field Selection
    default='default_code' default_model='stock.picking.import.serial.number.wiz' required=True string='Search product by field' args: [('default_code', 'Reference'), ('barcode', 'Barcode')]
  • default_sn_serial_column_index Integer
    default='1' default_model='stock.picking.import.serial.number.wiz' string='Column index for S/N'
Public methods (0)

No public methods.

New fields (7)
  • data_file Binary
    string='File to import'
  • filename Char
    string='Filename'
  • overwrite_serial Boolean
  • picking_ids Many2many → stock.picking
    args: 'stock.picking'
  • sn_product_column_index Integer
    default=0 string='Column index for product'
  • sn_search_product_by_field Selection
    default='default_code' string='Search product by field' args: [('default_code', 'Reference'), ('barcode', 'Barcode')]
  • sn_serial_column_index Integer
    default='1' string='Column index for S/N'
Public methods (2)
  • action_import(self)
  • default_get(self, fields)
    @api.model
REPOSITORY
REPOSITORYOCA/stock-logistics-workflow
GIT
GIThttps://github.com/OCA/stock-logistics-workflow.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/stock-logistics-workflow/tree/13.0/stock_picking_import_serial_number
VERSION
VERSION 2.0.0
CATEGORY
CATEGORYstock
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSTecnativa, Odoo Community Association (OCA)
MAINTAINERS
MAINTAINERSTecnativa, Odoo Community Association (OCA)
COMMITTERS
COMMITTERSPedro M. Baeza, sergio-teruel, OCA-git-bot, oca-ci
WEBSITE
WEBSITEhttps://github.com/OCA/stock-logistics-workflow
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:34:15
ODOO DEPENDENCIES
ODOO DEPENDENCIES odoo/odoo:
    - stock
    - product
    - base
    - mail
    - base_setup
    - web
    - bus
    - web_tour
    - uom
    - barcodes
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES xlrd
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (4)
XML IDNameModelTypeStatus
res_config_settings_view_form res.config.settings div Inherits stock.res_config_settings_view_form
stock_picking_import_serial_number_wiz stock.picking.import.serial.number.wiz.form stock.picking.import.serial.number.wiz form New
view_picking_form stock.picking button Inherits stock.view_picking_form
view_picking_type_form stock.picking.type xpath Inherits stock.view_picking_type_form
Models touched (4)

New fields (3)
  • default_sn_product_column_index Integer
    default=0 default_model='stock.picking.import.serial.number.wiz' string='Column index for product'
  • default_sn_search_product_by_field Selection
    default='default_code' default_model='stock.picking.import.serial.number.wiz' required=True string='Search product by field' args: [('default_code', 'Reference'), ('barcode', 'Barcode')]
  • default_sn_serial_column_index Integer
    default='1' default_model='stock.picking.import.serial.number.wiz' string='Column index for S/N'
Public methods (0)

No public methods.

New fields (1)
  • import_lot_from_file Boolean
    related='picking_type_id.import_lot_from_file'
Public methods (0)

No public methods.

New fields (8)
  • data_file Binary
    string='File to import'
  • filename Char
    string='Filename'
  • overwrite_serial Boolean
  • picking_ids Many2many → stock.picking
    args: 'stock.picking'
  • process_only_lot_available Boolean
    default=True
  • sn_product_column_index Integer
    default=0 string='Column index for product'
  • sn_search_product_by_field Selection
    default='default_code' string='Search product by field' args: [('default_code', 'Reference'), ('barcode', 'Barcode')]
  • sn_serial_column_index Integer
    default='1' string='Column index for S/N'
Public methods (2)
  • action_import(self)
  • default_get(self, fields)
    @api.model

New fields (1)
  • import_lot_from_file Boolean
    compute='_compute_import_lot_from_file' readonly=False store=True
Public methods (0)

No public methods.