The future of effective e-commerce decides the ability to deliver a consumer-centric and engaging online inordinate experience that enables customers to interact and transact.


Internet's large-scale global penetration has reproduced an increasingly large number of technology and web-savvy consumers, creating a huge opportunity for both buyers and sellers. Over the past decade, e-commerce has evolved from a basic communication and transaction channel between buyers and sellers, to an end-to-end collaboration medium between all stakeholders. This collaboration is driven by companies looking to increase sales by offering online product recommendations and promotions, as well as end-customers seeking the rich and personalized online experience that many retail web sites offer.


"The consumer today has access to information at a click - be it pricing, quality and everything else there is to know". Given the scenario, companies can create more wallet share by reaching out across digital channels.


Out of many applications we have developed in the past decade, the most emerging application we have developed is "Sales force Automation" software for one of the Fortune 500 Footwear and Apparel Company in US. The client being a Footwear and Apparel Company in US, originally had 6 different versions of custom developed Sales Force Automation packages for each of its subsidiaries. It was then proposed to the client that a single web based application comprising of facilities for Order Entry, Order Status, Inventory Lookup and Adhoc Sales Reporting can be developed in a configurable manner with role based access capabilities, multi lingual, multi-currency, automatic software upgrades and data synchronization through extranet.


Primary Features of the Sales Force Automation Application:

  • Sales Force Automation Product is a full-fledged web based application which the user can configure and run from a laptop remotely and use it to book orders, get order status, get inventory status and run various reports.
  • The product caters to multilingual needs and enables the user to periodically upload the order data from the laptop to the Web Server located centrally from where the data will be uploaded to SAP system.
  • The product enables the user to download relevant information like master data and order status information along with inventory availability to his laptop from SAP system.
  • Several administration utilities are provided at the online server to facilitate data upload and download, configuration of the application and creation and maintenance of security related aspects.


Functional Details:

  • Offline Functions ( Laptop)
    1. Account Lookup
      • Enables the sales rep to view the customer information including Ship to and Bill to Details
    2. Order Entry / Order Edit
      • Enables the sales rep to book orders and modify the existing orders. The product data along with the inventory status is provided as a lookup.
    3. Order Build
      • Enables the user to build the EDI file from the order information. This EDI file will be later uploaded to SAP system
    4. Order Confirmation Status
      • The user can view the status of the orders as obtained from the SAP system
    5. Data Refresh
      • Enables the user to upload the Order data from the laptop to SAP system and download the inventory and Order Status data from SAP system to the Laptop
    6. Order status and Inventory Reports
    7. Adhoc Sales Reporting
    8. Automatic Software Updates


Online Functions (Application Server)

  1. Maintain Users
    • Allows the admin to create/modify/view and delete user information
  2. Maintain Sales Organization
    • Allows the admin to create/modify/view and delete Sales Organization information
  3. Maintain Configuration by Sales Organization and Order Horizon
    • Allows the admin to configure the layout and behavior of data entry screens based on the functionalities specific to each of the sales organization and Order Horizon for each of the Sales Orgs.
  4. Net Change Download Process
    • Background process run to create files containing incremental data changes to be downloaded to laptop
  5. Full Refresh Download Process
    • Background process run to create files containing complete data backups to be downloaded to laptop
  6. Administration utilities


Development Environment:

  • Developed the application by using J2EE with JSPs and Servlets and MVC architecture
  • Tomcat 4.1 Web Server on Laptop
  • IIS web server for online utilities
  • MySQL 4.0 database on Laptop
  • SQL Server 2000 used as Backend Database