User Management (CRUD)
Create: Register new customer profiles with secure password hashing.
Read: Fetch user profiles, account details, and address books.
Update: Modify user information, preferences, and account settings.
Delete: Deactivate or permanently remove user accounts.
Product Catalog & Inventory (CRUD)
Create: Add new products with titles, detailed descriptions, pricing, SKU codes, and stock quantities.
Read: Retrieve individual product details or fetch paginated, filterable product catalogs.
Update: Modify product attributes, pricing changes, or live inventory counts.
Delete: Remove discontinued or outdated items from the catalog.
Product Reviews & Ratings (CRUD)
Create: Enable verified customers to submit star ratings and written reviews for purchased products.
Read: Fetch all reviews associated with a specific product or user.
Update: Allow users to edit their previously submitted feedback.
Delete: Remove inappropriate or deleted reviews from the system.
Shopping Cart System (CRUD & Management)
Create/Add: Add items and specify quantities to a customer's active shopping cart session.
Read: Retrieve cart contents, computing real-time sub-totals, itemized prices, and total quantities.
Update: Modify item quantities dynamically or clear specific lines within the cart.
Delete: Remove items from the cart or empty the entire cart session.
Order Processing & Fulfillment (Cart-to-Order Pipeline)
Order Creation (Checkout): Directly transitions items from the user's active Cart into a confirmed Order, generating unique order IDs, logging shipping details, and capturing payment status.
Read: Track and view order history, current fulfillment status, and detailed invoice summaries.
Update: Update order statuses (e.g., Pending, Processing, Shipped, Delivered, Cancelled).
Delete: Handle order cancellations or archiving workflows safely.