product_supplierinfo_import
Import vendor price lists from .xlsx files using configurable templates that match products by a chosen template field.
Key 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.