Goals
This site is an online store for wholesale and retail sales of auto parts of Mitsubishi, Subaru, Mazda brands.
A key feature of the store is the internal CRM-system for order management and customer service. The site is an aggregator of several wholesale suppliers’ parts catalogs.
The process of selling parts is fully automated in the system, starting from ordering items in the online store; to its delivery to customers from a warehouse or distribution all over Ukraine via express mail.
The site also provides a flexible system of discounts for working with customers and with items suppliers. Discounts are available for groups of customers (wholesale, retail, club customers) and personally (VIP-clients). For suppliers, there are different levels of margins on sold items.
The store manager has an opportunity to log in under the profile of the client from the admin area and manage orders on behalf of clients, that is most convenient for telephone sales and work with regular clients.
The process of selling the items is following: client searches for details on the site by a unique number of these items from the vehicle manufacturer's catalog. Moreover, the same item can be presented in several different variants and at different prices (depending on the vendor and the time of delivery). The client then selects a suitable option and pays the required percentage of prepaid (if it is a regular client, the required amount is "frozen" on his account). The order gets to the consolidated daily order by the selected supplier. Order status (order received, packaged, shipped, delivered) is displayed in the internal system and store in a client’s private office. The client can pick the order up from the warehouse, or pay for it and order the delivery.
Store warehouse and its completion are implemented especially interesting. Warehouse system is the same client (VIP, of course) as well as others. Warehouse replenishment works by ordering items from third-party suppliers on behalf of the client “Warehouse”, and the order automatically appears on the store warehouse (with an appropriate markup).
Solution
- as the basis of the system was taken CodeIgniter 1.6 framework
- for convenient work with tables in the browser in the admin panel JqGrid - jQuery Grid Plugin is used.
- during development, many kinds of parsers have been implemented - XLS, XML, HTML (for online vendors).
- automatic parsing of incoming emails to processing items orders by email.
Team
Development was carried out by a team of 3 people:
- Team Leader (coordination of project details, distribution and control of tasks);
- 2 programmers (development).
Duration
Development was actively conducted during 4 months. The project has been successfully implemented in time.
