e-commerce presentation csg

7/29/2019 E-Commerce Presentation CSG

1/41


2/41

Wisconsin 17

Stanford 9


3/41

The University of Wisconsin, Madison

E-Commerce

Infrastructure

Biggest current application

Jack Duwe, Deputy CIO

[email protected]


4/41

What infrastructure?

Campus/Bank/CyberCash connectionSecure web server

Mechanism to integrate withdepartmental storefrontTransaction detail audit trails

Help writing integration scriptsCookbook how to do it instructions


5/41

Bank/CyberCash Connection

Each department a merchantMerchant registers with CyberCash

Merchant/Business Servicesestablishes new bank accountMerchant applies to credit card

processor

We guide the merchant through this!


6/41

Application Setup

Merchant develops storefront Or, we will contract to create/host it

We host the Credit Card form API to the storefront


7/41

How does it work?

Transaction form from browserSave detail in transaction database

Transmit to CyberCash

CyberCash to card processorCard processor approves/denies

DoIT updates database, confirms to

browserMerchant informed (email, database)


8/41

Typical service DoIT offers

Help becoming E-commerce merchantAPI to the storefront

Complete transactional detailCustomized email to customerConfirming message to merchant

Web access to transaction databaseTraining in CyberCash administration


9/41

Cost and Billing Rates

Fixed costs $109 to establish Merchant ID

$22/month to maintain Merchant ID $150 to integrate storefront and

CyberCash system (DoIT)

$65/month to maintain account (DoIT)


10/41

Cost and Billing Rates

Variable costs 2% of purchase total (card processor)

30/transaction (card processor) 50/transaction (DoIT)


11/41

Typical applications

Soft goods (no physical item) Union conference services Extension conference services

Registration for Fun runs, golftournaments

Admission application fees

Memberships Contributions


12/41

Typical applications

Physical products (Distribution is the tough part!) Software to students

Software to departments Supplies to departments

Student football tickets (clumsy!)

No API to proprietary ticket system


13/41

Volumes this year

20,000 orders

$1 millionHalf during the last 3 months

Growing rapidly!


14/41

Technical Environment

Netscape Suitespot Web Server

Verisign 128-bit Digital Certificate

Perl/CGIOracle 7.3.4

DBI/DBD drivers

NT Server with IIsASP for merchant reporting


15/41

Technical Questions

Brian Busby, Project Manager

[email protected]


16/41


E-Commerce

Infrastructure

Biggest current applicatio


17/41


18/41

What is WISC?

An entity designed to serve

Wisconsin Higher Education bymaking the most popular softwareavailable to students at the lowestprices possible


19/41

WISC serves:

26 University of Wisconsin campuses

12 WTCS campuses

250,000 StudentsDepartments

Each campus may have differentpolicies


20/41

Student Product Offering

Office 2000 Premium EditionWord, Excel, PowerPoint, FrontPage, PhotoDraw, Publisher,Outlook Express, Access, Interactive Training, & Internet Explorer

Office 98 Macintosh Edition & FrontPageWord, Excel, PowerPoint, FrontPage, & Outlook Express

Windows 32 operating system upgradeWindows 95/98, Windows NT, & Windows 2000 (Feb. 17, 2000)

Visual Studio Professional EditionVisual Basic, Visual C++, Visual FoxPro, Visual InterDev, & Visual J++

Microsoft Products:


21/41

Student Product Offering

Corel WordPerfect Office 2000 Std EditionWordPerfect, Quattro Pro, Presentations, CorelCENTRAL, Trellix,

Microsoft VBA, Adobe Acrobat Reader

Apple Operating System UpgradesOperating System Version 9.x

FileMaker Pro

Windows and Macintosh VersionsAnd More Products As They Become Available

Additional Products:


22/41

MS Contract Requirements

Student sales One media set per product

Office 2000 on secure CDs only

Department sales No personal staff sales

Home use of office license OK


23/41

FundingMS site license cost about the same as

new Select program For department use only

Existing volume Concurrent use eliminated

Student use added at minimal cost

Funding License is funded by each campus Customers pay for media and distribution


24/41

Pricing

Student copies $25-$30 per set

Includes shipping and handlingDepartment copies

$30-$60 per 10-pack

Includes shipping and handling


25/41

The work involved

Negotiate site licenses

Establish WISC web site Customize for each campus Use existing E-Commerce infrastructure

Organize advertising/promotion 38 cities


26/41

The work, continued

Organize distribution

Provide Help Desk scripts

Calculate costsSet prices

Manage the project!


27/41

The teamSystems Engineering (Project mgt)Distribution/Logistics

Marketing

Application Technology

End User Computing

Product SalesAdministration


28/41

Timeline

Contract negotiation 10 months

November-AugustE-Commerce/Distribution system

5 months

June-October


29/41

The WISC Order Process

1. Authentication2. License Agreement

3. Product Selection (History File)4. Shipping Information

5. Payment Information6. Order Acknowledgement


30/41

Email Receipt

Two Email Receipts Are Sent To Address Specified on Order

To Address in Student Data FileOrder Number and Shipping InformationLocal Support Contacts

Customer Service Information


31/41

Distribution


32/41

Distribution/Logistics

DoIT Logistics groupOff-campus warehouse

Loading dock for semis

UPS online systemTwice-daily pickups

Most orders out same day,many delivered the next day!


33/41

Marketing & Promotion


34/41

Managing the Flow of

Information for 38 CampusesThe WISC Home Page

http://www.wisc.edu/wisc

WISC News Emails

Displays & Posters

Ads Placed in Campus PapersAll Funded by Distribution Process


35/41

The First 90 Days

WI C Hi hli h Th Fi 90 D


36/41

WISC Highlights The First 90 Days

WISC Web site contains over 1500 pages of

product specs and technical supportinformation serving 38 campuses.

WISC Web Site had in excess of 2,000,000hits in its first month of operation. Site

currently has more than 10,000 visitors perweek.

2,200 Orders were processed in the firstday of operation. Over 10,000 Orders in thefirst month.

WISC Hi hli h Th Fi 90 D


37/41

WISC Highlights The First 90 DaysThe volumes of credit card transactions

were so great in the first days of operation

that our credit card vendor could not keepup.

To date, all online orders have been shipped

within 24 hours of the time they wereordered!

The WISC online ordering system allows

customers to track their order from ourloading dock to their front door.

WISC Hi hli ht Th Fi t 90 D


38/41

WISC Highlights The First 90 Days Customer Service 800 number is averaging 75 calls per

day.Emails to Customer Service average 30 per day.Mail-In (Non-Credit Card Sales) Averaging 7% of TotalMore Than:18,000 Online Orders Shipped25 Tons Shipped via UPS525,000 CDs, Ordered or Replicated$550,000 In Credit Card Revenue Collected Online


39/41

WISC Technical Questions

Pat Brennan, Project Manager

[email protected]


40/41


41/41


E-Commerce

Infrastructure

Biggest current application

Jack Duwe, Deputy CIO

[email protected]

e-commerce presentation csg

Documents