Program for Rose Street Guitars

Today I went to work for my dad who owns Rose Street Guitars in Berkeley, CA. If you're interested check him out danalexanderaudio.com or rosestreetguitars.com

He gets new guitars and vintage audio gear every day and for insurance reasons he needs to constantly update his inventory. This is getting annoying to do in MS Excel because he has so many different types of things and organizing them alphabetically by multiple categories is annoying. He also would like to be able to see what he had in his inventory in the past, and that's hard to integrate because if you don't delete the item in Excel when you sell it, you would have a million things in there and it would be impossible to find anything.

To solve his problem I'm going to write him a customized program for his inventory using java and then somehow (gotta figure this part out) use a .bat file to allow him to run it easily.

It will use .txt files to keep track of the inventory and have a text based UI that I will simplify as much as possible to make it so he can use it. He's not a computer genius in any way so this could be a challenge. When I'm done I'll post the code online for anybody whose interested to take a look at. Thanks for reading.