Transcript Online Applications

Online Payments
Mark Embling
Senior Software Developer
The Sixth Form College Farnborough
Online Payments
The Sixth Form College Farnborough
Overview
• Functionality
• Benefits
• Staff and students
• Integration with payment provider
• Future possibilities
• Questions
Online Payments
The Sixth Form College Farnborough
Functionality
• Students can pay for items using a debit or
credit card
• Exam-related products
• Resits, remarks
• Course-related products
• Books
• Miscellaneous items
• Car park permits, end of year photos
• Refunds can also be given online
Online Payments
The Sixth Form College Farnborough
Functionality
• Online payment is part of CristalWeb
• Our intranet system
• Accessible from within College and externally
• Product list is customised for each student
• Only options relating to that particular student’s
exams and courses of study are visible
Online Payments
The Sixth Form College Farnborough
Functionality
Very similar to any other online store
1.
2.
3.
4.
Add product(s) to basket
Proceed to the checkout
Enter payment details
Payment processed and acknowledged
Online Payments
The Sixth Form College Farnborough
Product List
Online Payments
The Sixth Form College Farnborough
Shopping Basket
Online Payments
The Sixth Form College Farnborough
Checkout
Online Payments
The Sixth Form College Farnborough
Checkout
Online Payments
The Sixth Form College Farnborough
Benefits
• Very easy for students
• Items can be purchased either from inside College
or from home
• Eliminates lengthy queues
• Only those who need to pay cash need to visit the
Finance office
• Teachers can see who has booked resits etc
Online Payments
The Sixth Form College Farnborough
Benefits
• Process of placing orders is streamlined
• Much less work for staff
• Database contains record of purchases
• Resits are automatically entered into the Exam
Entries table
• No manual processing
Online Payments
The Sixth Form College Farnborough
Payment Provider
sagepay.com
• Several different integration options
• Using ‘Server’ integration option
• Sage Pay hosts payment pages and handles all
card details and payments
• We do the rest (basket, order processing)
• ‘My Sage Pay’ administration area
Online Payments
The Sixth Form College Farnborough
Online Payments
The Sixth Form College Farnborough
Integration
• Text-based protocol over HTTPS
• CristalWeb is based on ASP.NET MVC
• Integrates with Sage Pay via SagePayMvc
library
• Written in-house
• Open source (Apache 2.0 Licence)
• http://github.com/JeremySkinner/SagePayMvc
Online Payments
The Sixth Form College Farnborough
Integration: Payments
Add item(s) to
basket
Basket
summary page
•
•
Send order details
Redirect to Sage Pay
Payment
details page
•
•
Confirmation
page
Sage Pay will process payment*
Redirect back to confirmation
(success/failure) page
Online Payments
Response (“yes, valid”)
Sage Pay charges card
Sage Pay
CristalWeb
Notification (“valid order?”)
The Sixth Form College Farnborough
Integration: Refunds
Add refund for an order
Request
refund of
given amount
for order
Attempt to
refund money
to student’s
card
Send request to
Sage Pay
Online Payments
Refund complete
Save refund to
database
Display
success/failure
Response
returned from
Sage Pay
The Sixth Form College Farnborough
Finance Office
• Reconcile payments to College bank account
• Log in to Sage Pay
• Download CSV report
• Compare against CristalWeb report
• Assign payments (and refunds) to cost centres
Online Payments
The Sixth Form College Farnborough
Future
• Take payments for trips online
• Payments for student events
• Summer ball
• Sports night dinner
• Theatre bookings
Online Payments
The Sixth Form College Farnborough
Thank you for listening
Questions?
Online Payments
The Sixth Form College Farnborough