Pricor: local AI reads the supplier spreadsheet, an exact engine does the math
Description and use
Pricor uses local Laya and Gemma models to automatically interpret supplier spreadsheets, apply exact arithmetic, and let users confirm results, reducing manual effort and errors.
Problem
Small Argentine shops manually calculate unit costs from supplier spreadsheets with varying formats, leading to errors and inefficiency.
Outcome
Pricor processed two supplier lists, automatically resolving 11 of 29 columns (10 correctly) and prompting the user for 18 columns. It produced accurate unit costs, identified price changes (514 increases, 118 decreases, etc.), and maintained full traceability.
Workflow
- Upload Excel or CSV file
- Deterministic profiler identifies headers and data types
- Fine‑tuned Laya classifies columns
- Gemma 4 E4B handles uncertain columns and generates questions
- User confirms or edits column roles and assumptions
- Executor applies deterministic operations (parse, discounts, VAT, split, map, normalize)
- Preview of final unit cost and traceability
- Approve and export CSV/XLSX with rejected rows report
Evidence
Pricor prepares the file; it does not replace the shop's management system.
The whole design is one rule: models interpret, the engine executes, the user decides.
Gemma’s VAT and per-pack suggestions for the first supplier cited the right note and not the other.
- Record date: 2026-10-19T05:41:25.216Z