Inspiration
A little over 3 years ago some of my best friends opened a card store. Excited they were it became an organizational nightmare. I started working for them managing their online sales. Often we had over 16 thousand unique inventory items listed online at once! I realized those numbers are not possible for a human to keep track of. Our process was slow and required individual painstaking pricing, inventorying, and processing for shipment. I kept doing it day after day wondering "there must be a better way to manage all these cards!" That's where bulk.dex comes in. An online inventory management tool powered by Google Sheets and Gemni.
What it does
Bulk.dex uses computer vision and googles Gemni ai to recognize cards and index them on a Google Sheet. The index functions by treating long "bulk" boxes as 1000 individual inventory slots ready to be filled. Once a card is inventoried it is inserted into the first available slot and if one is removed importantly it simply shifts the index following the slot down by one. Meaning that you do not need to manually sort each card by alphabetization or by card type. You can simply mass scan cards and now you know the location of each one of your cards!
How we built it
I built this tool using C to manage the back end inventory indexing and using JavaScript to call to Google sheets api and update the sheet. I, along with the help of ai tools, used HTML and CSS to handle the front end.
Challenges we ran into
Some of the challenges I ran into where api calls and efficiency. I would like the tool to be easy for all people and lower the time to process cards. Efficiency is key as the primary goal of this tool would be to remove the human element of inventory management.
Accomplishments that we're proud of
Getting a working demo going that is sleek and modern. The camera functionality seemed like an impossible task but ended up being one of the easiest parts!
What we learned
I learned how to manage front end and back end development. Managing what the minimum viable product would be.
What's next for bulk.dex
Adding a robotic element, that is truly the main goal. Small time sellers to large multi million dollar card stores still do things by hand with simple card board boxes and paper sheets for order invoices. I would like to fully automate the process of inventory input and retrieval. This could increase sales volume as well as lower order error and costumer dissatisfaction.
Built With
- c
- chatgpt
- css
- gemni
- html
- visual-studio