CSE498, Collaborative Design, Fall 2022
Computer Science and Engineering
Michigan State University

Auto-Owners Insurance is a Fortune 500 mutual insurance company that provides automotive, home, life and commercial insurance to nearly 3 million policyholders in 26 states. Auto-Owners Insurance is headquartered in Lansing, Michigan.

Auto-Owners offers company merchandise that their associates can purchase to support and represent the company.

Currently, the purchasing process revolves around paper and pencil order forms. Similarly, when an Auto-Owners administrator wants to analyze purchase data, they must parse the paper records manually, which can be a daunting task.

Online shopping has become increasingly popular in the last decade, providing a better shopping experience for consumers and an easier way to keep track of purchase data. Auto-Owners is looking for a way to modernize their ‘merch’ shopping experience.

Our A-O Merch Search is a web application that functions as an online store and improves the process of purchasing company merchandise for Auto-Owners associates. In addition to purchasing items, associates have the option to read and write reviews for items and view recommended items to help them choose a product that best suits their needs.

Auto-Owners associates use our system to filter, browse and purchase company merchandise from their personal devices using any browser. Purchase history data updates as orders are placed, enabling administrators to see real-time trends for popular items and categories.

Our system improves the efficiency of analyzing purchase data for Auto-Owners administrators by generating relevant graphs and charts.

Our A-O Merch Search system uses React for the front end, Spring Boot for the back end, and Microsoft SQL Server for hosting the database.