PremiumSupply: AI spreadsheet import for a B2B parts-trading hub
Maneet Goyal
Published
0
A B2B parts-trading hub. Customers sent orders as messy spreadsheets that staff re-typed by hand. I built an AI import: the app samples the sheet, asks Claude to find where the data starts and map each column to a field, then checks every row and points any error back to its exact Excel cell.
- Turns order lines into margin-optimal supplier orders
- Prices offers by strategy and renders PDF offers with a pooled headless Chrome service
- End-to-end typed API from the Bun and ElysiaJS backend to the SvelteKit frontend
- Full-text search across seven tables in Postgres
Stack: Bun, ElysiaJS, SvelteKit, PostgreSQL, Drizzle ORM, TypeBox, Anthropic API, Puppeteer