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.

image

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

image

Updating confirmation

After every change the seller will apply, a small window will pop for visual confirmation

image

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

image

GitHub

View Github