When the commodity stack up, the inventory may become messy and difficult to monitor the inventory status. It is difficult determine when stock replenishment is needed. Also, when customers need certain products which are out-of-stock, it is hard to know which other branch stores have those items.
With the aid of our system, staff would be able to examine the current status of the commodity in different shops and do some follow up actions.the smart inventory system provides an systematic approach to help increase the efficiency.
The program is an integation of inventory database and user cilent. Using the user cilent, staff can update the database and retrive the inventory status from the database.
- Search commodity in different shops using different filters and find information through sorting by column heading
- Insert commodity information (name, manufacturer, amount, price, availability of shop(s)) after each procurement
- Delete obsolete commodity
- Update commodity information
- Automatic change of inventory status according to the amount of commodity that is currently available
- Deliver alerts when the commodity is “OUT-OF-STOCK” and when the inventory for an item reaches the alert threshold
- Give monthly reports of sales and inventory change
- Customers order recording function, and automatically delete bought items in the inventory. The amount that needed to pay by the customers would be calculated
make build
./build
You can use test as the shop ID for testing, where test_status.txt and test_transaction contain the sample database.
We stored the inventory database into two different files, i.e. xxx_status.txt and xxx_transaction.txt, which handles the status of each unique item and records every transaction detail. Details are as follow.(<> represent a field) Each individual shops have two files.
<Product ID>|<Product Name>|<Category Name>|<Manufacturer>|<Unit Cost>|<Amount>|<Date>
ID00001|Milk|Dairy|Waikei|100|10000|Thu Apr 25 22:55:49 2019
<Product ID>|<Product Name>|<Category Name>|<Manufacturer>|<Unit Selling Price>|<Amount>|<Date>
ID00001|Milk|Dairy|Waikei|150|-2|Thu Apr 26 22:55:49 2019
<Product ID>|<Product Name>|<Category Name>|<Manufacturer>|<Selling Price>|<Amount>|<Status>
ID00001|Milk|Dairy|Waikei|120|10000|IN-STOCK
ID00002|Milk tea|Dairy|Waikei|140|0|OUT-OF-STOCK
This module allows the user to update the inventory when new items are bought and ready for sale. It requires the user to input the detail of the commodity. The system will automatically store the detail into database and record the time of purchase, inputting data into transaction file and status file.
This module allows the user to update the item details which already exist in the database in case of details erorrs or modification of price tag.
This module allows the user to choose which branch store inventory status he/she would like to view. It allows the user to search(Product ID/Product Name/Category Name/Manufacturer/Status) in the inventory status, and view the inventory status by sorting different columns.
Please use fullscreen to obtain the best result
This module allows the user to delete the commodity that is expired or not avavilble any more.
This module allows the staff to perform a checkout action. The system prompts the user to input the product ID and amount, then the system will output the total. Once the staff confirms the transaction, it will be recorded. If the product that customer wants is out-of-stock, the system will show which branch stores in other locatons have the product.
This module allows user the get the summary of the transaction in a month, like inventory change or gross profit. Also it provides staff with information of which item is the best selling or the most profit making.
When a commodity stock amount in the user's branch store reaches the threshold amount(default 30) or becoming out-of-stock, an alert will appear once the user open the menu interface. The threshold amount could be modified in the setting.
- Change the threshold amount for the alert system
- Change Shop ID