Import supplier pricelists

product_supplierinfo_import
REPOSITORY
REPOSITORYOCA/product-attribute
GIT
GIThttps://github.com/OCA/product-attribute.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/product-attribute/tree/18.0/product_supplierinfo_import
VERSION
VERSION 1.1.0
CATEGORY
CATEGORYProduct
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSTecnativa, Odoo Community Association (OCA)
MAINTAINERS
MAINTAINERSTecnativa, Odoo Community Association (OCA)
COMMITTERS
COMMITTERSsergio-teruel, Víctor Martínez, JordiMForgeFlow, Weblate, OCA-git-bot, oca-ci
WEBSITE
WEBSITEhttps://github.com/OCA/product-attribute
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 19:30:12
ODOO DEPENDENCIES
ODOO DEPENDENCIES odoo/odoo:
    - purchase
    - account
    - base_setup
    - base
    - web
    - onboarding
    - product
    - mail
    - bus
    - web_tour
    - html_editor
    - uom
    - analytic
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - digest
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
This module allows importing vendor price lists from Excel files, matching products using any product template char field.

Code Analysis

Views touched (3)
XML IDNameModelTypeStatus
product_supplierinfo_import_form product.supplierinfo.import form New
product_supplierinfo_import_template_form product.supplierinfo.import.template form New
product_supplierinfo_import_template_tree product.supplierinfo.import.template list New
Models touched (5)

New fields (1)
  • import_status Selection
    default='unchanged' args: [('new_or_updated', 'New or Updated'), ('unchanged', 'Unchanged')]
Public methods (0)

No public methods.

New fields (7)
  • create_new_products Boolean
    default=True help="If a product isn't found by its Search Field, it will be created with the provided data"
  • date_start Date
    required=True string='Validity'
  • delay Integer
  • supplier_id Many2one → res.partner
    comodel_name='res.partner' compute='_compute_supplier_id' readonly=False store=True string='Supplier'
  • supplierinfo_file Binary
    required=True
  • supplierinfo_filename Char
  • template_id Many2one → product.supplierinfo.import.template
    comodel_name='product.supplierinfo.import.template' compute='_compute_template_id' store=True
Public methods (1)
  • action_import_file(self)
    Process the uploaded sheet

New fields (9)
  • header_offset Integer
    default=0 required=True
  • import_criteria_field_id Many2one → ir.model.fields
    comodel_name='ir.model.fields' default=<expr> domain=[('model', '=', 'product.template'), ('ttype', '=', 'char')] help='The field that will be used to match the productsfrom the excel file with the ones in the Odoo database'
  • name Char
    required=True
  • only_update_existing Boolean
    default=False help='If enabled, only existing supplierinfo records will be updated. New ones will not be created.'
  • search_header_name Char
    required=True
  • sheet_number Integer
    default=1 help='The number of the sheet page in the spreadsheet where the pricelist are' required=True
  • show_not_updated_rates Boolean
    help="If checked, at the end of the import, it will display the supplier's rate records that were not updated."
  • supplier_id Many2one → res.partner
    comodel_name='res.partner'
  • template_line_ids One2many → product.supplierinfo.import.template.line
    comodel_name='product.supplierinfo.import.template.line' inverse_name='template_id' string='Headers mapping'
Public methods (0)

No public methods.

New fields (3)
  • field_id Many2one → ir.model.fields
    comodel_name='ir.model.fields' domain=[('model', '=', 'product.supplierinfo'), ('store', '=', True)]
  • header_name Text
    help='Copy it directly from the origin cell so it matches right' required=True
  • template_id Many2one → product.supplierinfo.import.template
    comodel_name='product.supplierinfo.import.template'
Public methods (0)

No public methods.

New fields (2)
  • created_from_supplierinfo_import Boolean
    help='This product was created with the vendor import wizard'
  • product_code Char
    compute='_compute_product_code' compute_sudo=False help='This is the supplier product code from Main Supplier.' readonly=True search='_search_product_code'
Public methods (0)

No public methods.

STATUS
STATUSOpen migration PR - not merged yet for this version
REPOSITORY
REPOSITORYOCA/product-attribute
PULL REQUEST
PULL REQUEST[19.0][MIG] product_supplierinfo_import: Migration to 19.0 (#2305)