Back to the archive
Status: Pre-launch
SuperMarché
A till and stock app for a shopping centre in Ouagadougou: invoices with computed VAT, a customer file and product management.
- 4MySQL tables: customers, products, invoices, lines
- 18 %VAT computed on every invoice
Context
A team project at the African Institute of Management in Ouagadougou, around running a supermarket.
Problem
Stock tracked by hand, inaccurate tax calculations and no customer tracking.
Objective
Automate the till and invoicing, compute VAT and keep a history of customers and products.
Architecture
A Python desktop app: Tkinter interface, data-access layer with mysql-connector, MySQL database.
- TillCustomer, products and quantities added to the cart.
- InvoiceGross total, 18% VAT and net total computed, invoice saved and printable.
- StockAdmin area: add, edit or delete a product.
Technologies
- Python
- Tkinter
- Pillow
- MySQL
- mysql-connector
Features
- Customer record found by phone number
- Cart, numbered invoice and automatic VAT calculation
- Invoices and their lines saved in the database
- Stock management: add, edit and delete products
Result
Pre-launch: till, invoicing and stock management built and presented at IAM; the project continues.
Possible evolution
- Sales dashboard
- Mobile version
Code and demo
Not published