This project was created thanks to the SQLite ORM library and SQLite .
Store Management System is based on a concept of recording, refilling stock items, and placing orders by users. It operates on the SQLite database which is created when the program is first started.
Before stepping into the dealer’s menu a user has to pass through a login system to get access.
1. Log in
2. Create Account
0. Exit
2
Please enter your name:
Alice
Account has been created!
Your ID: 6
Your login: Alice
Password: frAQBc8W
Press any key to continue . . .
1. Log in
2. Create Account
0. Exit
1
Please enter your ID:
6
Please enter your password:
frAQBc8W
Succesfully logged: 6 Alice
The user can place orders, display orders, check order status or delete his account. To purchase an item, the user has to provide the product’s name and quantity.
Place order option
1. Place Order
2. Check order
3. Display all orders
4. Delete account
0. Log out
1
4 products available in stock:
ID NAME PRICE QUANTITY
1 strawberry 4.50 4923
2 orange 6.80 5878
3 blueberry 6.90 5346
Please enter product ID:
1
Enter quantity:
22
Order: 1 created.
Press any key to continue . . .
Admin account is created by default with user id 0 and password "ADMIN".
Please enter your ID:
0
Please enter your password:
ADMIN
Succesfully logged: 0 ADMIN
Admin menu provide the following features:
- Add products
- Cancel order
- Display all orders
- Complete order
- Display stock
- Delete product from stock
- Add or subtract qty from stock
- Display Users Statistics
- Log out
While adding items the admin has to provide product name and price. Refilling the stock is available under option Add or subtract qty from stock
. Removing an item is too easy, he/she just has to provide product id. From the customer’s menu, the user can only purchase and view stocks.
Display all orders
Order ID USER ID USER NAME PROD. NAME PROD. ID ORDER QTY UNIT PRICE TOTAL PRICE STATUS
1 1 Alice strawberry 1 55 4.50 247.50 completed
2 1 Agata orange 2 56 6.80 380.80 completed
3 1 Elon blueberry 3 666 6.90 4595.40 completed
4 2 Matt orange 2 66 6.80 448.80 completed
5 2 Eve strawberry 1 22 4.50 99.00 completed
6 2 Agnieszka strawberry 1 78 4.50 351.00 canceled
7 2 Agata blueberry 3 988 6.90 6817.20 completed
8 6 Alice strawberry 1 22 4.50 99.00 new
Press any key to continue . . .
Display stock
4 products available in stock:
ID NAME PRICE QUANTITY
1 strawberry 4.50 4923
2 orange 6.80 5878
3 blueberry 6.90 5346
Press any key to continue . . .
Display Users Statistics - all users with total active orders
Alice - total active orders: 1
Complete order - display only active orders - with status new
Order ID USER ID USER NAME PROD. NAME PROD. ID ORDER QTY UNIT PRICE TOTAL PRICE STATUS
8 6 Alice truskawki 1 22 4.50 99.00 new
Please enter order ID:
8
Order ID: 8 is ready
Order quantity: 22
Qty remaining in stock: 4901
Please confirm completion. Y/N
y
Order completed successfully!
Press any key to continue . . .