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...

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.
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.
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.
The engineering underneath
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.
Hire me for this
Full-Stack Web DevelopmentFrom $14/hrPHP & Laravel Source CodeFrom $14/hrAPI & IntegrationsFrom $14/hrProjects like this

Premier Metrics, Admin Dashboard
The office dashboard behind a mobile timer app. React and TypeScript on Vite with Supabase and Vercel: monthly...

Premier Timer, iOS and Android App
Taking over from a departing programmer: an unfinished React Native app rebuilt and shipped to the App Store...

Deeve Technologies Portfolio, Next.js Rebuild
This site: my portfolio rebuilt from a custom WordPress theme onto Next.js 16, React 19 and Supabase, with...
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.