product_supplierinfo_import

Purpose

Import vendor price lists from .xlsx files using configurable templates that match products by a chosen template field.

Features

product.supplierinfo.import.template: Defines vendor price import templates with header offset, sheet selection, search header, and header-to-field mappings used to detect spreadsheets.
product.supplierinfo.import.template: Allows choosing a product template char field for matching, default supplier assignment, and options to restrict imports to existing supplierinfos or display unchanged rates.
product.supplierinfo.import: Imports .xlsx vendor price lists, applying shared validity and lead time values and mapping each row to supplierinfo fields from the selected template.
product.supplierinfo.import: Auto-creates products when no match is found (if allowed), using vendor-provided identifiers and names and posting a creation note.
product.supplierinfo.import: Closes previous supplierinfo records when needed, creates or updates entries for the supplier, and marks unchanged ones for follow-up.
product.supplierinfo: Adds an import_status flag to distinguish new or updated supplierinfo records from unchanged ones after an import.
product.template: Adds a created_from_supplierinfo_import marker and a computed searchable product_code exposing the main supplier’s code.