LogisticsWindows app
Warehouse Stocktake Helper
Monthly stocktake: import the on-paper sheet and the counted sheet; auto-list surplus, shortage, and missing items with values.
The problem
After a count, paper vs. physical never quite matches. Eyeballing thousands of SKUs takes hours.
The solution approach
A local tool. Import both sheets; auto-diff by SKU; group results by type with totals.
What you will end up with
- Left: on-paper Excel. Right: counted Excel.
- Click "Start" — three tables: surplus / shortage / unaccounted.
- Each row: SKU, name, on-paper qty, counted qty, diff, unit price, value diff.
- Export diff to Excel for finance + warehouse.
Ready-to-use prompt
You are a senior engineer building local desktop tools. The user is a warehouse/logistics lead, non-developer.
[Goal]
Compute monthly stocktake diffs (with values) in one go.
[Platform & Stack]
- Windows + macOS; Electron + React + TypeScript; SheetJS
[Core Features]
1. Two imports: on-paper Excel and counted Excel. Field mapping (SKU, name, qty, price) confirmed via dropdown.
2. Compare by SKU; classify into surplus / shortage / unaccounted / extra; show each group.
3. Per-row diff qty and value; bottom totals (surplus, shortage, net).
4. Top stats: total SKUs, diff count, diff rate, net value.
5. Export diff Excel with four sheets.
[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