Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Advice for Inventory System
#1
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.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Difference between os.system("clear") and os.system("cls") chmsrohit 7 16,492 Jan-11-2021, 06:30 PM
Last Post: ykumar34
  Communicating Roblox's Inventory API with python? 4TH4RV 1 2,028 Jun-22-2020, 10:30 AM
Last Post: snippsat
Question Difference between Python's os.system and Perl's system command Agile741 13 6,653 Dec-02-2019, 04:41 PM
Last Post: Agile741
  Store a product/item in a inventory program viktoria_linn 1 4,024 Jul-02-2019, 09:26 PM
Last Post: DeaD_EyE
  What area unit the opposite ways in which to understand if an inventory in Python is Smhbugra 2 2,430 May-27-2019, 07:55 PM
Last Post: Larz60+
  Python inventory system with dicts. 2skywalkers 7 5,809 Aug-23-2018, 05:06 PM
Last Post: ichabod801
  Python simple store inventory system. 2skywalkers 3 9,755 Aug-19-2018, 06:12 PM
Last Post: Gribouillis

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020