Inventory Management System

Development of an online Sales and Inventory Management System (SIMS)

Abstract of the project

This project is aimed at developing an online Sales and Inventory Management System (SIMS) for a departmental store. This system can be used to store the details of the inventory, update the inventory based on the sale details, produce receipts for sales, generate sales and inventory reports periodically etc. This is one integrated system that contains both the user component (used by salespersons, sales managers inventory managers etc) and the admin component (used by the administrators for performing admin level functions such as adding new items to the inventory, changing the price of an item etc).

This system runs on multiple terminals, offers a GUI interface to its users and connects to a common database(s).

Functional components of the project

Following is a list of functionalities of the system. More functionalities that you find appropriate can be added to this list. And, in places where the description of a functionality is not adequate, you can make appropriate assumptions and proceed.

There are registered people in the system (sales people working in the shop, inventory managers, admin et al). Each one of them may have some exclusive privileges (admin, for example, could create new users to the system whereas sales people cannot).

1. A sales person should be able to

• login to the system through the initial screen of the system

• change the password after logging into the system

• see the status of the inventory, ie, whether a particular item is available or not etc

• search for a particular item by typing the initial letters (‘app’ for example may bring up the item ‘apple’ in the top) or by category-wise (apple, for example, may be looked up by going through the category ‘fruits’)

• enter the items purchased by a customer and produce a bill for the same (the bill will have a unique sale id, date, time, item/quantity/price details etc)

•...