Desktop app · in daily useIn use at a shop
Inventory Management System.
Billing and stock software for a motorcycle spare-parts shop.
A desktop app for the shop counter: search a part, bill it, print the invoice, track stock. It runs on a local SQLite database. Only the supplier invoice import needs internet.
- Python
- PyQt6
- SQLite
- ReportLab
- Gemini API
fig. 03
Bill #0412
- Spark plug×2
Items2
stock
- Spark plug14
- Brake shoe set6
- Chain kit3
BEGIN;
insert bill + lines
update stock
What I built
- Keyboard-first billing screen, so the clerk rarely needs the mouse.
- Each sale (bill, line items, stock change) is saved in one SQLite transaction, so it fully succeeds or fully fails.
- Stock is checked before a sale, so stock can't go negative.
- Voiding a bill puts the items back in stock.
- PDF invoices for thermal and A4 printers.
- Supplier invoice import: Gemini reads the PDF or photo, and the clerk reviews every line before stock is updated.
- One-click zip backup of the database.
Hard parts
CHALLENGE // 01
Stock counts drifting
- Problem
- Paper bills and end-of-day tallying meant counts were often wrong.
- Fix
- Stock changes only happen inside the sale transaction, after a check.
CHALLENGE // 02
Typing in supplier deliveries
- Problem
- Entering a long delivery by hand was slow.
- Fix
- Let Gemini extract the lines, then match them to existing parts and have the clerk confirm.
- Learned
- AI extraction is only safe with a human check before it touches stock.