AREAVISION: website, back office and app

What it does

AREAVISION brings electronic shelf labels (ESL), digital signage and the cloud platforms that drive them to shops and supermarkets. For them I built the website, areavisiontech.eu, and two pieces of software.

The back office sits between the clients' shops and the labels' cloud. Each shop sends its price files over FTP; the back office logs them, skips the ones identical to the previous file, maps the columns to the label fields and transforms them with chained rules: price format, leading zeros, EAN codes to build, price per kilo. Every night it counts each shop's labels, model by model, and sends an email if a process gets stuck.

The app is for people working in the shop, handheld scanners included. It finds a product from its barcode, links it to its label read by NFC, camera or scanner, and makes the right labels' LEDs flash: for a promotion, a restock, products near their expiry date.

How it's built

Back office and app are PHP with MySQL and talk to the Zkong label cloud through its API. The back office also creates the shops' FTP accounts and shows the map of the stores with Leaflet and OpenStreetMap.

The app is a PWA with Bootstrap 5; it reads codes with the phone's camera and imports shelves from Excel.