Wow! That is one heck of a project! :-)
About 10-12 years ago I did a similar project for a local theatre which has a huge (as in ginormous) prop and furniture collection and a very active rental program. The purpose of the project was to increase the rentals (which were a good source of income) by setting up a web site with photos and descriptions of everything. The project ended up having three phases:
1. Organize the collection
When I took over, the bulk of the smaller items were stored in large cardboard bankers' boxes (the ones made for legal files), which were about fourteen inches wide by twelve deep by about two feet long. These were stored, two or three boxes high, on very sturdy steel shelves. The boxes were already labeled, but not too well, so I re-labeled them and also numbered them. Then, in preparation for phase 2, I also numbered all the shelves. Part of this involved weeding out the stuff and throwing out damaged items or anything we knew would never be used again.
In the end, we had sort of a department-store setup: an area with so many boxes for kitchen and serving stuff, another area for small electronics, another area for books and magazines, and so forth. It was really easy to just go to the area you wanted, and there was the stuff.
2. Inventory the collection
Now that the pieces were physically organized, we did an inventory, which was necessary for creating the web site. I set up a spreadsheet on my then-current-but-now-ancient Palm VIIx and wrote up the pieces as I went. I won't go into the geek-speak here :-) but it actually worked very well and saved a lot of time.
This was also where we photographed every item and gave it a tag number -- and where we made some executive decisions. For instance, if we had eight dinner plates which were exactly the same, we didn't give each one a number; we just gave a number to this type of dinner plate and listed the quantity as eight. Same for hardbacks. The inventory said "Book, hardback," and the quantity as whatever it was, probably 100 or so. The book photo showed six or eight books, enough to tell someone what they looked like.
I can give you more info on this if you want, but the above is the general idea.
3. Create the web site
The visual design of the web site has been changed since I created it ten or so years ago, but it still works the same way: basically a department store, and the original photos are still there (unfortunately some photos are missing). You can visit it and see how we did the photos and tag numbers at www.dmtrentals.org.
Good luck! This can be a huge project, but have fun with it and keep a sense of humor!
------------------------------
George F. Ledo
Set designer
www.setdesignandtech.wordpress.com
www.georgefledo.net
Original Message:
Sent: 06-18-2016 16:54
From: Jennifer Dinndorf
Subject: Organization of prop storage
Hi everyone!
We are undertaking the daunting task of organizing our prop storage this summer. (God help us.) Anyone have any clever organizational hacks, suggestions, or solutions they'd be willing to share? We'd love any ideas you'd be willing to pass on.
Thanks! :)
------------------------------
Jennifer Farrell Dinndorf
Chapter Director, MN Thespians
English and Theater Teacher
Chaska High School
Chaska, MN
------------------------------