OrderLine SaaS
Multi-tenant order management built with Next.js 16, PostgreSQL, Prisma 7, and Auth.js.
Features
- Auth — register (creates org + OWNER), login/logout, JWT sessions, password reset, change password
- Tenant context — org-scoped data, org switcher, RBAC (
OWNER / ADMIN / MEMBER)
- Audit log — tenant activity feed on dashboard +
/activity (search/filter)
- Customers — CRUD, search/sort/pagination, archive, tags, addresses, CSV export
- Products — CRUD, SKU uniqueness, pricing/cost, stock tracking, categories, archive, CSV export
- Orders — line items, auto order numbers, status workflow + history, duplicate, stock decrement, CSV export
- Settings — org profile, invite/add members, role updates, password change
- Dashboard — KPIs, pipeline, recent orders, low-stock alerts, activity feed
Quick start (local PostgreSQL)
Requires a local PostgreSQL install (this project targets the Windows PostgreSQL service, not Docker).
npm install
cp .env.example .env # keep DATABASE_URL + set AUTH_SECRET
# One-time: create orderline role + database (prompts for postgres superuser password)
npm run db:setup
# Push Prisma schema
npm run db:push
npm run dev
Demo login
Default app connection string:
DATABASE_URL="postgresql://orderline:orderline@localhost:5432/orderline?schema=public"
If you prefer the postgres superuser instead, update DATABASE_URL accordingly and create an orderline database first.
Scripts
| Script | Description |
|---|
npm run dev | Dev server |
npm run db:setup | Create local orderline role + database |
npm run db:push | Push schema to PostgreSQL |
npm run db:migrate | Migrations |
npm run db:studio | Prisma Studio |
Stack notes
- Prisma Client:
src/lib/db.ts (@prisma/adapter-pg)
- Auth:
src/auth.ts + middleware protection
- Tenant/RBAC:
src/lib/tenant.ts, src/lib/permissions.ts
- Domain actions:
src/lib/actions/*
