Price List Parser

A script that normalises dealer price lists into a single format. The input is zip, rar, and 7z archives holding XML, XLS, XLSX, and MXL files, 1C exports included, and every dealer sends them with its own column structure.

Product groups and units of measure are mapped through configurable dictionaries, SKUs are extracted by column keywords, and the output is normalised CSV files per category - chipboard and plywood.

The script handles either a single dealer or a whole folder of them, splits CSVs by a size limit, and moves processed sources into an archive.