Skip to main content
Back to cases
LogisticsWindows app

Return Package Tracker

A local sheet to watch outbound returns: who hasn't arrived, who is stuck, who is overdue.

The problem

Return shipments hit transit issues, refused deliveries, wrong addresses. CS, warehouse, and finance fall out of sync.

The solution approach

A local ledger: enter return shipments (order, tracking, address, refund amount, status); group by status; flag overdue.

What you will end up with

  • Return list with four statuses (pending / in-transit / received / exception).
  • Over 7 days without signature = red.
  • Click to add a follow-up note (auto-timestamped).
  • Top stats: in-transit, exceptions, total refund amount.
  • Export the monthly ledger for finance.

Ready-to-use prompt

You are a senior engineer building local desktop tools. The user is an e-commerce logistics lead, non-developer.

[Goal]
Consolidate scattered return-shipment info into one local ledger, with status always visible.

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

[Core Features]
1. Columns: order, tracking, return address, refund amount, sent date, last note, status, free notes.
2. Four status tabs (pending / in-transit / received / exception).
3. Auto rule: > 7 days since sent without signature -> row red and shown in "overdue" card.
4. Detail drawer: add a timestamped follow-up note; change status.
5. Excel import with header mapping; export "monthly return ledger" with history.

[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

Customize this case in the generator

More cases from this department

Shipment Exception Inspector

Load the daily shipment export. Four rules flag stuck, failed, returned parcels. Hand the list to CS. Complaints drop by half.

Warehouse Stocktake Helper

Monthly stocktake: import the on-paper sheet and the counted sheet; auto-list surplus, shortage, and missing items with values.