Case Study Traditional Momento Magento E-commerce Platform with Quick Book Integration
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 1 of 4
Client
Requirement
The key requirement of this project is a Magento Community Edition powered online retail store that will feature the “N” number of different products based on the quantity and product specification. The client wished to develop an ecommerce store to showcase the traditional items/products where the customers will be able to buy online and can pay for items in their ecommerce shopping cart using online transaction mode. Implementation of complex pricing methods, easy navigation, good graphics, product images, multiple payment options etc. were successfully developed in order to make the online shopping fun, fast and easy. At a Glance Product Description & Search My Account Section My Wish List Shopping Cart Facility Blog & Newsletter
o
The customers can create accounts in this store easily to shop continuously. With this online store, the customers will be able to move through the checkout process faster and they will be able to track their orders too. Customers can also sign up for newsletter from their login account. This user-friendly shopping cart enables users to purchase products instantly offering superior search capabilities and the flexibility catered to the customer’s and their specific buying habits.
Project
Challenges
The team faced the following challenges:
Allowing the site to handle millions of users at the same time without reduction in performance.
Quick Book Integration with Magento for secure online accounting came as a challenge to the team.
Syncing price and quantity between the Magento store and Quick Book Web Based Accounting Platform.
Harmonizing the simultaneous execution of various integrated features and options while maintaining consistency.
Incorporating web usability principles in the website design to ensure easy navigation for all types of users.
Ensuring safe and secure transfer of data.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 2 of 4
Technologies Operating System & Server Management
Development Tools & Environments
Used 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 PHP5+, Magento Community Edition 1.7.0.2, AJAX, Java Script, HTML5, CSS3 etc. MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups
Database
Manpower 1 Project Leader 2 Developers 1 Designers 1 Quality Assurance Testers
Planning 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 My Account, My Wish List, Check Out, Login, Blogs etc.
The User Interface layer which forms the Graphical User Interface of the website.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 3 of 4
Architecture It was a customized web-based application. We studied and analyzed the requirement and developed an online shopping cart to manage unlimited products, different pricing options, quick search functionality etc. providing the full-featured Magento based ecommerce solution including payment gateway as well. PHP and MYSQL Server formed the basis of development. Various 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 main objective of the project was to launch a customized Magento online store with custom design and modules. The purpose is to develop a full-featured ecommerce online store where customers can buy products online and get it delivered at their place. Customizable viewing options were designed to enhance user experience and allow for extensive personalization of the site. 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 4 months.
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 4 of 4