ProcurementWindows app
Supplier Price Monitor
Centralize multi-supplier quotes for each SKU. Auto-flag best price and unusual increases. Stop ordering on gut feel.
The problem
Procurement collects quotes from many suppliers in many formats weekly. Manual comparison takes hours. Price creep often goes unnoticed until budgets hurt.
The solution approach
A local ledger. Paste or import each round of quotes. The tool aggregates by SKU across suppliers, computes min/mean/latest change, and highlights anomalies at a glance.
What you will end up with
- Home lists SKUs with latest min price, supplier name, % change vs last period.
- Click a SKU to see a simple historical price line chart.
- Import from Excel (rows: Date / SKU / Supplier / Unit Price / Unit).
- Auto-red flag any jump over threshold (default 5%).
- One-click export of "best supplier of the month" to Excel for negotiation.
Ready-to-use prompt
You are a senior engineer experienced with Windows desktop apps. Build a local Windows tool for the procurement team at an e-commerce company. User is a non-developer.
[Goal]
Aggregate weekly supplier quotes, compare across suppliers, flag best prices and unusual increases, and support data-driven ordering.
[Platform & Stack]
- Windows 10/11 desktop app
- Electron + React + TypeScript
- Local SQLite for quote history
- SheetJS for Excel
- Fully offline; ship a Windows .exe installer
[Core Features]
1. Home SKU list: name, latest min price, supplier, % change vs last period (red up, green down).
2. SKU detail: all suppliers' latest quotes side by side, min/mean, a simple 12-period line chart.
3. Data input:
- Single-entry paste (Date / SKU / Supplier / Unit Price / Unit).
- Excel bulk import with smart header matching (Chinese + English). Prompt when fields are missing.
4. Threshold alerts: increase > 5% (configurable) turns red; drop > 5% green. Top bar shows "N anomalies this week".
5. Export "Best suppliers of the month" to Excel with SKU / Best Supplier / Best Price / Savings.
6. Filter by SKU / Supplier / Date. Search.
7. Local storage; one-click export of full ledger backup for portability.
[Visual Style]
- Dashboard density, clean tables, subtle dividers.
- Neutral palette: white background, deep gray text, red/green only for delta indicators.
- Minimalist line charts.
- Follows system dark mode.
[Robustness]
- Empty state with "Import Excel to start tracking".
- Missing columns: highlight which columns are missing with an example.
- Auto-recover DB from last backup on corruption.
[Delivery]
1. Start with structure + wireframes for home, detail, and import views.
2. Phase 1: entry + SKU list. Phase 2: detail + chart. Phase 3: alerts + export.
3. Package .exe; write a 500-word plain-language user guide.
Start with the 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