Categories : Advertising, All, Case Study, Digital marketing, Retail / E-commerce
Client is a reputed home fabric dealer in the United States dedicated to offer thousands of brands of rugs at the lowest prices. The aim was to make the business more accessible to their customers by creating an online presence and providing customers with a great online shopping experience with the convenience of placing orders and getting the products delivered at their door step.
Client also requested that the website visibility and popularity be increased by internet marketing and other SEO techniques. Social media marketing to be included to spread the word.
|Operating System & Server Management||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+, Microsoft Visio, Zend Studio, SVN, WordPress CMS, AJAX, Java Script, HTML5, CSS3 etc.|
|Database||MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization,Scheduler for Backups|
MySQL Server Database, Tables, Stored Procedures etc… incorporated within the database layer.
PHP and MYSQL Server formed the basis of development as the site was rich with user data and featured extensive capabilities for online shopping. Shipping Management, Order Management, Inventory Management etc. 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 Magento ecommerce website for selling home fabrics was successfully built with a plethora of online activities successfully handling all the orders, shipping, payments amongst others. Extensive pre-development research was carried out to create a robust application in minimum time while dealing with extensive customizations. 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.