Customer: European Engineering Company Industry: Automotive Solution Type: Web Application (MS Commerce Server 2007 based system) Technologies: .NET, MS CS2007, Web Services use and development, MS SQL Server 2007, MS Visual Studio 2008, MS TFS, AJAX MS ATLAS, XML, XSD, XSLT, DHTML, ADO.NET, IIS, Scrum development, MS Visio, Enterprise Architecture Tool, UML

Customer is the world-leading supplier of engines and complete power systems for marine and industrial applications. Eclipse SP was requested to deliver a software system that will allow ordering vehicle parts and their distribution from centre to service representatives, also including advanced features for marketing purposes. The best solution for this purpose is MS Commerce Server based system, which introduces all needed possibilities.

Project goal was to develop a comprehensive electronic vehicle part catalogue with such features: it should be integrated in Enterprise Environment, allow ordering products via multi-level distribution channels with implementation of complex pricing, provide the possibilities of discounting and shipment cost calculation models using only the tools and technologies available in MS Commerce Server. The main challenge was to build branched-structure solution that would fit Customers global marketing & distribution needs, providing users with easy approach for making site updates and file-tuning.

Result: Developed solution forwards the order data in appropriate format from service representative to the distribution center closest to the location of the order placement district. The application is based on Microsoft Commerce Server and uses MS SQL as database. Now Order Service is used in Customer’s distribution centers and greatly streamlines the vehicle parts ordering process. Main features are:

• More than 120 000 parts in catalog, 15 markets and corresponding prices for each catalog part;
• More than 60 centers and 10 000 discount expressions;
• More than 150 services;
• Fast net prices calculation, fast delivery costs calculation, fast weight and prices totals calculations (less than a second for basket with 500 items);
• Fast text and part id search in catalog with 150 000 parts (less than 3 sec);
• Support of languages and currencies for each market;
• Flexible CS2007 customization.

Request more information