JIWA 7 Case Studies
The WebCo’s client, a distributor of computer products, approached The WebCo to partner with them on an ecommerce website, aimed at enhancing their product inventory management. To achieve this we integrated their website with Jiwa 7.
Challenges
- Ensure the website loading time is optimaised and product information is displayed accurately.
- As our client is constantly changing their product attributes such as price or stock levels. It is important when a customer uses the website, the products’ attributes are always up-to-date. We need to ensure the data displayed in the web application uses real-time data.
- The website and Jiwa 7 are sitting on two different servers so it was possible to experience latency issue when the website attempted to retrieve product attributes. This is the especially the case when a customer is viewing the product listing page when there are more than 200 hundred products that need to be loaded all at once. We also faced the some challenge of latency when a customer is performing a product search.
Approach
Data Integration
To ensure the product attributes such as price and stock levels are accurate when loading the website. We implemented custom code to connect with the Jiwa 7 database and retrieve the necessary information from the database directly.
To improve the response time when a user opens the product listing page, we implemented lazy loading. This means that the website only retrieves the data which is going to display, rather than loading all products when the customer requests the page.
When performing a product search, we worked with the Jiwa 7 team to implement an SQL procedure. This was so we only retrieved the necessary data from the database, rather than retrieve all the product’s attributes which would slow down the process.
Outcome
- The data retrieved from the Jiwa 7 database is always valid as we are retrieving data directly from the source database.
- We managed to reduce the response time significantly when a customer opened the product listing page and performed a product search.
Conclusion
In conclusion, The WebCo successfully addressed the challenges posed by our clients request for an ecommerce website integrated with Jiwa 7 inventory management.
- Through direct database connections and the implementation of lazy loading techniques, we achieved notable improvements in website loading times and response rates, particularly on high-traffic pages such as product listings and search functionalities.
- Our collaboration with the Jiwa 7 team resulted in the development of an efficient SQL procedure, streamlining the retrieval of necessary data and minimising unnecessary delays.
Overall, our approach not only met but exceeded the client’s expectations, delivering an ecommerce platform that enhances user experience while seamlessly integrating with their existing inventory management system. The successful partnership between The WebCo and and our client demonstrates our commitment to innovation and client satisfaction, laying the foundation for continued growth and success in the digital marketplace.