Skip to main content
Back to cases
ProcurementWindows app

Supplier Qualification Tracker

Track each supplier's licenses, certifications, and contract dates. Alerts a month before anything expires.

The problem

Supplier docs scatter in email attachments. Expirations slip past; last-minute scrambles to re-sign block procurement.

The solution approach

A local ledger: one card per supplier with all docs and expiry dates; alerts at 30 / 15 / 7 days.

What you will end up with

  • Supplier card: basics + doc list (license, production permit, ISO, contract…).
  • Each doc has name, number, expiry, notes, local-file path.
  • Alerts at 30 / 15 / 7 days before expiry on the home dashboard.
  • Export this month's expiring list.

Ready-to-use prompt

You are a senior engineer building local desktop tools. The user is a procurement assistant, non-developer.

[Goal]
Stop relying on memory for supplier document expirations.

[Platform & Stack]
- Windows + macOS; Electron + React + TypeScript; local SQLite

[Core Features]
1. Supplier card: name, contact, phone, category, start date, notes.
2. Documents sub-table: type, number, expiry, local-file path.
3. Home "Expiry" card grouped into 30 / 15 / 7-day bands; row-level "renewed" with a small popup to update expiry.
4. Search + filter (category / expiring / expired).
5. Export expiring list Excel; export a supplier dossier PDF (HTML print is fine).

[Visual Style]
- Light background, white cards, radius 16, generous whitespace.
- Primary button muted dark; secondary light gray.
- Follows system dark mode; system fonts.

[Robustness]
- All data stays on the local machine. Offline.
- Autosave; 7-day rolling backups.
- Friendly messages on bad input, never raw stack traces.

[Delivery]
1. Outline project structure + plain-text wireframe first; wait for confirmation.
2. Deliver in modules; run each one for me to see.
3. Package a Windows .exe and macOS .dmg, ship a 500-word plain-language user guide, list known limits.

Start with structure and wireframe.

After copying

1

Open Codex Desktop and create a new project

2

Paste the prompt and send

3

Wait for Codex to finish; tweak company names, column names, button text as needed

More cases from this department