Video Demonstration
Description
This was a collaborative project for my Databases course at Northern Illinois University. In a group we were given the goal of creating an online store using what we learned on SQL to store data and print it on a webpage. We had to create a customer interface and an employee interface.
The goals of this project
- Inventory Management:
- Display a list of products and their quantities in stock.
- Showcase available products with details on individual items.
- Include an option to add products to a shopping cart from the product details page.
- Shopping Cart:
- Each user has a shopping cart to add items for purchase.
- Users can view, modify (remove or change quantities), and submit their orders.
- Store state information (e.g., in a database, session variables) to maintain cart contents.
- Once an order is submitted, associate the items with the order and reset the cart.
- Checkout:
- Checkout page for users to safely enter shipping and fake billing information.
- Display the total value of items in the cart and allow users to finalize their order.
- Order Handling:
- When an order is placed, store order details in the database.
- Orders start as "Processing" and can be updated by store workers.
- Generate three views:
- User order tracking: Allows users to check their order status, tracking numbers, and total amounts paid.
- List of outstanding orders: Helps employees know which orders need to be shipped.
- Order fulfillment page: Enables employees to view individual orders and mark them as shipped.