ViviApp - https://viviapp.ch
A web application seamlessly combines CRM and Inventory control for a beverage manufacturing company, offering exclusive access to authenticated users.
Viviapp and what is unique about it?
A fully responsive app ensures ease of use for both sales and production teams, featuring real-time inventory and sales data through interactive graphs and clickable customer details for convenient navigation and direct calls.
Viviapp is a web-based application tailored for a Zurich-based Beverage/Drink manufacturing company, seamlessly merging CRM and Inventory control. Exclusively accessible to authenticated users, it offers complete responsiveness, ensuring user-friendly operation for both the Sales team and Production team.
Real-time inventory and sales data are elegantly presented through interactive graphs and charts, while clickable customer details simplify navigation and facilitate direct calls.
Real-time inventory and sales data are elegantly presented through interactive graphs and charts, while clickable customer details simplify navigation and facilitate direct calls.
TECHNICAL CHALLENGES AND SOLUTIONS
Technology Stack
Technology Stack: CakePHP, Jquery, JavaScript.PHP, MySQL, AWS
AWS – Cloud
CakePHP – Backend
MySQL Database
Graphical Integration Challenge and Solution
Faced with a unique challenge, we aimed to combine the Ordered Raw Materials vs. Planned Consumption graph and Incoming Raw Material vs. Planned Consumption calculation into a single graph. Through strategic brainstorming, we leveraged the prior year’s production data for forecasting and divided the visualization into two focused graphs: “Ordered Raw Material Vs. Planned Consumption” and “Incoming Raw Material Vs. Planned Consumption.” This innovative approach enhanced data representation.
Overcoming CSV Export Timeout Challenge
In response to a pressing challenge, the Sales team required a Contact report with export functionality, yet implementing the export CSV feature encountered a timeout error due to the abundance of selected records, exceeding 1000. In finding a solution, we harnessed the power of Ajax technology by deploying multiple requests along with a loader symbol. This strategic move not only resolved the issue but also empowered users to seamlessly view the file and its exported content, ensuring a smooth export process for all records.
Other Technologies
- 1 AWS for the Cloud Managment
- 2 JQuery for Frontend
- 3 CakePHP for the Backend Administration and Dashboard.
Overcoming XML Export Challenges for Abacus CRM Integration
When integrating Abacus with the CRM via XML export, we encountered two hurdles. A timeout issue with 1000+ data entries and problems exporting German characters. To tackle these challenges, we utilized Ajax calls for handling the large dataset and implemented customized functions to ensure the accurate export of German characters.
Transitioning from Horizontal to Vertical Menu Theme
Faced with the challenge of transforming a horizontal menu-based theme into a responsive vertical menu theme, we embarked on a comprehensive solution. This transformation entailed a complete overhaul, involving the modification of nearly 300 CSS and JavaScript files to align with the new vertical menu theme. To achieve this, we worked on separate template files, adjusted the graphical structure for both the main and production dashboards, fine-tuned the sidebar menu to reflect user permissions, and ensured responsive alignment across all interfaces.
SS4U’s customized CRM and ERP solutions have become the foundation of our Operations and Sales teams, greatly improving our processes. The Sales Team can now efficiently track, follow up on the right leads, and successfully close profitable deals. Furthermore, SS4U’s unwavering availability and prompt technical support have made them a trusted and reliable partner in our business operations.
Camilo Antezana
CEO at Vivi Kola AG
