From Excel and Word to one quoting system
A Czech technical distributor
An internal platform that replaced a hand-assembled Excel-and-Word quoting process for a distributor running thousands of SKUs across multiple suppliers.
- Type
- Custom software · Internal tool
- Year
- 2025
- My role
- Planning, design and build
- Status
- Internal app, no public link
Before
Every quote was put together by hand: supplier price lists in Excel, products copied into Word, margins and the EUR/CZK rate worked out separately, then a PDF by email.
What I built
A guided price-list import with column mapping takes any supplier’s format. One catalogue with full-text search and filters replaces manual lookup. Quotes get automatic margin, discount and EUR/CZK conversion, then export as PDF in two versions (for the customer, and internal with purchase prices and margins) or as supplier-specific XLSX orders. Every quote is frozen the moment it’s created, so old quotes never change.
What changed
Built so a quote takes minutes instead of hours.
About 4,000 products from one supplier import in seconds (my own test).
Stack
- Next.js (App Router)
- TypeScript (strict)
- Supabase (Postgres + Auth)
- jsPDF
- xlsx-js-style
- Vercel
Inside the system
Real screens from the system. Product, supplier and customer details are hidden.
References on request: after our first call, I’m happy to put you in touch with the client behind the quoting system.
Still building quotes in Excel and Word?A quoting system instead of Excel
