Product Lifecycle Management and Expiry Alert System: A Web-Based Approach for Small and Medium Enterprises

Product Lifecycle Management and Expiry Alert System: A Web-Based Approach for Small and Medium Enterprises

Dr. Vijesh. K Head of Department Department of MCA

AJ Institute of Engineering and Technology, Mangalore, India

Ms. Shradda Nayak

Department of MCA

AJ Institute of Engineering and Technology, Mangalore, India

Mr. Likhesh

Department of MCA

AJ Institute of Engineering and Technology, Mangalore, India

Mrs. Jayashree J Assistant Professor, Department of MCA

AJ Institute of Engineering and Technology, Mangalore, India

Ms. Swathi Kuma

Department of MCA

AJ Institute of Engineering and Technology, Mangalore, India

Mr. Prayag P

Department of MCA

AJ Institute of Engineering and

AJ Institute of Engineering and Technology,

Abstract -Product Lifecycle Management (PLM) systems are crucial for businesses to track product information, monitor expiry dates, and generate comprehensive reports. However, existing enterprise PLM solutions are often complex, expensive, and difficult to implement for small and medium enterprises (SMEs). This paper presents a lightweight, web-based PLM system with integrated expiry alert functionality designed specifically for SMEs. The system utilizes PHP, HTML, CSS, JavaScript, and MySQL to provide essential PLM features including product data management, automated expiry tracking, and comprehensive reporting capabilities. Through formative research involving 45 SME representatives, we identified key requirements and design goals for an accessible PLM solution. User acceptance testing demonstrated 92% satisfaction rates with 95% lower implementation costs compared to enterprise alternatives. The proposed system addresses the critical gap between manual tracking methods and expensive enterprise solutions, making PLM accessible to resource- constrained organizations while maintaining essential functionality.

Keyword:Product Lifecycle Management, Expiry Alert System, Web-based Application, Small Medium Enterprises, Database Management,

PHP, MySQL, User Interface Design, Cost- Effective Solution

1. INTRODUCTION

   Product Lifecycle Management (PLM) covers a products entire journeyfrom its initial idea and design to manufacturing and final disposal.In today's competitive business environment, effective PLM systems are essential for maintaining product quality, ensuring regulatory compliance, and optimizing operational efficiency. Traditional PLM solutions such as SAP PLM, Oracle Agile, and Siemens Teamcenter offer comprehensive functionality but present significant barriers for small and medium enterprises due to their complexity, high implementation costs, and extensive training requirements. These enterprise- grade systems often require months of implementation, dedicated IT staff, and substantial financial investment that many SMEs cannot afford. The challenge of product expiry management is particularly critical in industries such as pharmaceuticals, food and beverage, cosmetics, and chemicals, where expired products can result in financial losses, regulatory violations, and potential health risks.

2. LITERATURE REVIEW

   1. Existing PLM Solutions

      Current PLM research primarily focuses on enterprise-level solutions designed for large corporations. Enterprise PLM systems like SAP PLM require significant financial investment, with licensing costs ranging from

      $50,000 to $500,000 annually, making them inaccessible to SMEs. These systems often include complex features such as advanced CAD integration, sophisticated workflow management, and extensive customization options that exceed SME requirements. Implementation timelines typically span 6-18 months, requiring dedicated project teams and extensive user training. The complexity of these systems results in low user adoption rates and high maintenance costs, creating barriers for organizations with limited IT resources.

   2. Expiry Management Systems

      Existing expiry management research focuses primarily on retail and inventory management applications. Most solutions treat expiry tracking as an isolated function rather than integrating it with comprehensive product lifecycle management. Current systems lack proactive alerting mechanisms and fail to provide comprehensive reporting capabilities required for regulatory compliance. The separation of expiry management from PLM functionality forces organizations to maintain multiple systems, increasing complexity and costs. Research indicates that 70% of SMEs rely on manual spreadsheet-based tracking methods, highlighting the need for integrated, accessible solutions that combine PLM and expiry management capabilities.

   3. Research Gap Identification

   The literature reveals a significant gap between simple expiry tracking applications and comprehensive enterprise PLM solutions. No existing research addresses the specific needs of SMEs requiring integrated PLM and expiry management capabilities. Current solutions either lack the comprehensive features needed for effective product lifecycle management or are too complex and expensive for SME implementation. This gap represents a critical opportunity for developing focused, cost-effective solutions that address SME requirements without the complexity overhead of enterprise systems. The absence of web-based, open-source PLM solutions specifically designed for SMEs further emphasizes the need for accessible alternatives that can be implemented quickly and operated with minimal technical expertise.

3. SYSTEM DESIGN AND ARCHITECTURE

   1. System Requirements Analysis

      The system requirements were derived from comprehensive formative research involving 45 SME representatives across pharmaceuticals, food processing, cosmetics, and manufacturing industries. Product Lifecycle Management helps track a product from its early idea to its end. It includes tools to manage product details, check expiry dates, create reports, and keep the system secure with user

      logins .Non-functional requirements emphasize simplicity, cost-effectiveness, performance, and scalability. The system must support concurrent users, provide real-time data access, and maintain data integrity across all operations. Security requirements include user authentication, data encryption, and audit trail capabilities. The architecture must be modular to support future enhancements while maintaining simplicity for current operations. Performance requirements specify response times under 2 seconds for all operations and support for up to 10,000 product records without performance degradation.

   2. Technology Stack Selection

      The system utilizes a modern web-based architecture built on open-source technologies to minimize costs and ensure accessibility. PHP serves as the server-side scripting language, providing robust backend functionality and database connectivity. MySQL provides relational database management with ACID compliance and efficient query processing HTML5 and CSS3 serve as the foundation for sleek, responsive web interfaces, delivering consistent design and layout across various screen sizes and browsers. JavaScript brings interactivity to life, powering dynamic features and handling client-side input validation to enhance user experience. On the server end, the Apache web server delivers dependable hosting with integrated security mechanisms to safeguard applications. XAMPP facilitates local development and testing environments. This technology stack was selected for its widespread adoption, extensive documentation, low learning curve, and minimal licensing costs, makng it ideal for SME environments with limited IT resources.

   3. Database Design

      The database schema employs a normalized relational design optimized for product lifecycle management operations. The core tables include Products (master product information), Batches (batch- specific data and expiry tracking), Suppliers (vendor management), Reports (generated report metadata), and Users (authentication and authorization). The Products table stores essential product information including name, SKU, description, and regulatory data. The Batches table maintains manufacturing dates, expiry dates, quantities, and storage locations. Foreign key relationships ensure data integrity and enable efficient queries across related entities. Indexes help speed up data searches by making it easier to find information that's used often. They improve how quickly queries run, especially for frequently accessed data. .The schema supports extensibility through additional tables for features like categories, locations, and audit trails. Data validation rules ensure consistency and prevent invalid entries, while backup and recovery procedures protect against data loss.

4. IMPLEMENTATION

   1. Development Methodology

      The system development followed an agile methodology with iterative development cycles and continuous stakeholder feedback. The development process began with requirement gathering through stakeholder interviews and surveys, followed by system design and architecture definition. Implementation proceeded through three-week sprints with regular demonstrations and feedback sessions. Test-driven development practices ensured code quality and reliability. Version control using Git facilitated collaborative development and change tracking. The development team consisted of two developers, one database administrator, and one user experience designer.. User acceptance testing was conducted at the end of each sprint to validate functionality and gather feedback for subsequent iterations

   2. Frontend Development

      The frontend development utilized responsive web design principles to ensure optimal user experience across devices. HTML5 semantic markup provides accessibility and SEO benefits while maintaining clean, maintainable code structure. JavaScript event handling enables interactive features such as form validation, dynamic content loading, and real-time updates. The user interface follows material design principles with consistent color schemes, typography, and spacing. Navigation components include a persistent navigation bar, breadcrumb trails, and contextual menus. Form design emphasizes usability with clear labels, helpful error messages, and logical field grouping. AJAX implementation provides seamless user interactions without page reloads.

   3. Backend Development

      Backend development focused on creating robust, secure, and scalable server-side functionality. PHP object-oriented programming practices ensure maintainable and extensible code architecture. Database abstraction layers provide secure database connectivity and prevent SQL injection attacks. Session management handles user authentication and authorization with role-based access control. Input validation and sanitization protect against common security vulnerabilities. Error handling provides informative feedback while maintaining system security. API endpoints enable future integration with external systems and mobile applications. Caching mechanisms optimize database query performance and reduce server load. Logging functionality tracks system usage and facilitates debugging and performance monitoring.

      Product Management Module

      In the Product Management module, users start at A2 by entering product details (name, price, quantity, manufacture date, expiry date). They proceed to A3 to add the product. Information flows to A1 (HOME), the main dashboard showing total products, inventory value, and categories. Users can navigate to A4 for expiry product details highlighting valid and expired items.

      Administration Module

      The Administration module centers at A5 (PRODUCT ADMIN), where administrators manage product operations and system configurations. From this hub, they access reporting capabilities across three time-based categories.

      Reporting Module

      The Reporting module at A5 provides analytics through three sub-modules: A5a generates Daily Reports with expire alerts and activity summaries; A5b creates Monthly Reports showing addition trends and category growth; A5c produces Yearly Reports with overall statistics and category performance for strategic planning.

5. SYSTEM FEATURES AND

   FUNCTIONALITY

   1. Product Management Module

      The product management module provides comprehensive functionality for managing product information throughout the lifecycle. Users can create, edit, and delete product records with detailed information including name, SKU, description, category, and regulatory data. The system supports batch management with individual tracking of manufacturing dates, expiry dates, quantities, and storage locations. Search and filtering capabilities enable quick product location and status verification. Bulk operations allow efficient management of multiple products simultaneously. The module incorporates validation rules to maintain data accuracy, consistency, and integrity throughout the system.. Integration with the expiry alert system provides real-time monitoring of product status. Audit trails track all changes to product information for regulatory compliance. The user interface provides intuitive forms with clear field labels and helpful guidance. Export functionality facilitates seamless data exchange with external systems and ensures compliance by enabling reporting to regulatory authorities.

   2. Expiry Alert System

      The expiry alert system provides proactive monitoring and notification capabilities for product expiry management. Configurable alert thresholds allow customization based on product types and business requirements. The system generates automatic notifications for products approaching expiry dates through email and dashboard alerts. Batch-level tracking enables precise expiry management for products with multiple manufacturing dates. The alert system includes escalation procedures for overdue actions and management notifications. Integration with the reporting system provides comprehensive expiry tracking reports for regulatory compliance. Users can customize alert preferences and notification methods based on their roles and responsibilities. The system maintains historical records of expiry events and actions taken for audit purposes.

   3. Reporting and Analytics

      The reporting system provides comprehensive analytical capabilities for operational and regulatory reporting

      requirements. Daily operational reports include current inventory levels, expiry alerts, and production planning information. Monthly summary reports provide management insights into stock turnover, waste reduction, and operational efficiency. Yearly compliance reports compile comprehensive product histories for regulatory audits and certifications. The system supports multiple output formats including PDF, Excel, and CSV for various stakeholder needs. Interactive dashboards provide real-time visibility into key performance indicators and system metrics. Customizable report templates accommodate different industry requirements and organizational preferences. Scheduled report generation automates routine reporting tasks and ensures timely information delivery. Data visualization components include charts, graphs, and trend analysis for enhanced decision- making. The reporting engine optimizes database queries for fast report generation even with large datasets.

6. TESTING AND VALIDATION

   1. Testing Methodology

      Extensive testing was performed to validate the systems reliability, security, and performance under various conditions.Unit testing validated individual components and functions with 90% code coverage achieved through automated testing frameworks. Integration testing verified proper interaction between system modules and database operations. To validate the systems usability and performance, 20 subject matter experts conducted user acceptance testing. Performance testing measured system response times under various load conditions with up to 100 concurrent users. Security testing encompassed penetration testing, vulnerability assessments, and authentication verification to safeguard the system against potential threats. Cross-browser testing was performed to ensure the system functioned consistently across major browsers, including Chrome, Firefox, Safari, and Edge. This helped confirm a seamless user experience regardless of the browser used.. Mobile responsiveness testing validated functionality on tablets and smartphones. Database stress testing verified system performance with large datasets and concurrent transactions. All testing phases included documentation of test cases, results, and remediation actions.

   2. Performance Results

      The system underwent thorough testing to ensure it was reliable, secure, and performed efficiently. Each key function was evaluated to detect issues early and confirm stable operation under various conditions.. Unit testing validated individual components and functions with 90% code coverage achieved through automated testing frameworks. Integration testing verified proper interaction between system modules and database operations. User acceptance testing was conducted with 20 subject matter experts (SMEs) who assessed the systems functionality and usability. Performance testing measured system response times under various load conditions with up to 100 concurrent users. Security testing encompassed penetration testing, vulnerability assessments, and authentication verification to ensure robust protection against threats. Additionally, cross- browser testing was performed to confirm consistent functionality and appearance across Chrome, Firefox, Safari,

      and Edge. Mobile responsiveness testing validated functionality on tablets and smartphones. Database stress testing verified system performance with large datasets and concurrent transactions. All testing phases included documentation of test cases, results, and remediation actions.

   3. User Acceptance Results

   User acceptance testing achieved exceptional satisfaction rates across all evaluation criteria. Ease of use received 92% positive feedback, with users praising the intuitive interface and logical workflow design. Functionality completeness scored 88% satisfaction, with users confirming that the system addressed their core PLM requirements. Performance ratings reached 95% satisfaction, with users appreciating the fast response times and reliable operation. Training requirements were minimal, with users achieving proficiency within 2 hours of initial system exposure. Error rates during testing were below 1%, indicating robust input validation and user interface design. Users reported that the system would reduce their current manual tracking time by 75% while improving data accuracy. The integrated expiry alert system received unanimous approval for its proactive notification capabilities. Overall system acceptance rate reached 94%, with users expressing strong interest in implementation within their organizations.

7. RESULTS AND ANALYSIS

   1. Cost-Benefit Analysis

      Comprehensive cost analysis revealed significant advantages over existing enterprise PLM solutions. Implementation costs totaled $2,500 for a typical 50-user SME deployment, representing 95% savings compared to enterprise alternatives averaging $50,000. Training costs were reduced by 80% due to the intuitive interface design and minimal learning curve. Ongoing maintenance costs averaged $500 annually, compared to $10,000 for enterprise licensing and support. The systems open-source foundation mitigates vendor lock-in and avoids escalating licensing costs, offering greater flexibility and long-term sustainability. Total cost of ownership over five years averaged $5,000 compared to

      $150,000 for enterprise solutions. Productivity gains from automated expiry tracking and streamlined reporting generated estimated savings of $15,000 annually for typical SME operations. The rapid implementation timeline of 2-4 weeks compared to 6-18 months for enterprise systems enabled immediate return on investment. These cost advantages make PLM functionality accessible to organizations previously unable to afford comprehensive product lifecycle management.

   2. Comparison with Existing Systems

      Comparative analysis with existing PLM solutions highlighted significant advantages in accessibility, cost- effectiveness, and user experience. Unlike enterprise systems requiring dedicated IT staff, the web-based architecture enables operation with minimal technical support. The focused feature set addresses

      core SME requirements without unnecessary complexity found in enterprise solutions. Implementation simplicity contrasts sharply with enterprise systems requiring extensive customization and integration efforts. User training requirements are drastically reduced compared to complex enterprise interfaces. The integrated expiry alert system provides functionality typically requiring separate software licenses in enterprise environments. Performance characteristics match or exceed enterprise solutions while utilizing standard web technologies. Customization capabilities enable adaptation to specific industry requirements without expensive consulting services. The system's modular architecture supports future enhancements while maintaining operational simplicity.

   3. Limitations and Future Enhancements

   Current system limitations include single-tenant architecture limiting multi-organizational deployment and basic reporting capabilities compared to advanced enterprise analytics. Mobile access is limited to responsive web design rather than native mobile applications. Integration capabilities are constrained to standard web APIs without specialized enterprise system connectors. Advanced features such as predictive analytics, machine learning, and IoT integration are not currently implemented. Future enhancements will address these limitations through multi-tenant architecture development, native mobile applications, and advanced analytics capabilities. Planned features include barcode scanning integration, automated data import from external systems, and blockchain-based traceability. Machine learning algorithms will enable predictive expiry analysis and inventory optimization. API development will facilitate integration with popular business applications and e- commerce platforms. Cloud deployment options will provide scalable hosting alternatives for organizations preferring managed services.

8. DISCUSSION

1. Practical Implications

   The research demonstrates that simplified PLM systems can effectively serve SME requirements while providing substantial operational benefits. The cost-effective approach makes PLM functionality accessible to organizations traditionally underserved by enterprise solutions. Implementation simplicity enables rapid deployment without disrupting existing business operations. The integrated expiry alert system addresses critical regulatory compliance requirements while reducing product waste and financial losses. User satisfaction results indicate strong acceptance of focused functionality over comprehensive feature sets. The system's success validates the approach of developing industry-specific solutions rather than attempting to replicate enterprise system complexity. SME can achieve significant productivity improvements through targeted technology adoption without requiring extensive IT infrastructure investments.

2. Industry Impact

   The research contributes to the broader discussion of appropriate technology solutions for different organizational scales. The success of the simplified PLM approach challenges the assumption that comprehensive enterprise systems are

   necessary for effective product lifecycle management. The integrated expiry alert functionality demonstrates the value of combining related business functions in unified systems. The cost-effectiveness achieved through open-source technology adoption provides a model for similar system development initiatives. The research highlights the importance of user- centered design in developing accessible business applications. The positive user acceptance results demonstrate that SMEs can successfully adopt modern web-based business systems when designed appropriately for their environments.

3. Academic Contributions

   This research contributes to the PLM literature by demonstrating effective approaches for developing SME- focused solutions. The formative research methodology provides insights into SME requirements and design preferences that can inform future system development. The integration of expiry management with PLM functionality represents a novel approach to addressing related business needs. The cost-benefit analysis provides quantitative evidence of the advantages of simplified system architectures. The user acceptance testing methodology and results contribute to understanding factors affecting SME technology adoption. The research validates the effectiveness of web- based architectures for business-critical applications in resource-constrained environments. The findings support the development of focused, industry-specific solutions rather than generic enterprise applications.

   1. Conclusion

This research successfully demonstrates that simplified, web- based PLM systems can effectively address SME requirements while providing substantial cost and usability advantages over enterprise solutions. The proposed system combines essential product lifecycle management functionality with integrated expiry alert capabilities, creating a focused solution that addresses critical business needs without unnecessary complexity. Formative research involving 45 SME representatives validated the appro ach and informed design decisions that resulted in high user satisfaction rates. Performance testing confirmed the system's reliability and responsiveness under realistic operating conditions. Cost analysis revealed 95% savings compared to enterprise alternatives, making PLM functionality accessible to organizations previously unable to afford comprehensive product lifecycle management. The research contributes to the PLM field by demonstrating effective approaches for developing industry-specific solutions and validating the benefits of user-centered design in business application development. Future work will focus on expanding system capabilities through mobile applications, advanced analytics, and integration features while maintaining the core advantages of simplicity and affordability.

REFERENCES

1. S. Terzi, A. Bouras, D. Dutta, M. Garetti, and D. Kiritsis, "Product lifecycle management from its history to its new role," International Journal of Product Lifecycle Management, vol. 4, no. 4, pp. 360-389, 2010.

2. J. Stark, "Product Lifecycle Management: 21st Century Paradigm for Product Realisation," 3rd ed., Springer, 2015.

[3]M. Grieves, "Product Lifecycle Management: The New Paradigm for Enterprises," International Journal of Product Development, vol. 2, no. 1-2, pp. 71-84, 2005.

[4]A. Bernard and A. Tichkiewitch, "Methods and Tools for Effective Knowledge Life-Cycle-Management," Springer Science & Business Media, 2008.

[5]F. Ameri and D. Dutta, "Product lifecycle management: closing the knowledge loops," Computer-Aided Design and Applications, vol. 2, no. 5, pp. 577-590, 2005.

[6]J. Le Duigou, A. Bernard, N. Perry, and J.-C. Delplace, "Generic PLM system for SMEs: Application to an equipment manufacturer," International Journal of Product Lifecycle Management, vol. 6, no. 1, pp. 51-64, 2012.

[7]M. Cantamessa, F. Montagna, and P. Neirotti, "Understanding the organizational impact of PLM systems: evidence from an aerospace company," International Journal of Operations & Production Management, vol. 32, no. 2, pp. 191-215, 2012.

[8]R. Sudarsan et al., "A product information modeling framework for product lifecycle management," Computer- Aided Design, vol. 37, no. 13, pp. 1399-1411, 2005.

[9]D. Kiritsis, "Closed-loop PLM for intelligent products in the era of the Internet of things," Computer- Aided Design, vol. 43, no. 5, pp. 479-501, 2011.

[10]K. Sääksvuori and A. Immonen, "Product Lifecycle Management," 3rd ed., Springer, 2008.

[11]P. Zheng, T.-J. Lin, C.-H. Chen, and X. Xu, "A systematic design approach for service innovation of smart product- service systems," Journal of Cleaner Production, vol. 201, pp. 657-667, 2018.

[12]S. Liu, S. K. Boyle, and A. Krishnamurthy, "PLM implementation in small and medium enterprises: A systematic review," International Journal of Production Research, vol. 56, no. 15, pp. 5158-5204, 2018.

[13]H. Wang, J. Johnson, and R. Smith, "Web-based product lifecycle management systems: A comparative study," IEEE Transactions on Engineering Management, vol. 66, no. 3, pp. 425-437, 2019.

[14]M. Zhang, L. Chen, and P. Wang, "Expiry date management in supply chain: A systematic approach," International Journal of Production Economics, vol. 195, pp. 317-329, 2018.

[15]J. Anderson, K. Miller, and S. Davis, "Cost-effective PLM solutions for small manufacturing enterprises," Journal of Manufacturing Systems, vol. 45, pp. 278-289, 2017.