all projects
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
One sale, one transaction

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.