Auto Glass Tools Manufacturer

Objective:

Client is in the business of Auto Glass parts and tools and was looking for a complete eCommerce solution for their product line. In addition, client is a preferred vendor for Safelite. Safelite uses Oracle iProcurement for order processing software for its purchases. Apart from Safelite, client deals with different types of web customers. Client also uses Microsoft Dynamics GreatPlains for the purpose of sales and inventory management. The website had to be in sync with client’s MSGP. Client approached Tochstone for development of the web application to take care of online shopping catalogue, order management, user management and data synchronization with web site database and MSGP. This application would make the client’s sales team more efficient. It would also provide various other tools required to systematically complete the order and transfer information to Microsoft GreatPlains. 

 

Key Challenges:

  • Build a fully functional website with complete Administration controls
  • Communicating with Microsoft Great Plains from web site and keep web and MSGP database in sync ( Inventory, Sales Orders, Invoices, Customer data etc)
  • Communicating with Safelite Oracle iProcurement system
  • Communicating with FedEx USPS and UPS webservices and calculate freight charges on the fly taking into account - weight, dimensions and destination
  • Integrating online payment gateway – Paymentech Payment Gateway
  • Transferring existing offline customer data of 100,000 from MSGP to web data base and make a offline to online conversion mechanism
  • Providing security for different type of customers with different pricing level
  • Back order & multiple invoice

 

Our Solution:

Touchstone provided the following solutions: 

 

  • The application deals with different types of customers with different pricing levels. 
  • Customer can browse their order history, product form product catalogue based on the select category. 
  • Customer has option to view product price, product image, product description, and add product to shopping cart upon successful login to this application. Customer has option to view product price, product image, product description, and add product to shopping cart upon successful login to this application. 
  • This application had advanced shopping cart where customer can update the quantity, remove items, view checkout price, user friendly navigations for placing an order and integrate to use two different shipping providers’ web services (UPS & FedEx).  
  • Administrators can browse all new orders received; change any order (for customer service), view/edit customer profiles, view payment history, view/edit/add product categories and products including images.  
  • The core functionality of this application is to receive orders from iProcurement (through oracle punch-out XML communication between website and iProcurement), post the XML invoice to iProcurement, synchronize and exchange the data’s between website database and Microsoft Great Plains.

 

To achieve this core functionality we developed three scheduler programs (I) to synchronize and exchange the data’s between website database and Microsoft Great Plains and (II) receive orders from iProcurement through oracle punch-out via XML and (III) post invoice to iProcurement in the form of XML. This scheduler program (I) will run automatically on regular interval of every one hour daily and it does the following jobs to synchronize and exchange the data:

 

a)    Transfer web customer data to Microsoft Great Plains
b)    Update web customer data to Microsoft Great Plains
c)    Transfer web order data to Microsoft Great Plains
d)    Update web order data to Microsoft Great Plains
e)    Get invoice from Microsoft Great Plains and transfer to web database
f)     Update the order status in web database
g)    Send invoice and shipping confirmation email to customer

 

Technology:
ASP.Net 2.0, Webservices
MSGP Web services 
MS SQL 2005
FedEx and UPS Webservices
Lucy Payment Gateway Webservices
Oracle iProcurement Interfaces
ASPEmail Agent