Python inventory tracker

A simple way to track and update the inventory


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


Sending email from gmail acoount to update the seller about a product that has reached the minimum quantity or expiration date



View Github