IP ERP

ERP & CRM for an IP Law Firm

IP ERP Overview Showcase
My RoleTech Lead & Full-Stack Engineer
Platform / CategoryEnterprise ERP
Year2026
Core Tech
Next.jsTypeScriptPostgreSQL

The Challenge

The firm's client and lead data lived in many large spreadsheets that overlapped and contradicted each other. Sales follow-ups, quotes and IP case progress were tracked separately, so nobody had a single, trustworthy view of a client, and the data was too large for a normal web table to handle.

The Solution

I built a master data bank as the single source of truth. Bulk Excel and CSV imports map columns, check every row against the existing database, and let the team resolve duplicates, with each import tracked as a job. To keep very large contact lists fast, contacts are cached in IndexedDB and fetched in compressed chunks. On top of that sit a sales module with lead sheets, inbound enquiries and quotes that calculate base fee, government fee and tax, an operations hub for IP cases with stage tracking, and meetings with automatic Zoom links, notes and reminders.

Technical Architecture

Next.js 16 App Router with TypeScript, PostgreSQL via Prisma with a multi-tenant schema, JWT-based roles for super admin, admin and user, IndexedDB caching with chunked, compressed APIs, Zoom API integration, and xlsx and jsPDF for import and documents.

Key Tech Stack

Next.jsTypeScriptPostgreSQLPrismaIndexedDBZoom APITailwind CSS

Business Outcome

Replaced the firm's scattered spreadsheets with a single system for contacts, sales pipeline and IP case tracking.

Interface & Dashboard Details

Tap a screen to see it full size.

UX & Design Decisions

  • Import is a review step, not a blind upload: the team sees matches and conflicts before anything is written.
  • Client-side caching in IndexedDB so large contact lists search and filter instantly.
  • Dense, spreadsheet-like tables for power users who came from Excel, with customisable columns.
What's next

Interested in building something similar?