The problem
Rental articles needed a consistent and maintainable presentation. Categories, variants, dimensions, colours and availability could not be duplicated manually across languages and pages.
Case study · digital catalogue
Rental catalogue
A structured Excel table becomes a bilingual, searchable catalogue that supports a complete fair request.
5,000articles as the target
2languages DE/IT
90 daysnew-item label
< 4limited availability
The solution
Data is organised in a structured Excel table and published as a JSON catalogue. The web interface reads the same structure to build search, filters, product details and the request selection.
My role
I co-developed and built the catalogue, defined its data structure and integrated the workflow into the Walcher Messebau website. I also maintain and update it.
The result
A bilingual catalogue that separates data from presentation. Changes remain manageable in the table and visitors can move from search to a detailed request without changing tools.
02 · Key features
Key features
Complete search
Search by code, description, category, material, colour or size.
Categories and filters
Categories, subcategories, new items, limited availability and quick filters.
Variants
Colours, dimensions, technical details, availability and related items.
Selection
Articles, variants and quantities are collected in an editable list.
Fair request
Dates, event, location, hall, stand, delivery or collection and notes complete the request.
Two languages
Data and interface in German and Italian without maintaining two separate catalogues.
03 · Workflow
From Excel to the catalogue
Excel
Fields and translations
Validation
Consistent structure
JSON
Published data
Catalogue
Search and details
Request
Selection sent by e-mail
04 · Excel → JSON
The table as the data source
Excel remains practical for maintaining thousands of articles. The structure separates codes, DE/IT text, category, variant, material, colour, size, quantity and images.
ARTICOLIVARIANTITRADUZIONI
CODICECATEGORIA_ITCATEGORIA_DEMISURAQ.TÀ
[codice][categoria][Kategorie][L × P × H][n.]
[variante][descrizione][Beschreibung][colore][n.]
[immagine][materiale][Material][novità][n.]
05 · Stack
Technology
Structured Excel table, JSON catalogue, HTML and JavaScript interface inside WordPress and an e-mail request workflow.
Walcher Messebau
The result
A bilingual catalogue that separates data from presentation. Changes remain manageable in the table and visitors can move from search to a detailed request without changing tools.