Python inventory tracker
A simple way to track and update the inventory
GUI
Using tKiner library for update on selling and refilling the products
Main window
Declaring sale by choosing the product from the combo box and quantity.
Updating/Adding product
In each box you’ll write the necessary information. If the product is allready exists in the data base you can choose it from the combo box, else the program will create a new product in the data base accordingly to the just received medicine name, date, quantity and minimum quantity data
Updating confirmation
After every change the seller will apply, a small window will pop for visual confirmation
Pandas library
Using pandas for extracting data from the data base
openpyxl library
Writing and reading from the Excel file
smtplib
Sending email from gmail acoount to update the seller about a product that has reached the minimum quantity or expiration date