Centralized Inventory System woodfordtooling

Categories : All, Retail / E-commerce

Client Requirement


The client demanded a Centralized Inventory System for managing the inventory, keeping
track of orders and handling the various steps between the time an order is received and goes
out of the door. The system is especially dealing with inventory that appears in many places
and is constantly going in and out of stock.

The Magento based centralized inventory system is built for online retailers and sellers to
manage their inventory. The M2E Pro Magento extension was used which pulls all orders into a
central inventory system and syncs quantities of items with major marketplaces including eBay, Amazon etc. The most important feature of the extension is the ability to import eBay Transactions and to create Magento Orders and as far as order management, the extension treats eBay originated orders as regular Magento orders.

The system also keeps track of both what’s available in your online store as well as what you
have in your warehouse. The system also provides a deep insight into the movement history of
your inventory letting you know which items are selling the quickest and providing insight into
the profitability.

CIS is packed with features that make it easy to:
  • Keep your inventory in sync across Magento, eBay, Amazon etc.
  • Manage bills of materials and items
  • Centrally track orders and order notes
  • Centrally manage your inventory keeping track of the warehouse as well as the orders placed and store quantities
  • Get insight into inventory movement and history

Project Challenges

The team faced the following challenges:
  • Allowing the site to handle millions of users at the same time without reduction in performance.
  • Syncing of data and managed elements automatically between the inventory system and various market places.
  • Huge volume of centralized data management while keeping the site stable.
  • Improving the integrity and usability of order management to ensure end-to-end supply chain efficiency.
  • Aligning inventory with maintenance operations.
  • 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, AJAX, Java Script,
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 User Interface layer which forms the Graphical User Interface of the website.
  • The Business Logic layer consisting of all the business logic procedures for modules like My Account, My Cart, Check Out, Login, Blogs etc.


PHP and MYSQL Server formed the basis of development as the site was rich with user data and featured extensive capabilities for online advertising management. Order Management, inventory management and 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 centralized inventory management activities successfully handling all the orders, stocks, bills amongst others. Customizable viewing options were designed to enhance user experience and allow for extensive personalization of the site. Extensive pre-development research was carried out to create a robust application in minimum time while dealing with extensive customizations. SEO activities performed ensured high visibility for the site over the internet. Web usability guidelines 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: 1    Average: 1/5]

Client Saying

If you're starting a new business or want to upgrade an existing site, I strongly recommend Brainvire. The employees are...
Mr. Manjesh Singh
I just want to say it's truly worth investing in services of Brainvire. They gave me what I required and...
Mr. Vinay Saini
Chad Gundry, the CEO of Bragshare.com says that he has worked extensively with Brainvire team since last 6 to 7...
Mr. Chad Gundry
I am truly happy with Brainvire’s exceptional service. Whenever I had a question they answered it without delay. With extreme...
Mr. Richard Desilva
We have dealt with a lot of web development firms and other tech support companies, none come close to Brainvire....
Mr. Matthew

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 [ + ]