← Work

Lapiz Blue General Trading LLC

An offline catalogue that answers "what's the equivalent?"

A staff-only PWA with 183 construction-chemical products across nine brands that suggests exact, near and same-category alternatives and works with no signal in the warehouse.

Role
Head of Technology: product, data model, build
Period
Apr 2026
Stack
Next.js · React 19 · Fuse.js · Service Worker
Abstract render: fanned matte-black cards, one marked with a cyan dot
  • 183products, offline
  • 9brands
  • 206static pages
  • < 152 KBfirst-load JavaScript
  • 2 daysbuilt in

01Context

Counter staff and salesmen field questions like "do you have something equivalent to this Mapei grout?" across nine brands and thousands of SKUs. The answers lived in people's heads and in supplier PDFs.

02Constraint

It had to work on the shop floor and in warehouses with poor connectivity, open instantly on cheap Android phones, and never show cost prices.

03What I did

I modelled every product with classification tokens (cement-based, C2TE, S1 and so on) so a three-tier engine can propose exact, near and same-category alternatives across brands. The app is a statically exported Next.js PWA with a service worker, fuzzy ⌘K search, a coverage calculator, three-way compare, WhatsApp share and recently-viewed, with deep links into Zoho product search.

04Result

Live on 20 April 2026 with 183 products, nine brands and 206 pages, under 152 KB of first-load JavaScript, fully usable offline. It replaced the catalogue PDFs on the sales floor.

05What I'd change

The classification tokens were hand-entered; an extraction step from the technical datasheets would have been faster and would stay current as suppliers update products.

06Stack

  • Next.js
  • React 19
  • Fuse.js
  • Service Worker
  • Tailwind
  • Vercel