The online orders database is a custom web-accessible database for storing the customer and order information to aid production and sales of Chap Remotes. Created over the course of a summer as a way of teaching database and web programming, it has since processed over 150 orders. It uses a mySQL database with a WordPress interface in order to provide an internal system for processing orders. Each user has a login and role (courtesy of WordPress), so every member of the manufacturing team can do their part in marking items as shipped, replying to customers, requesting payment (via PayPal integration) etc. While of course the system still has much area for improvement (such as automated emails or customer log-ins), we finally had to lay it to rest in order to move on to other projects. However, it has served as a valuable learning experience, as we move forward to utilize these web development skills!
Project Leader: Rachel Gardner
Date Completed: October 2014
Creating the Database
Integrating with the Web
|As one of the most condensed projects of Chap Research, coding the online orders database was an incredible learning experience. Rachel (the only Chap Research student on the development team) started from not even knowing HTML to owning and contributing to every aspect of the incredibly industry-applicable project. This paved the way for her seminar on web development. The application itself has proved tremendously useful, allowing us to process hundreds of ChapR orders.|