+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Advice for Inventory System (/thread-36429.html)
Advice for Inventory System - Extra - Feb-18-2022
Hello,
I'm looking to make an inventory system to keep track of my parts.
Here's some functions that I would like:
-An offline database (Stored locally on my dedicated PC.)
- Add/Remove Quanity
-Delete part from database
- Search Part
-Print Stats/Inventory
-Low quantity reminders (Sends email if quantity is lower than a certain number)
-Add details to inventory parts (Like buy price, sell price(This will be auto calculated Ex: The sell price would be adding 10% to the buy price), description, picture of part and location of part)
For the process I'm thinking:
-A screen that request the name of the user
-Once the user enters his/her name it stores the program users name in a record so it can track who is adding/taking parts from inventory.
-A main menu (G.U.I) is displayed that shows a list off all the parts in the inventory system (Only The part's name and picture will be displayed). In the top corner there will be a search button to search for item.
-The user searches for an item via search bar or just scrolling through the list.
-Once the user has found the part they're looking for, they click it and it takes them to the part page.
-The part page displays the parts information (current quantity, location, description, and buy/sell price(if provided)). In the bottom corner of the page there will be a "add to cart" button.
-Once the user click the "add to cart" button, a page will pop up requesting the quantity of the parts that they are taking.
-The user enters how many parts they're taking (let's say 10) and the program will add 10 of those parts to the cart.
-The user now has two options: check-out, or keep "shopping".
-If the user keeps "shopping" they add all they're required parts to the cart and when they are ready to check-out the program automatically updates the inventory (subtracts the 10 parts the user took and whatever else they added to the cart).
-Once the user has successfully checked out, the program created a record of what the user took and stores it in a folder on the pc. (ex: Bob enters his name and check out 10 led lights. The program will make a text file like this: User: Bob. Check-out Items: x10 Led Lights. Date: 01/01/01. And this text file will be saved as "Bob.txt" and stored in a folder called "Bob Access Records" on the pc)
So what should I use to create something like this?
-Should I do an html/CSS G.U.I that interacts with python? Or should I use something like Tkinter or PyQt5?
-Should I have a Json database that python can interact with?
-What about an excel sheet database that python interacts with?
-A MySQL database? (Can that be stored locally and accessed by python?)
-Should I use python for this, or should I use some other program?
Any help/advice on helping me get started and figuring out what software and plug-ins I can use is much appreciated.
Thanks in advance.