university e-commerce: a balancing act (166247859)
TRANSCRIPT
![Page 1: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/1.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 1/18
University E-Commerce: A Balancing Act
Presented by: David Seago, Director of Internet SystemsBrennon Arnold, Asst. Director of Internet Systems
![Page 2: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/2.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 2/18
University E-Commerce: A Balancing Act
Introduction
- Before E-Commerce- Why E-Commerce?
- Baylor’s History With Ad-Hoc E-Commerce
• Deposits/Application Fees• Conferences/Camps• Non-Athletic Events
- Where We Are Today
- Q & A
![Page 3: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/3.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 3/18
University E-Commerce: A Balancing Act
Before E-Commerce…
![Page 4: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/4.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 4/18
Before E-Commerce
University E-Commerce: A Balancing Act
???
![Page 5: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/5.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 5/18
University E-Commerce: A Balancing Act
Why E-Commerce?
![Page 6: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/6.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 6/18
History of Ad-Hoc E-Commerce at Baylor
University E-Commerce: A Balancing Act
First Venture Into E-Commerce (2003)
Financial System
Bank
Baylor-HostedShopping Cart &Payment Collection
Order Entry
??
![Page 7: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/7.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 7/18
University E-Commerce: A Balancing Act
The Sequel (2004 - 2006)
FinancialSystem
Bank
Baylor-DevelopedOrder & PaymentCollection System
Order Entry
Cashier’s OfficeManual
Ledger
History of Ad-Hoc E-Commerce at Baylor
![Page 8: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/8.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 8/18
What We Had Was CHAOS!!
University E-Commerce: A Balancing Act
???
Financials
Can balance ever be achieved???
Order Fulfillment
![Page 9: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/9.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 9/18
University E-Commerce: A Balancing Act
How Did We Achieve Balance?
Created an E-Commerce System that Acts as a “Traffic Cop” Between
Order Processing and Financial Recording
• Centralized Database for allE-Commerce Activities
• Standardized Procedures for Accepting Orders
• Back-end Processes for Auditingand for Funneling Information to Appropriate Systems
![Page 10: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/10.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 10/18
University E-Commerce: A Balancing Act
Centralized E-Commerce Database
• Form Definitions• Accounting Details
• Controls (Dates, Payment, Status)• Departmental Contact Info• Order Entry URL• Unique Form ID• Payment Processor Link
• Transactions/Refunds• System Post Dates• Payment Info• Balance Info• Order Info XML Blob (Trans Only)
• Reconciliation Info• All Transactions That Have Come
Through Payment Processor • Used for Auditing Purposes
MSSQL
![Page 11: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/11.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 11/18
University E-Commerce: A Balancing Act
• Form Authorization Workflow
• Form ID Tied to Predefined Form IDin E-Comm Database (Insures Correct Accounting Info for Every Transaction)
• Unique Transaction ID (Follows
Transaction Throughout the System)
• Flexibility to Handle Any Type of Orders
• Standardized Code For CommunicationWith E-Comm Database
• PHP Functions• .NET Functions• CMS Functions
Standardized Order Acceptance Procedures
![Page 12: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/12.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 12/18
University E-Commerce: A Balancing Act
Back-end Processes
• Postbacks From Payment Processor
• Auditing to Identify Anomalies
• Updating of Transaction Balances &Statuses
• Posting to Financials and Other Systems as Needed
• Processing of Recurring Payments
![Page 13: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/13.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 13/18
Achieving Balance (Phase 1 - 2007)
University E-Commerce: A Balancing Act
Cashier’s Office
FinancialSystem
Order Entry
E-Comm Sys
Third-Party HostedPayment Collection
Web Order System(s)
Bank
![Page 14: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/14.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 14/18
University E-Commerce: A Balancing Act
Cashier’s Office
FinancialSystem
Order Entry
E-Comm Sys
Third-Party HostedPayment Collection
Web Order System(s)
Bank
Achieving Balance (Phase 2 - 2009)
![Page 15: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/15.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 15/18
University E-Commerce: A Balancing Act
Cashier’s Office
FinancialSystem
Order Entry
E-Comm Sys
Third-Party HostedPayment Collection
Web Order System(s)
Bank
Achieving Balance (Phase 2.5 - 2012)
![Page 16: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/16.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 16/18
Balance Achieved!!
University E-Commerce: A Balancing Act
Financials Order Fulfillment
E-COMM SYS
Baylor ITS
• Easy Forms• Manageable• Secure• Prevent Errors
• No $$ Accepted w/o Designation
• Handles Multiple Accounts
• Handles Multiple Departments
• Form Collects Order Info
• Department Handles Fulfillment
• Update Other Systems As Needed
UniqueTransaction ID
![Page 17: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/17.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 17/18
University E-Commerce: A Balancing Act
Q & A
![Page 18: University E-Commerce: A Balancing Act (166247859)](https://reader033.vdocuments.us/reader033/viewer/2022052708/577cd9121a28ab9e78a2a171/html5/thumbnails/18.jpg)
7/29/2019 University E-Commerce: A Balancing Act (166247859)
http://slidepdf.com/reader/full/university-e-commerce-a-balancing-act-166247859 18/18
University E-Commerce: A Balancing Act