Lovable Prompt Creator - AI Prompt Generator

## APPLICATION OVERVIEW
This web application serves as an inventory management tool specifically designed for users to import and update beverage inventory data from Excel files. Its primary purpose is to allow users to correct and manage their beverage costs efficiently by uploading new data seamlessly from their local devices or cloud storage.

## CORE FEATURES
1. **Excel Import Functionality**: Users can upload Excel files containing beverage inventory data to replace or update existing entries in the system.
2. **Data Validation**: The application will validate the imported data to ensure all necessary fields are present and correctly formatted, alerting users to any issues.
3. **Inventory List Display**: A clean and organized list of current inventory items, showing beverage names, costs, and quantities, enabling users to quickly review their data.
4. **Cost Update Functionality**: Users can manually update costs for existing items directly within the inventory list, ensuring flexibility and accuracy.
5. **Search and Filter Options**: Users can search for specific beverages or filter the inventory list based on various criteria such as cost range and beverage type.
6. **Responsive Design**: The application will be fully responsive, ensuring optimal usability across devices, from desktop to mobile.

## DESIGN SPECIFICATIONS
- **Visual Style**: Minimalist - The interface will feature a clean and simple design with ample white space to enhance readability and user focus. 
- **Color Mode**: The app will utilize a light theme with dark text on light backgrounds for optimal contrast and readability.
- **Layout**: The main layout will consist of a top navigation bar for easy access to import and management features, with a primary content area displaying the inventory list in a card format. Each card will show relevant item details and action buttons.
- **Typography**: Use a sans-serif font such as "Roboto" or "Open Sans" for clarity. Headings will be bold and larger for hierarchy, while body text will be regular weight for easy reading.

## TECHNICAL REQUIREMENTS
- **Framework**: React with TypeScript for robust type checking and component management.
- **Styling**: Tailwind CSS for utility-first styling, enabling rapid UI development.
- **UI Components**: Utilize shadcn/ui for pre-built, accessible UI components to enhance the application’s design.
- **State Management**: Consider using React's Context API for global state management, particularly to manage the inventory data.

## IMPLEMENTATION STEPS
1. **Set Up Project**: Initialize a new React project using Create React App with TypeScript template.
2. **Install Dependencies**: Install Tailwind CSS and shadcn/ui components along with any necessary TypeScript types.
3. **Create Layout Structure**: Build the main layout with a navigation bar and the primary content area for the inventory list.
4. **Implement Excel Upload Feature**: Develop the functionality to allow users to upload Excel files, integrating a file input component.
5. **Data Validation Logic**: Create functions to validate the imported data against required fields and formats.
6. **Display Inventory List**: Create a component to render the inventory list, utilizing Tailwind CSS for styling and responsive design.
7. **Add Cost Update and Search/Filter Features**: Implement the functionality for users to update costs and search/filter the inventory items.
8. **Testing and QA**: Conduct thorough testing to ensure all features function correctly and the user experience is seamless.

## USER EXPERIENCE
Upon entering the application, users will see a clean interface with an intuitive navigation bar at the top. They can easily upload a new Excel file through a prominent upload button. Once the file is uploaded, the application will validate the data and display the updated inventory list. Users can interact with the list to search for specific items, filter results, or update costs directly. The responsive design ensures that the layout adapts seamlessly to various screen sizes, maintaining usability regardless of the device.