traditional momento magento e-commerce platform with quick book integration

www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd

of 4

Case Study

Traditional Momento Magento E-commerce Platform with Quick Book Integration


of 4

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.

Client Requirement

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.


of 4

Technologies Used

Manpower

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.

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.0.2, 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


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.

traditional momento magento e-commerce platform with quick book integration

Technology