Moving an oil & gas warehouse off spreadsheets, with bar stock tracked by the inch
I built the web platform that an oil & gas services company in Tabasco, Mexico, uses to run its warehouse, tools and rental assets. It replaced their spreadsheets and has been in daily use since July 2026.

Client screens are not shown here. A walkthrough with sample data is available on request.
The problem
The company runs a workshop that serves the oil industry and rents out equipment. It tracked its warehouse, loaned tools and rental assets in spreadsheets, which could not show who had a given tool or how much of a cut bar was left. Raw material arrives as bars and is used by the inch. The warehouse also needed a signed record of who took what, and when.
What I built
- Stock by warehouse, shelf and bin. I also wrote the importer for the client's master spreadsheet: it takes stock from the current-count columns and skips a running historical total that would have inflated it.
- Checkout and loan vouchers that the worker signs with a personal PIN, printed on the client's own voucher forms. PIN setup uses a one-time code sent over WhatsApp.
- Bar stock tracked by the inch, with the heat number of each bar. A voucher deducts a cut or a whole bar, and low-stock alerts compare inches instead of bar count.
- Tool records with maintenance and certificates, plus a public page, opened from a QR code, where anyone can check a tool and its certificate.
- Rental assets with exit passes to customer companies and a history per piece, plus half-year and annual counts that list the differences before anyone applies them. Both went live in October 2026.
- Discovery with interviews and questionnaires, then 4 milestone reviews with the client between April and August 2026. I presented the July and August milestones at their offices. I wrote the 47-page user guide and the 15-page technical manual.
Screens
Walking the client through the live dashboard in a monthly review (August 2026). Presenting a monthly delivery to the client team (July 2026). Explaining the new product form to the warehouse team (July 2026). Training a warehouse user one to one on the tablet flow. Reviewing who gets notified of what, with the client. Working on site next to the people who use the system.
How it works
A React and TypeScript single-page app, in Spanish, talks to an Express API on PostgreSQL. The interface uses Tailwind and shadcn/ui, with TanStack Table for the long catalog lists. The API has 300+ endpoints in 24 domain modules, and 20 of those modules have their own routes, service and validation schemas. Permissions are checked on the server. Product attributes are stored as indexed JSON.
The first prototype ran on SQLite. I moved the code to PostgreSQL with Drizzle ORM before go-live, and the schema is managed through 45 versioned migrations. I also wrote 26 integration smoke scripts that drive the API against a local database.
The server generates the documents with PDFKit and ExcelJS. All 11 reports export to Excel, and 6 of them also to PDF with a folio number and a signature block. Voucher printouts fill the client's own templates, so they keep the format the warehouse already used.
Production runs as 3 containers behind a reverse proxy with TLS. Staging only sends email to an allow-list. There is no CI pipeline: each release runs a script that backs up the database, proves the backup by restoring it elsewhere, checks integrity before and after the migrations, and keeps a one-command rollback. A September 2026 release with a schema migration was down for 23 s.
Results
- ~1,800
- products imported from the client's master spreadsheet, 0 errors after a dry run
- 23 s
- of downtime on a release with a schema migration
- 63
- screens in the web app, built by one engineer
- 47 pages
- user guide, plus a 15-page technical manual
Who else worked on it
The client's staff supplied the data (the warehouse spreadsheet and the asset and calibration records) and their official voucher forms. GALABEX handled the commercial side.
Full stack
TypeScript, React 18, Vite, Tailwind CSS, shadcn/ui (Radix), TanStack Query, TanStack Table, React Hook Form, Zod, Zustand, Recharts, Node.js 22, Express 4, Drizzle ORM, PostgreSQL 17, PDFKit, ExcelJS, WhatsApp Cloud API, Docker Compose, nginx, Let's Encrypt