Project Description

Stockify is a desktop stock control app built in Python using the Tkinter module, providing a user-friendly interface. 
It integrates with an Oracle SQL database, making it easy to assign users to devices, devices to storages, and track inventory in real-time.

App Features

Python

This desktop app is fully designed in Python using Customtkinter for the GUI, allowing anyone with basic Python knowledge to modify it using 
the provided documentation.

learn more

Oracle SQL

Stockify is adapted to use an Oracle SQL database to make the SELECT, CREATE, INSERT and DELETE queries, but it can also be adapted to PostgreSQL or MySQL, when selected in the installation

learn more

Documentation

The project includes documentation of all providing documentation on continuos development and exporting the app from Python (.py) to an executable.

learn more

Dashboards

Stockify includes a dashboard section that displays device types available in storage and assigned to users, with filtering applied by location.

learn more

Bulk Import

The app allows bulk data import via CSV, and if discrepancies between CSV data (e.g., user-device or device-storage assignments) and the database arise, a window displays the differences for selecting the most up-to-date information

learn more

Responsiveness

The app is optimized for speed, delivering rapid performance when executing SELECT queries, updating data, bulk importing, and displaying dashboards.

learn more

YouTube Videos

Check out both videos on my YouTube channel @freddylife01, also shown below:
Stockify Part 1: App Overview and Presentation
Stockify Part 2: Live App Demonstration"

Showcase project work

2

Engage audience with videos

100+

Highlight project features

19

Attract attention with logo

150

This project took four months to complete, and I’m extremely satisfied with the result. Throughout the process, I gained valuable knowledge in Python and Oracle SQL, and I'm proud to have successfully overcome the challenges faced along the way.

Federico Mencuccini
FORMER Systems administrator and cloud student

faq

What if I have no experience in Python?

My documentation provides a clear understanding of most of the Python code in this app. For any sections that remain unclear, I encourage you to first attempt to understand them on your own, and if needed, use AI tools for further clarification

What types of devices can be managed with the Stockify app?

You can add as many device types as you need. The app includes an option to select the type when adding a device. Once added, the device type will appear in the selection box, populated from the database. Initially, you will start with zero device types

Are there any tutorials or resources available to help me learn how to use the app effectively

Yes, they are. My Part 2 video on my YouTube channel showcases each section of the app and provides guidance on how to use it

➡️ Stockify Part 2: Live App Demonstration

Can I access Stockify from multiple devices or locations?

Yes, it is possible, but the database must have a public domain; otherwise, it can only be accessed from the private network where the database is located. To start using the app, you can download the ➡️ Oracle Instant Client.