ARTEMIS Aggie Reuse TEch Management of Inventory System

The Aggie Reuse Store is a non-profit whose inventory system consisted of Google Sheets. Artemis addresses their need for a new inventory system that is more user-friendly, organized and scalable.

Comment

Inspiration

The Aggie Reuse Store is a non-profit organization dedicated to fostering financial savings for individuals while actively mitigating clothing waste by diverting it from landfills. We thought that was a great idea and wanted help support them by upgrading their inventory tracking system.

What it does

ARTEMIS provides an interface to log students in by their student ID as well as a user-friendly interface to track donations and sales of items. It's been optimized for use on an iPad or similar table, with a simple card reader to swipe UC Davis IDs.

How we built it

The front-end is a React app that sends the entered data to our Node.js instance that is running on GCP. Node.js then utilizes PRISMA to create an entry to CockroachDB.

We are able to collect demographic data on user by utilizing the UC Davis identity store API

We only need an API key to complete this, which can be easily acquired when it's not a weekend.

Additionally, our Node.js server is able to track total user interactions with the store by means of an IR breakaway sensor that can be placed at the entrance to the store.

Challenges we ran into

We had a few challenges on our backend side. CORs kept us from submitting some of our requests, and with our backend group member feeling unwell on the second day, we weren't able to fix that. However, all other API methods work, and the inventory management system as a whole functions perfectly.

Accomplishments that we're proud of

We are very proud of the way our React app turned out. It was emphasized that the user-interface had to be user-friendly and streamlined, and we think that we had accomplished that. We are also proud of how we store the data as the data analytics team can access CockroachDB and query it using SQL.

What we learned

We learned a lot about React and MUI. Additionally, we learned a lot about integrating several different components of a project at the same time, and the challenges that come along with parallel development.

What's next for ARTEMIS Aggie Reuse TEch Management of Inventory System

The next step for ARTEMIS could be to schedule certain queries, that the data analytics team is interested in, to run every so often and create a dashboard to display that data. The data is already there and ready to be read, it's just up to someone to build a simple dashboard.

Built With

Share this project:

Updates