Import supplier pricelists

product_supplierinfo_import_by_barcode · OCA/product-attribute

    Repository
    OCA/product-attribute · module folder · Try on Runboat
    Module version
    3.0.0
    Category
    Product
    Folder size
    0.15 MB
    License
    AGPL-3
    Application
    No
    Auto-installable
    No
    Website
    https://github.com/OCA/product-attribute
    Last tracking update
    2026-08-07 08:09:20
    Authors
    Odoo Community Association (OCA), Tecnativa
    Maintainers
    Odoo Community Association (OCA), Tecnativa
    Committers
    David, Weblate, OCA-git-bot, oca-ci, juancarlosonate-tecnativa
    Odoo dependencies
    odoo/odoo:
    - purchase
    - account
    - base_setup
    - base
    - web
    - product
    - mail
    - bus
    - web_tour
    - uom
    - analytic
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - digest
    - resource
    Python dependencies
    None
    System dependencies
    None
    Required by
    product_supplierinfo_import_by_barcode_margin
    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 tree New
    HTTP endpoints (0)

    No HTTP endpoints found for this module.

    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')]
    • header_name Text
      help='Copy it directly from the origin cell so it matches right'
    • 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.