190 likes | 323 Views
Online Payments. Mark Embling Senior Software Developer The Sixth Form College Farnborough. Overview. Functionality Benefits Staff and students Integration with payment provider Future possibilities Questions. Functionality. Students can pay for items using a debit or credit card
E N D
Online Payments Mark Embling Senior Software Developer The Sixth Form College Farnborough
Overview • Functionality • Benefits • Staff and students • Integration with payment provider • Future possibilities • Questions
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
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
Functionality Very similar to any other online store • Add product(s) to basket • Proceed to the checkout • Enter payment details • Payment processed and acknowledged
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
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
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
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
Integration: Payments • Send order details • Redirect to Sage Pay • Sage Pay will process payment* • Redirect back to confirmation (success/failure) page Notification (“valid order?”) CristalWeb Sage Pay Response (“yes, valid”) Sage Pay charges card
Integration: Refunds Send request to Sage Pay Response returned from Sage Pay
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
Future • Take payments for trips online • Payments for student events • Summer ball • Sports night dinner • Theatre bookings
Thank you for listening Questions?