Page 1 of 1

Wine Cellar inventory tools

Posted: Thu Mar 24, 2016 6:05 pm
by WAwineguy
I am wondering how you good folks keep track of your wine cellars. I have all my wines listed on an Excel spreadsheet, in various categories, and add purchases and subtract bottles drunk, which can be on a daily basis! I know there are online tools out there such as cellartracker - what are the best ones, and why are they any better than just running an old-fashioned spreadsheet?

Cheers!!

Re: Wine Cellar inventory tools

Posted: Thu Mar 24, 2016 7:02 pm
by rens
Ditch the spreadsheet and go to cellar tracker. By far the best out there:
https://www.cellartracker.com

Track inventory, Set up drinking windows, make tasting notes read other's tasting notes. the list goes on....

Re: Wine Cellar inventory tools

Posted: Thu Mar 24, 2016 7:11 pm
by paulf
rens wrote:Ditch the spreadsheet and go to cellar tracker. By far the best out there:
https://www.cellartracker.com

Track inventory, Set up drinking windows, make tasting notes read other's tasting notes. the list goes on....


I'll second cellartracker and add that the reporting is quite useful for seeing how your cellar is spread over vintage variety region and a host of other criteria . There is also a mobile app for it.

Re: Wine Cellar inventory tools

Posted: Thu Mar 24, 2016 7:13 pm
by Benchmark
Forum member Ozzie W put me on to cellartracker.

Great resource.

Re: Wine Cellar inventory tools

Posted: Thu Mar 24, 2016 7:36 pm
by Ozzie W
CellarTracker has so many benefits over a spreadsheet. Just a warning, CT is so good it's almost addictive.
You can import your existing spreadsheet into CT so you don't need to enter all the data again.

Re: Wine Cellar inventory tools

Posted: Thu Mar 24, 2016 7:39 pm
by WAwineguy
paulf wrote:
rens wrote:Ditch the spreadsheet and go to cellar tracker. By far the best out there:
https://www.cellartracker.com

Track inventory, Set up drinking windows, make tasting notes read other's tasting notes. the list goes on....


I'll second cellartracker and add that the reporting is quite useful for seeing how your cellar is spread over vintage variety region and a host of other criteria . There is also a mobile app for it.


Yes that's why I was asking, because my spreadsheet does all that in summary and graphical form, including spread of vintages, producers, regions, grapes, even average bottle age, so I'm wondering what additional things cellartracker can do that you can't do on a spreadsheet.

Re: Wine Cellar inventory tools

Posted: Thu Mar 24, 2016 8:10 pm
by rens
WAwineguy wrote:
paulf wrote:
rens wrote:Ditch the spreadsheet and go to cellar tracker. By far the best out there:
https://www.cellartracker.com

Track inventory, Set up drinking windows, make tasting notes read other's tasting notes. the list goes on....


I'll second cellartracker and add that the reporting is quite useful for seeing how your cellar is spread over vintage variety region and a host of other criteria . There is also a mobile app for it.


Yes that's why I was asking, because my spreadsheet does all that in summary and graphical form, including spread of vintages, producers, regions, grapes, even average bottle age, so I'm wondering what additional things cellartracker can do that you can't do on a spreadsheet.



Tasting notes to monitor progress.
Reports by storage location-very handy
Records what you paid, where you got it from
Can combine critics notes.
mobile app-which is very useful when browsing shops etc

Just do it. You won't regret it.
(no pretty graphs though)

Re: Wine Cellar inventory tools

Posted: Thu Mar 24, 2016 10:29 pm
by Scotty vino
i use CT. On my phone I use Corkz which links to CT.
pretty handy to have a phone app to go to when you're at a cellar door
trying to remember what you've bought in the past etc etc.
Like anything CT is great if you use it properly.
But a few lazy moments of not deleting, drinking, removing wines
can create minor chaos.
The other day I did a stocktake of sorts and found some wines didn't actually exist anymore and
some wines popped out of thin air. Easy come, easy go i suppose.

Re: Wine Cellar inventory tools

Posted: Fri Mar 25, 2016 6:27 am
by Ian S
One bigbenefit of Cellartracker, is the inventory of wines already entered. Start typing the wine name in and before you've got the Buiten out of Buiternverwachting typed in, it's already listed all the wines they've made, so the amount of typing required is often minimal.

Re: Wine Cellar inventory tools

Posted: Fri Mar 25, 2016 10:09 am
by Chris H
You can look at a spreadsheet without needing to be connected to the internet though I suppose. Presuming Cellartracker requires online access ?

Can you download a copy of your database so you can view it when offline ?

Re: Wine Cellar inventory tools

Posted: Fri Mar 25, 2016 12:53 pm
by Diq
You can print off all your reports from cellartracker if you'd like a physical spreadsheet as well as export a copy of your spreadsheet. However, you do need internet access to view your inventory through the App.

Re: Wine Cellar inventory tools

Posted: Fri Mar 25, 2016 1:05 pm
by Ozzie W
Chris H wrote:You can look at a spreadsheet without needing to be connected to the internet though I suppose. Presuming Cellartracker requires online access ?

Can you download a copy of your database so you can view it when offline ?

CT requires Internet access. You can export your database to a spreadsheet, so offline access is still possible.

The true power of CT comes from combining the data entered by the 400,000+ people using it. At a glance you have tasting notes and suggested drinking windows for all the wines in your cellar. There's information about over 2 million wines in the CT database - an invaluable resource when considering a purchase, particularly for older vintages which pre-date your Halliday/Parker/etc. type sites.

CT is free to use (although they suggest a donation if you like it). I challenge anyone still using a spreadsheet to try it. I'd be very surprised if you go back to the spreadsheet.

Re: Wine Cellar inventory tools

Posted: Fri Mar 25, 2016 1:22 pm
by Ozzie W
Scotty vino wrote:i use CT. On my phone I use Corkz which links to CT.

I'm curious, Scotty. What do you find in Corkz which you can't do in the CT app? From what I read Corkz was useful before CT had an app, but now the CT app does almost everything the CT website does.

Re: Wine Cellar inventory tools

Posted: Fri Mar 25, 2016 3:56 pm
by Chris H
I challenge anyone still using a spreadsheet to try it


I actually use an MS Access database, with a number of "Queries" set up for looking at varieties, region etc :roll:

Re: Wine Cellar inventory tools

Posted: Fri Mar 25, 2016 5:36 pm
by Ozzie W
A well designed spreadsheet or database could replicate the cataloging and reporting features of CT, but it would be a lot of work. Even so, you'll still miss out on all the "community" features. For example, every time I log into CT it shows me new tasting notes for wines in my cellar, written by other CT users. The suggested drinking windows of my wines are constantly updated based on what all the other CT users think. And this is just scratching the surface in terms of features.

Re: Wine Cellar inventory tools

Posted: Sat Mar 26, 2016 3:44 pm
by Pej
I wouldn't even consider setting up a spreadsheet over Cellartracker. Sure you could set it up to do the same thing, but why would you when Cellartracker has already been done for you and is no doubt better. Even if you don't agree with 99% of the opinions on there, it's still a good way to gauge what a wine will be like. You can't get that from a spreadsheet. No brainer really.

Re: Wine Cellar inventory tools

Posted: Sat Mar 26, 2016 4:14 pm
by Chris H
What part of your wine holdings is public ?

Re: Wine Cellar inventory tools

Posted: Sat Mar 26, 2016 4:28 pm
by rens
Chris H wrote:What part of your wine holdings is public ?


None, unless you choose to share them with others.

Re: Wine Cellar inventory tools

Posted: Sat Mar 26, 2016 8:30 pm
by swirler
The number of bottles in your cellar is given even if you opt to keep your cellar private IIRC.

Re: Wine Cellar inventory tools

Posted: Sat Mar 26, 2016 9:22 pm
by Ozzie W
User a pseudonym. Don't need to think about the privacy aspect.

Re: Wine Cellar inventory tools

Posted: Fri May 20, 2016 6:49 pm
by WAwineguy
Well I'm now a fully fledged member of Cellartracker - it's a pretty great service. While I admit I am still keeping my Excel spreadsheet up to date, I'm not sure how long that will last! I just like to be able to do my own graphs of what vintages I have throughout my collection to try to get some balance (way, way too much 2010 and 2012).

But Cellartracker is a fabulous tool, for any readers out there who are considering how to keep track of their inventory. It's also a pretty good one-stop-shop for wine ratings with fabulous community input.

Re: Wine Cellar inventory tools

Posted: Fri May 20, 2016 7:21 pm
by PaulV
WAwineguy wrote:But Cellartracker is a fabulous tool, for any readers out there who are considering how to keep track of their inventory. It's also a pretty good one-stop-shop for wine ratings with fabulous community input.


Couldn't agree more. Have been part of cellar tracker for nearly a decade, before that excel and then Torb wines database. Cellartracker is so powerful, user friendly and community based once you move to it never leave - like apple products for a lot of people. Worth providing a donation.

Re: Wine Cellar inventory tools

Posted: Fri May 20, 2016 10:24 pm
by crusty2
CT is great for getting a global perspective on our local wines. Even if locals reiew the wine you have a Vic reviewing a SA wine and all the other permutations. For those who develop a cellar/state biased palate it is nice to have a second/third etc palate view.

Cheers
Phill

Re: Wine Cellar inventory tools

Posted: Sat May 21, 2016 10:21 pm
by swirler
Cellartracker will have graphs....eventually.

Re: Wine Cellar inventory tools

Posted: Sat May 21, 2016 10:53 pm
by Con J
I just use Excel, different page for country and region and update regularly.
I can find any bottle I need using this.

Cheers Con.