Highlights

• Problem: The pub needed a cost-effective, flexible solution to manage stock levels and reduce waste.
• Design: Created a lightweight, custom backend with Python, using Flask and SQLite, ensuring scalability and simplicity.
• Frontend: Developed a responsive web interface for intuitive stock tracking and adjustments with HTML, CSS, and Javascript.
• Features:
  • Real-time inventory tracking for beers and spirits.
  • Adjustment logs with transaction history for accountability.
  • Automated daily backups to prevent data loss.
  • Database imported into PowerBI for customizable reporting.
• Impact: Improved stock accuracy, stopped wasting expired products, and avoided subscription costs for off-the-shelf software.

This project showcases how tailored software can solve specific business challenges while integrating seamlessly into existing workflows.