Multi-Store & Centralized Inventory System For Fitness And Health-Care Products

Categories : All, Case Study, Healthcare, Retail / E-commerce

Client Requirement


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.

Some of the key requirements that client expected were:
  • Multi-site management and user friendly designs
  • Call center integration with Magento
  • Speed and image optimization along with new enhancements to create a personalized shopping experience for users
  • Trimming of some of the existing features to make it more simple to use yet retaining the efficiency
  • Incorporation of various customizations and extensions such as WordPress Integration, ROI Tracker, M2E PRO, Social Networking, Feature Product, Zoom Extension, Banner Slider, Pre-Order and Custom Carrier Tracker to Magento’s already robust core functionality
  • Bespoke Magento optimized solution increasing customer interaction and engagement
  • Magento consulting – to improve overall sales and profitability of the store

Project Challenges

The team faced the following challenges:
  • Allowing the site to handle good amount of users at the same time without reduction in performance.
  • Incorporating web usability principles in the website design to ensure easy navigation for all types of users.
  • Data synchronization for varied products on regular basis.
  • Ensuring safe and secure transfer of data.

Technologies Used

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
Development Tools & Environments PHP5+, Magento Community Edition 1.7.02, AJAX, JavaScript, HTML5, CSS3 etc.
Database MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups


Project Leader 1
Developers 2
Designers 1
Quality Assurance Testers 1


Keeping in mind the enormous structure of the website and the challenges involved a four-tier development approach was adopted consisting of:
  • The Database layer containing MYSQL Server Database, Tables, Stored Procedures and so on.
  • The Data Access layer containing the libraries responsible for accessing data from the database.
  • The Business Logic layer consisting of all the business logic procedures for modules like Shipping, Payment Gateway, Check out etc.
  • The User Interface layer which forms the Graphical User Interface of the website.


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.

Development Highlights

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.

[Total: 0    Average: 0/5]

Client Saying

I am truly happy with Brainvire’s exceptional service. Whenever I had a question they answered it without delay. With extreme...
Mr. Richard Desilva
BIG THANK YOU to Brainvire team for all their smart work and fantastic services. We are very pleased with the...
Mr. Greg Pietsch
If you're starting a new business or want to upgrade an existing site, I strongly recommend Brainvire. The employees are...
Mr. Manjesh Singh
Just wanted to say massive thanks for all the help from the Brainvire team. After years of having a website...
Mr. Rohit Singla
Daniel Coburn, the president of gives the honest opinion regarding his experience working with Brainvire for developing his social...
Mr. Daniel Coburn

Latest Happenings

  • 04 Oct 2016
    Brainvire Making great Strides with Symfony Development Services [ + ]
  • 29 Sep 2016
    Brainvire augments its List of Offerings with Magento Sears Integration Services [ + ]