Work/Full-Stack Web

KC Pipe Tubing Order Portal

Gated tubing-order portal with Excel and PDF export for an oilfield supplier

Typeclient
Statusprototype
Updated2026-08-03
Commits10
SourcePrivate

What it is

A mobile-first portal where a tubing supplier's customers sign up, log in and submit orders, with a full specialized form for one major customer and a streamlined generic form for everyone else. The owner sees every order in one admin dashboard, filters by type, updates status, and exports each order to the exact Excel sheet or PDF the shop already uses. Prototype v0.1.

The problem

Tubing orders were taken on a spreadsheet request form that had to be handled and reformatted by hand.

How it works

  1. Next.js 15 App Router, React 19 and strict TypeScript, with Clerk handling authentication.
  2. Supabase Postgres holds profiles and orders; a customer's type routes them to the specialized or generic form, and admins are promoted by SQL only.
  3. ExcelJS reproduces the customer's spreadsheet layout on the server, with print and PDF export per order.
  4. One enforced design-token theme keeps every screen inside the existing KC Pipe look.

Stack

Next.js 15React 19TypeScriptClerkSupabaseExcelJSVercel

Disciplines

For your business

Replacing emailed spreadsheet order forms with a branded customer portal that exports straight into the supplier's existing formats.