User Guide
How to use the E-Commerce Management System
System Overview
This web application manages an e-commerce database system with the following key features:
1. Customer Registration
Purpose: Register new customers in the system
How to use:
- Navigate to "Customer Registration" from the menu
- Fill in full name (minimum 2 characters)
- Enter a valid email address (must be unique)
- Provide a phone number
- Click "Register Customer" to submit
Notes: Customer ID is auto-generated starting from 1001
2. Search Products
Purpose: Find products using various filters
How to use:
- Enter product name (supports partial matching)
- Select category, size, and color filters (optional)
- Set price range if needed
- Click "Search Products" to view results
Features:
- Partial name matching (e.g., "shirt" finds "T-Shirt", "Blue Shirt")
- Multiple filter options can be combined
- Results displayed in a table format
3. Place Order
Purpose: Create new customer orders
How to use:
- Enter existing Customer ID
- Select order date and time
- Add products by entering Product ID, Quantity, and Unit Price
- Click "+ Add Another Product" to add multiple items
- Select order status
- Total amount is calculated automatically
- Click "Place Order" to submit
Constraints:
- Each product can only appear once per order
- Quantity must be at least 1
- Order ID auto-generated starting from 10001
4. Admin Panel (Role-Based Access)
Purpose: Administrative functions with role-based permissions
How to use:
- Login with username, password, and select role
- Access level depends on role selected
Available Roles:
- Admin: Full CRUD on all tables. Can create tables, views, procedures, and triggers.
- Manager: Read and update on most tables. Can view reports, manage inventory, update order statuses. Cannot delete critical data.
- Sales Staff: Can create and view customer orders and manage customer information. Read access to products. Cannot modify prices.
- Inventory Manager: Full CRUD on Inventory table. Can update inventory levels and manage store stock. Read access to orders.
- Read Only: View-only access to all tables. Cannot make any changes. Suitable for analysts and auditors.
5. Payment Processing
Purpose: Process payments for orders
How to use:
- Enter Order ID to process payment
- Select payment method (Credit Card, Debit Card, Cash, Bank Transfer)
- Fill in payment-specific details based on method selected
- Set payment status
- Click "Process Payment" to complete
Payment Methods:
- Credit/Debit Card: Enter card number, holder name, expiry, CVV
- Cash: Enter amount received, change calculated automatically
- Bank Transfer: Enter bank details and transaction reference