Problem Statement Retail clothing shop owners require an integrated inventory and rental management system to accurately track unique garment stock levels, categorize items by designer and clothing type, and monitor the current status, customer, and expected return dates for all rented-out items, thereby minimizing loss, optimizing asset utilization, and providing comprehensive financial reporting for both rental and retail segments. Detailed Problem Description: Integrated Retail and Rental Management The existing methods (often spreadsheets or simple POS systems) used by shop owners fail to handle the dual life cycle of garments—sales and rentals—leading to critical gaps in organization, accounting, and asset recovery.

1. Core Inventory Management and Categorization Challenges The foundation of the problem lies in the difficulty of maintaining a structured inventory: Organizational Inaccuracy: Shop owners struggle to maintain a clean database that correctly enforces relationships between Designer (Brand) and Clothing Type (e.g., Trousers, Blouse). Manual systems make querying difficult, preventing the owner from quickly isolating, for example, "all size 8 evening dresses by Designer X." Inaccurate Stock Levels: With rentals, stock can be In Stock, Rented Out, or In Cleaning. This complexity requires a system that tracks the specific physical Status of each unique item, not just a static quantity, leading to frequent discrepancies between physical count and system records. Profit Segmentation: Current tools do not easily allow the owner to segment Profit made from Retail Sales versus Rentals, making performance analysis difficult.
2. The Dynamic Challenge of Rental Tracking and Returns The rental component introduces several layers of dynamic tracking and risk: Asset Status and Availability: The system must track the item's current status accurately: Available, Rented Out, Maintenance/Cleaning, or Sold. This allows for real-time reporting on which items are available for immediate sale or rent. Returns Management (Garments Due): Shop owners require a centralized view to track exactly how many garments are due to return on a given day (based on the Expected Return Date) and how many still remain to be returned (items past their due date where the Actual Return Date is null). This is essential for stock planning and imposing late fees. Customer and Timeline Accountability: The system must record a binding link between the specific Inventory Item, the Customer, the Rental Date, and the Expected Return Date. Failure to track this accurately results in lost revenue and potential asset loss. Restock Prediction: The system must automatically calculate when currently unavailable rented items will become restocked again (i.e., available for the next customer) based on the expected return date plus cleaning time.
3. Impact and Need for an Integrated Solution The overall problem is that the shop owner cannot treat their inventory as a manageable, fluid resource. They need a single, integrated platform that enables them to: Generate a Full Sales Dashboard showing profit breakdown by retail and rental segments. Manage the Returns Pipeline by tracking due dates and outstanding garments. Predict future inventory availability to allow for better sales and rental forecasting. The solution must be a robust relational database that links the static inventory details to the dynamic transactional and returns data.