If you have a wine cellar, you have more than a few bottles of wine, so you need a wine cellar inventory management system. Here are your choices:
First, you could simply not keep track of your wine. You could put all of your reds in one section, and all of your whites in another. You could further arrange them by type of grape, or winery, or whatever other criteria you choose. Then, when you want a bottle, you go to your cellar and hunt around until you find the bottle you want. This system is simple, and if you only have 200 or 300 bottles, this may work well.
The next simplest system of wine cellar inventory management is to record your inventory in a book. You have a page for each case you buy, and you list the bottles. Again, you can segregate your pages by red or white, or date purchased, or whatever other system you want.
I don’t like either of those systems, because I like to track lots of details. That leaves you with a computerized system.
There are many systems, such as the one offered by Uncork, which contains a computerized database of wine, and even has a bar code reader. You scan the UPC bar code on your bottle, and you can connect to a database to find tasting notes, and whatever else you want.
I haven’t tested it; it’s probably a great system. Personally, I don’t have 10,000 bottles, and I don’t always want to scan every bottle as I drink it, so I’ve designed my own system.
First, I created a database using Filemaker. This database software is relatively simple to create and use. You don’t need to be a programmer. Obviously there are lots of other database programs you could use, such as Microsoft Access, but I’ve always found it to be more cumbersome. You don’t need a fancy database; something simple will suffice.
I created the fields I wanted. The obvious ones are:
- Wine name
- Year
- Grape
- Country
- Price per bottle
- Date added to wine cellar
I live in Canada, so I purchase most of my wine through Opimian, a not for profit buying group. (Sorry, they only operate in Canada). Each order book contains various other details on each wine, so I’ve added those to my database, including:
- Tasting notes
- Suggested serving temperature
- Years the wine is best
- Suggested food matches
Here’s how I do it: when I pick up a new case of wine, I enter the information into the database, and I print wine bottle tags to identify each wine. I them print a hard copy of my wine cellar inventory (one page for each case of wine).
When I want to drink a bottle, I can either do a search on my computer (by grape, food match, or whatever other field I want), or I can look at my printed binder to find something quick (I arrange the pages by red, white and rose).
It’s simple, and easy.
Want to see a copy: here’s an empty copy of my Filemaker Wine Cellar Inventory Management System. You will need Filemaker to open it. My database is free, but of course it’s also entirely unsupported, so use it at your own risk, and good luck.
{ 3 comments }
