Article ManagementDeclaration AutomationRetail Operations
Tudors / Dan John
A web platform that automates product declaration generation for retail stores - from supplier file import to a single-click print.

About the project
Managing product declarations across multiple fashion brands is a process most retailers handle manually - copying data from supplier files, reformatting it, and printing declarations one by one. For a client operating with brands like Tudors, Dan John, Pini Parma, and Camicissima, this meant constant data re-entry, inconsistent formatting, and significant time lost at every new delivery.
Apparo designed and delivered a centralized web platform that fully automates the journey from supplier file to printed declaration - eliminating manual work, standardizing data across all brands, and giving retail staff a tool simple enough to use with a barcode scan.
What We Built
Article Import Engine
The platform ingests supplier files in any format and automatically maps columns to the system's unified data structure. Each brand has its own predefined column mapping - so a field called ORIGIN in one file and Country in another both resolve to the same internal field. If a supplier changes their file format, the administrator updates the mapping in the admin panel without any developer involvement.
Dictionary & Standardization Layer
On top of column mapping sits a dictionary system that standardizes values across brands. Raw supplier codes like "IT", "CN", or "Cotton" are automatically translated into "Italy", "China", or "Pamuk" - ensuring every declaration that comes out of the system is consistent and compliant, regardless of what the supplier sent in.
Article Database
All imported articles are stored in a central database with full edit history. Administrators can update any article manually, and the system logs every change. The database also supports bulk import of existing inventory from ERP exports in Excel, CSV, or XML.
Declaration Generation & Printing
Retail staff can find any product by scanning its barcode. The system instantly pulls up the article, pre-fills the declaration template with name, composition, country of origin, importer, size, and barcode - and the employee prints with a single click. Bulk printing for multiple selected articles is also supported.
Role-Based Access
Administrators manage users, control mappings and dictionaries, edit articles, and view full activity logs. Retail users get a focused interface - scan, find, print. Nothing more, nothing less.
Results
| Metric | Before | After |
|---|---|---|
| Declaration preparation | Manual, per article | Instant, automated |
| Data standardization | Done by hand | Automatic via mapping + dictionary |
| Brand file formats supported | Handled ad-hoc | 4 brands, fully configured |
| Retail printing process | Multi-step, error-prone | Barcode scan → 1 click |
| Activity tracking | None | Full audit log |
The Outcome
The client now has a single platform that handles every step of the declaration workflow - from raw supplier data to a printed label in a retail store. Staff no longer spend time reformatting files or manually filling out declarations. The system is built to scale: adding a new brand means configuring a mapping, not rebuilding anything.