The Sixth Form College FarnboroughOnline Payments

Online Payments

Mark EmblingSenior Software Developer

The Sixth Form College Farnborough

The Sixth Form College FarnboroughOnline Payments

Overview

• Functionality• Benefits• Staff and students

• Integration with payment provider• Future possibilities• Questions

The Sixth Form College FarnboroughOnline Payments

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

The Sixth Form College FarnboroughOnline Payments

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

The Sixth Form College FarnboroughOnline Payments

Functionality

Very similar to any other online store

1.Add product(s) to basket2.Proceed to the checkout3.Enter payment details4.Payment processed and acknowledged

The Sixth Form College FarnboroughOnline Payments

Product List

The Sixth Form College FarnboroughOnline Payments

Shopping Basket

The Sixth Form College FarnboroughOnline Payments

Checkout

The Sixth Form College FarnboroughOnline Payments

Checkout

The Sixth Form College FarnboroughOnline Payments

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

The Sixth Form College FarnboroughOnline Payments

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

The Sixth Form College FarnboroughOnline Payments

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

The Sixth Form College FarnboroughOnline Payments

The Sixth Form College FarnboroughOnline Payments

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

The Sixth Form College FarnboroughOnline Payments

Integration: Payments

• Send order details• Redirect to Sage Pay

• Sage Pay will process payment*• Redirect back to confirmation

(success/failure) page

Notification (“valid order?”)

Response (“yes, valid”)

Sage Pay charges card

The Sixth Form College FarnboroughOnline Payments

Integration: Refunds

Send request to Sage Pay

Response returned from

Sage Pay

The Sixth Form College FarnboroughOnline Payments

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

The Sixth Form College FarnboroughOnline Payments

Future

• Take payments for trips online• Payments for student events• Summer ball• Sports night dinner

• Theatre bookings

The Sixth Form College FarnboroughOnline Payments

Thank you for listening

Questions?