Categories : All, Case Study, Healthcare, Retail / E-commerce
The client is running 30 Magento stores and sell fitness related products across various
locations in USA. The client already had an existing Magento based website and took the decision to revamp their site in order to achieve their goals of rapid time to market, increased customer engagement and higer conversion rates.
The client was struggling with an out-dated inventory system and wanted us to provide a centralized inventory management system enabling easy and immediate access to all the stocks levels in one place. Also, we incorporated Magento’s advanced features for easy management of multiple websites and stores. The Magento based Multi-Store development enabled the client to sell a wide range of products in different categories and that too in an easy and efficient manner. This fitness and healthcare product selling portal will not only enhance the customer’s shopping experience but will also increase the customer base bringing the same customers back to the website again and again.
|Operating System & Server Management||Red Hat Linux OS, Multi-Server Architecture with Staging & Production Environment through Version Controlling releases, Server Optimization, Security & SSL Implementation, Scheduler for Back-ups, Alert Monitoring System Integration, Server Performance Tuning at regular intervals, Software Firewall Configuration & Maintenance|
|Database||MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups|
|Quality Assurance Testers||1|
PHP and MYSQL Server formed the basis of development as the site was rich with user data and featured extensive capabilities for multi-store management. The other modules were developed in PHP such that they can be executed directly from the UI layer. These PHP files consisted of all the business logics used for respective modules like Save (Add/Update), Delete, Get Single Object, Get Multiple Objects for Listing and were designed to be capable of handling many more logics which were not related to the database.
The Data Access layer contained the libraries responsible for accessing data from the database and built a generic query for insert, update, delete and select depending on the business class. All business layer components were coded to use this library for data accessing process from database. Stored procedures were used only for complex retrieval of data from multiple tables and were entirely avoided with conditional syntax to ensure smooth performance of the website. The UI layer was kept free of any business logic with images, applications and data being called from their respective servers.
The system managed the entire gamut of online shopping right from product mangement, order management, catalog management, shipping, payments etc. Extensive pre-development research was carried out and requirements were assessed to deliver a unique solution that enables the best performance of their online stores. The robust solution was developed in minimum time with extensive customizations. The web usability principles were strictly followed during development and the interface was made easily navigable through judicious use of AJAX, CSS and HTML controls. The site was developed and fully functional within a span of 6 months.