Overview The Inventory Management System is a program developed as a project for CSC 392. It is designed to help users manage a product inventory, and it is particularly relevant to the place where I completed my SIWES (Students Industrial Work Experience Scheme). The program is similar to an inventory management system used by my SIWES company to track computer systems, printers, routers, and other assets.
To use the Inventory Management System, follow these steps:
- Insert the provided disk (e.g., CD, DVD, or USB) into your computer.
- Open the file explorer and navigate to the disk drive.
- Locate the "Inventory program.exe" file on the disk.
- Double-click the "Inventory program.exe" file to launch the program.
Upon launching the Inventory Management System, you will be presented with a user-friendly graphical interface. The program provides various actions for managing the inventory. Here's how to use the different features:
• Click the "Add Product" button. • In the "Add Product" window, enter the product details: • Product Name • Product Description • Product Quantity • Product Unit Price • Product Supplier • Click the "Add Product" button in the "Add Product" window to add the product to the inventory.
• Click the "Update Product" button. • In the "Update Product" window, enter the following information: • Product ID: Enter the ID of the product you want to update. • Field to Update: Select the field you want to update (quantity, unit price, or supplier). • New Value: Enter the new value for the selected field. • Click the "Update Product" button in the "Update Product" window to save the changes.
• Click the "Delete Product" button. • In the "Delete Product" window, enter the ID of the product you want to delete. • Click the "Delete Product" button in the "Delete Product" window to remove the product from the inventory.
• Click the "List Products" button. • A new window will open, displaying a list of all products in the inventory. • The information includes the product ID, name, description, quantity, unit price, and supplier.
• Click the "Import Products" button. • Ensure that an Excel file named "products.xlsx" is present in the same directory as the program. • The Excel file should have columns for name, description, quantity, unit price, and supplier. • The program will read the data from the Excel file and add the products to the inventory.
• Click the "Export Products" button. • All products in the inventory will be exported to an Excel file named "products_export.xlsx" in the same directory as the program. • The exported Excel file will have columns for product ID, name, description, quantity, unit price, and supplier.
• Click the "Help" button. • A new window will open, displaying a help message. • The help message provides information about the available commands and their functionalities.
• Click the "Exit" button to close the program.