Porichoy — Turning Chaotic Factory Records Into EU Digital Product Passports
Description and use
Porichoy converts chaotic factory records into EU Digital Product Passports, enabling QR‑linked access without backend services.
Problem
Bangladesh’s garment factories rely on messy Excel sheets, ERP exports, and paper trim cards with mixed Bangla/English headers, duplicate rows, and missing cells, making it hard to produce EU Digital Product Passport (DPP) data per production order.
Outcome
Porichoy transforms chaotic factory records into compliant, passport‑ready data, enabling buyers to access a QR‑linked snapshot without backend infrastructure, while preserving data locality and traceability.
Workflow
- Drop a .xlsx/.csv file into the app; the first sheet parses on‑device.
- Deterministic engine maps chaotic headers to the DPP schema using synonym patterns, fuzzy fallback, and learned vocabulary.
- Calculate a DPP Readiness Score (0–100) per production order and list missing attributes.
- Generate a QR code that embeds the passport snapshot; scanning opens the buyer view on any phone.
- All raw data remains on the device (local‑first).
Evidence
Bangladesh's garment factories run on messy Excel sheets, ERP exports, and paper trim cards — with Bangla/English mixed headers, duplicate rows, and missing cells.
Ingest — drop a factory .xlsx/.csv; the first sheet parses on-device
Map — a deterministic engine maps chaotic headers to the canonical DPP schema: documented synonym patterns (English + Bangla), bigram-dice fuzzy fallback, confidence scores with human confirmation, and a learned vocabulary per factory.
Score — a DPP Readiness Score (0–100) per production order, weighted by the ESPR Art. 8 category, with the exact missing-attribute list
Publish — a QR whose link embeds the passport snapshot (no backend needed): scanning opens the buyer view on any phone
Local-first — raw factory data never leaves the device in the pilot
- Record date: 2026-10-21T07:56:09.994Z