Aggie Inventory System

In an environment is speedy and things need to be done asap workers need a website application that can speed up the process while maintaining accurate inventory.

Comment

Inspiration

We took inspiration from our own school CSU Stanislaus that has a similar type of businesses but with food. This business is able to keep track of inventory and people coming in to the store. We thought that it might be nice that they could get the essentials that a business deserves.

What it does

Our application keeps track of inventory; when items were brought in, which items, how many items, and when items were removed. Our application also tracks foot traffic in the store so managers can preemptively schedule employees to manage rush hour.

How we built it

We used PYQT for the user interface, Python for the backend, and MongoDB for the backend. We used libraries like QR_Code, os, system, cv2, time, Django, and csv. We used git repository to allow us to work together.

Challenges we ran into

Our hardest part about this project was by far git. Our group had some newer folks that haven't used git so we got to learn together. We also had to learn how to integrate MongoDB with our python program.

Accomplishments that we're proud of

Successfully integrated MongoDB into our program as well as succeeded in what we set out to do.

What we learned

How to utilize GitHub for collaborative coding and learning all the tricks and workarounds to get on the same page in GitHub. How to utilize the pymongoDB framework.

What's next for Aggie Inventory System

We thought locating places near Davis that are willing to give free clothes or items away and alert the business about them so that the Aggie Reuse store has more inventory to give.

Share this project:

Updates