PrepZone Logo
PrepZone
All project ideas

Beginner · 2–3 weeks

Small Shop Inventory Management

Track products, stock levels, suppliers, and stock-in/stock-out movements. Low-stock alerts, movement history audit trail, and simple sales recording that decrements inventory.

Why this project

Inventory is transactional — stock must never go negative. Interviewers ask about concurrency and audit trails.

Tech stack

Java 17Spring Boot 3Spring Data JPAMySQL@Transactional@Version

Skills demonstrated

  • Inventory transactions
  • Optimistic locking
  • Audit trail
  • Alert thresholds

Interview talking points

  • Stock movement as immutable audit log
  • Optimistic locking with @Version on Product
  • Preventing negative stock in service layer
  • Low-stock alert query and scheduled check

Problem statement

Track products, stock levels, suppliers, and stock-in/stock-out movements. Low-stock alerts, movement history audit trail, and simple sales recording that decrements inventory.