Goal
Build a fully automated platform enabling real-time drink kiosk management with intelligent product synchronization, live inventory tracking across multiple locations, and seamless integration of kiosk data into the website.
Scope of Work
This project included a custom Joomla platform development, template design, custom component development, API integration, OpenAI integration, CSV data processing, cron job automation, and frontend visualization.
Key Challenges
- Designing a robust API sync system for continuous product updates across multiple kiosk locations
- Handling data mismatch between API products and physical drink kiosk records
- Processing large CSV datasets generated from kiosks reliably
- Mapping physical kiosk slots to digital UI representation accurately
- Building a scalable architecture to support multiple kiosk locations with real-time data
- Creating an intuitive frontend that clearly shows users which drink is available in which kiosk and in what quantity
Work Done
- Developed a custom Joomla platform to manage all core functionalities
- Built frontend using a third-party template with a fully customized UI
- Developed a custom API integration component with cron automation for continuous data sync
- Integrated OpenAI API for intelligent drink-product mapping
- Built PHP scripts to export kiosk data into structured CSV files
- Implemented cron-based CSV import system into the main database
- Created a dynamic frontend UI showing real kiosk layout with live drink availability
- Conducted deep testing for synchronization accuracy and performance
Result
A fully automated, AI-driven kiosk management platform that gives users real-time visibility into drink availability across multiple locations, with intelligent product mapping and seamless data synchronization.
