Deeve Technologies
Client workWeb Application

DeckoSKU, SKU Catalogue

A warehouse SKU catalogue for DECKO covering 102 SKUs across 7 product categories. Live search across SKU codes, GTIN/EAN, internal barcodes, and product names, pulling dimensions and photos from a master workbook, with barcode scan, label...

ClientDECKO
RoleFull-stack developer
Year2026
TypeWeb Application
Updated23 Sep 2026
Decko
Overview

DeckoSKU is the internal product reference for the DECKO warehouse team, covering 102 SKUs across seven product ranges.

Search by SKU, barcode, GTIN or partial name, with barcode scanning and metric to imperial conversion.

Built with
Custom MVCJavaScriptPHPSQLite
The problem

What was in the way

Warehouse staff needed dimensions, weight and units per box while standing at a pallet.

The source of truth was a master product workbook. Opening a spreadsheet on a warehouse floor to find one row is slow: load the file on a phone, wait, scroll horizontally, find the column, read across without losing the row.

Slow lookups mean people stop doing them. They guess from memory, or they ask someone who also guesses. Wrong dimensions on an export document is a customs problem. Wrong units per box on a quote is a margin problem.

The fix is not better data. The data was already correct. The fix is making the lookup faster than guessing.

What I built

Six parts, each with a reason

Search by anything

SKU, barcode, GTIN, EAN, or a partial product name. Returns dimensions, weight, units per box and the EAN instantly.

Partial name matters more than it sounds. Warehouse staff do not always know the SKU. They know it is the grey garage tile, and the search has to find it from that.

Label generation and CSV export

So the data leaves the tool in the formats the team already uses, rather than forcing a new process on people who did not ask for new software.

Barcode scanning

Because typing a thirteen digit GTIN on a phone in a warehouse is how errors happen. Scanning removes the transcription step entirely, which is where the mistakes were.

Metric and imperial toggle

For export documentation and international enquiries. DECKO ships to several markets and the paperwork differs.

Conversion done by the tool rather than by a person with a calculator is one fewer place for a rounding error to enter an export document.

Category filtering across seven ranges

Durante garage tiles, SPC flooring, WPC and PP deck tiles, Soundscape, Flexistone and Verdure.

Why it is listed as a project

It is small, and it is the kind of tool that is usually not built at all because it seems too minor to justify.

That is the point. A lookup that takes fifteen seconds instead of two minutes, used forty times a day, is a meaningful operational change, and it cost far less than the spreadsheet workaround it replaced.

How it was built

The engineering underneath

SQLite102 rows read constantly and written rarely, in a file rather than a database server to provision and back up
Custom MVCPHP with JavaScript for barcode scanning, hosted on its own subdomain
Webhook deployA product data update is a commit rather than a manual upload to a server

Custom PHP MVC with a SQLite backend and GitHub webhook deployment.

SQLite is the interesting choice and it is the right one here. The dataset is 102 rows. It is read constantly and written rarely. A full database server would be infrastructure to provision, secure, back up and maintain, for a table that fits comfortably in a file.

The dataset also travels with the application, which means deployment is a file copy and there is no connection to configure, no credentials to manage and no separate service that can be down while the warehouse is working.

Deployment through a GitHub webhook, so a product data update is a commit rather than a manual upload to a server.

The interface is built for a phone held in one hand, because that is the actual usage. Large touch targets, results visible without scrolling, and nothing requiring precision tapping from someone wearing gloves.

PHP with a custom MVC structure, SQLite, JavaScript for barcode scanning, GitHub webhook deployment. Hosted on its own subdomain.

Custom MVCJavaScriptPHPSQLite
More work

Projects like this

All projects
Why it matters for your project

I build software, and I measure whether it works.

The same questions I research are the ones I ask on client builds: is it reliable, is it fast, is it easy to use, and is it secure. Those four drove satisfaction in my ICT portal study, and they shape how I scope and test every project.