Software for cellar inventory reccomendation?

[David_Glasser]

It’s a linear model between critic pairs - I fnid an R^2 of 0.441 (the maximum in the data set) between Parker and Martin, Suckling drops to 0.385, Suckling v Parker is 0.437. What is quite interesting, as you might expect, are the best fits. Suckling = 0.437*parker+31.4 - which is no surprise, there’s general consensus that Suckling scores high.

I didnt take it into too much depth, was focused on building a lightweight MVP only, what really interested me to try to get working well was the critic-recommender, e.g. your scores match XXXXX most closely, so you might want to consider following them.


I tried to build a linear model to infer Jancis’ scores on a 100 point scale, but unfortunately the performance was pretty poor - albeit its known she scores quite differently, to say the least, compared to other critic. Interesting to see how few critics give 100 points out to wines that other critics have given 100 points out (in the data set I used, at least, which is typically very new wines rather than older ones)

Hi Henry, have you thought about looking at this by region or wine style as well as by critic?

[HenryB]

No, though it was an obvious extension. I wanted to prove to myself the basic logic of getting a wine critic recommender workingg. It then becomes an exercise in metadata management, and given how I sourced the original input data, it gets to be a bit of a nightmare. It’s absolutely achievable, but would take some time and effort and dedication.

The basic ideas were:

1 - Wine critic recommender based on general scores
2 - Wine critic recommender based on regions/grapes
3 - Wine recommender based on critics scores (including pricing information to provide best wine under £20, £50, etc)
4 - EP up-sell opportunities for wine merchants, e.g. people who buy a lot of Mouton also buy a lot of blah-blah.
5 - Something more inteligent using review text (rather than just score) to predict, e.g., wines that are under-scored against the text written
6 - Wine progression model, to look at how pricing might change over time


All this was also intended to be explored with CT integration, so you could point to your CT account and not have to do manual input of data (for example). As well as starting to do a lot more critic analysis.


One big problem, though, is the reference data management on the wine list. If anyone is interested in making this a collab, though, I’d be happy to pick it up again! I even had a basic monetization/business model worked out

[Emily_Schindler_Weissman]

Has anybody had any experience with Invintory?

[lleichtman]

We use CT for this as we have bottles in a physical cellar and a large Eurocave. Only problem I have ever had is my wife and her friends pulling random bottles and not recording it. CT works great.

[lleichtman]

We use CT for this as we have bottles in a physical cellar and a large Eurocave. Only problem I have ever had is my wife and her friends pulling random bottles and not recording it. CT works great.

And we maintain ours by region and vintage.

[Nicos_Neocleous]

But cloud based storage is so much more robust than your home system. I am making some assumptions here but… I bet cellar tracker’s database is housed in a secure data center with offsite, continuous back-up so that even if their data is compromised there is another copy located in a geographically different location. I am also making some assumptions that your home computer may have 1 back up to a network drive located somewhere in your house (if you are savvy). If you are using local storage and your house gets hit by lightning and fries your electronics, your info is lost. (side story: I just witnessed this happen to a co-worker, I didn’t actually think it was a thing until about a month ago). Spill coffee on the computer. Dog knocks the computer down the cellar stairs. Wine bottle slips and spills on the computer. Un-backed up local storage is a disaster waiting to happen! If you are backing it up to a remote location, you’ve already started to leverage the “cloud” so just go all in.

Going off on a tangent…

Sure, most cloud services are robust from a technical perspective (or at least that’s the intention; implementation doesn’t always follow suit). The risk is that in the blink of an eye, you may find yourself unable to use them and unable to access your data. It could be the result of hacking, buyout, a new business model, government action, incompetence, whatever. There’s a multitude of risks that are almost impossible to quantify.

Granted, this matters more to somebody running a business than your average wine berserker, but it astonishes me how quickly people and organizations have given up control of their data.

[HenryB]

But cloud based storage is so much more robust than your home system. I am making some assumptions here but… I bet cellar tracker’s database is housed in a secure data center with offsite, continuous back-up so that even if their data is compromised there is another copy located in a geographically different location. I am also making some assumptions that your home computer may have 1 back up to a network drive located somewhere in your house (if you are savvy). If you are using local storage and your house gets hit by lightning and fries your electronics, your info is lost. (side story: I just witnessed this happen to a co-worker, I didn’t actually think it was a thing until about a month ago). Spill coffee on the computer. Dog knocks the computer down the cellar stairs. Wine bottle slips and spills on the computer. Un-backed up local storage is a disaster waiting to happen! If you are backing it up to a remote location, you’ve already started to leverage the “cloud” so just go all in.

Going off on a tangent…

Sure, most cloud services are robust from a technical perspective (or at least that’s the intention; implementation doesn’t always follow suit). The risk is that in the blink of an eye, you may find yourself unable to use them and unable to access your data. It could be the result of hacking, buyout, a new business model, government action, incompetence, whatever. There’s a multitude of risks that are almost impossible to quantify.

Granted, this matters more to somebody running a business than your average wine berserker, but it astonishes me how quickly people and organizations have given up control of their data.

TBH, the problem you’ve made here is that on-premise is any safer. To be clear, the security guys at your business, for 99.9999% of businesses in the world, are less competent than the ones at a cloud provider. The cloud is obviously more dangerous if you DONT KNOW what you’re doing, but if you do know what you’re doing, its vastly better. PCI DSS, DLP, HIPAA, other security standards out of the box.

I’d sooner bet on a data centre outage/going bust/whatever than I would AWS or Microsoft or Google, tbh. There’s an interesting argument in some ways that they are too big to fail now.

It’s not, tbh, about whether cloud is secure or not. It’s about whether its more secure than on prem or not.



I used to be tempted to host my financial details on a server in the cloud - I could give you the IP address (superfluous as it should be behind a load balancer and not allowing public connection anyway, and appropriately locked down with firewalls), and SSH key, and a contract that says you get the money if you get in, and you still wouldnt be able to do it tbh

[Matt_Snow]

I used this for a good time, and liked it. http://www.winebase.com.au/ Independent developer, not updated very often, but quite functional.

– Matt

[Colin_Haggerty]

CellarTracker is OK. It’s what I use while waiting for MyWines to become available. That is going to be awesome!

That is hysterical!

[Tony_C1]

Check out VintVine.com.

A few years ago, I became a bit obsessed with how bad and outdated wine software solutions were, so I created my own for a country club that was sick of spending 40-50 hours counting wine each month. Automated the entire process.

It’s the only modern wine inventory software solution that exists at the moment, and works 10x faster and is more flexible than any other competitor.

We have also done installations for high-end private cellars involving smart mirrors so the aesthetics blend in completely with their current setup.

Currently, you can:

• Add/remove/transfer wines in 2-3 clicks.
• Add extra cellars/locations if needed with one click, and no change in the subscription.
• We upload all your initial inventory for you if you’d like, no cost.
• Easily view and sort all your wine by any variable, including wine type, vintage, wine name, number of bottles, cellar name/location, cost, selling price (if applicable), cellar temperature, etc.
• Add/remove/transfer existing wines by scanning the barcode if there is one, or typing a few characters of the wine name.
• Easily export .csv or PDF reports.
• Set reminders for when a wine is at its best to enjoy.
• View analytics such as most popular wine enjoyed by type, date range etc. (more applicable if you’re a restaurant or club, of course).

I understand your annoyance with the cloud and crazy fees, but I’d like to understand more about what you’d like in terms of local storage and I’d be happy to work something out.

[AD_Northup]

Check out VintVine.com.

A few years ago, I became a bit obsessed with how bad and outdated wine software solutions were, so I created my own for a country club that was sick of spending 40-50 hours counting wine each month. Automated the entire process.

It’s the only modern wine inventory software solution that exists at the moment, and works 10x faster and is more flexible than any other competitor.

We have also done installations for high-end private cellars involving smart mirrors so the aesthetics blend in completely with their current setup.

Currently, you can:

• Add/remove/transfer wines in 2-3 clicks.
• Add extra cellars/locations if needed with one click, and no change in the subscription.
• We upload all your initial inventory for you if you’d like, no cost.
• Easily view and sort all your wine by any variable, including wine type, vintage, wine name, number of bottles, cellar name/location, cost, selling price (if applicable), cellar temperature, etc.
• Add/remove/transfer existing wines by scanning the barcode if there is one, or typing a few characters of the wine name.
• Easily export .csv or PDF reports.
• Set reminders for when a wine is at its best to enjoy.
• View analytics such as most popular wine enjoyed by type, date range etc. (more applicable if you’re a restaurant or club, of course).

I understand your annoyance with the cloud and crazy fees, but I’d like to understand more about what you’d like in terms of local storage and I’d be happy to work something out.

All fine and great, but this is pretty clearly a commercial post…you should probably take another read through the rules as a new member

[Rich_Brown]

Check out VintVine.com.

A few years ago, I became a bit obsessed with how bad and outdated wine software solutions were, so I created my own for a country club that was sick of spending 40-50 hours counting wine each month. Automated the entire process.

It’s the only modern wine inventory software solution that exists at the moment, and works 10x faster and is more flexible than any other competitor.

We have also done installations for high-end private cellars involving smart mirrors so the aesthetics blend in completely with their current setup.

Currently, you can:

• Add/remove/transfer wines in 2-3 clicks.
• Add extra cellars/locations if needed with one click, and no change in the subscription.
• We upload all your initial inventory for you if you’d like, no cost.
• Easily view and sort all your wine by any variable, including wine type, vintage, wine name, number of bottles, cellar name/location, cost, selling price (if applicable), cellar temperature, etc.
• Add/remove/transfer existing wines by scanning the barcode if there is one, or typing a few characters of the wine name.
• Easily export .csv or PDF reports.
• Set reminders for when a wine is at its best to enjoy.
• View analytics such as most popular wine enjoyed by type, date range etc. (more applicable if you’re a restaurant or club, of course).

I understand your annoyance with the cloud and crazy fees, but I’d like to understand more about what you’d like in terms of local storage and I’d be happy to work something out.

All fine and great, but this is pretty clearly a commercial post…you should probably take another read through the rules as a new member

I mean…it doesn’t get much more commercial than that, ha!

And side note…that literally sounds exactly like Cellar Tracker. Which is free.

[Max_S1]

And side note…that literally sounds exactly like Cellar Tracker. Which is free.

I’ve got a dollar that says it looks better on the front end and works worse on the back end…

[Rich_Brown]

And side note…that literally sounds exactly like Cellar Tracker. Which is free.

I’ve got a dollar that says it looks better on the front end and works worse on the back end…

#NailedIt

[Marc_Hauser]

Check out VintVine.com.

A few years ago, I became a bit obsessed with how bad and outdated wine software solutions were, so I created my own for a country club that was sick of spending 40-50 hours counting wine each month. Automated the entire process.

It’s the only modern wine inventory software solution that exists at the moment, and works 10x faster and is more flexible than any other competitor.

We have also done installations for high-end private cellars involving smart mirrors so the aesthetics blend in completely with their current setup.

Currently, you can:

• Add/remove/transfer wines in 2-3 clicks.
• Add extra cellars/locations if needed with one click, and no change in the subscription.
• We upload all your initial inventory for you if you’d like, no cost.
• Easily view and sort all your wine by any variable, including wine type, vintage, wine name, number of bottles, cellar name/location, cost, selling price (if applicable), cellar temperature, etc.
• Add/remove/transfer existing wines by scanning the barcode if there is one, or typing a few characters of the wine name.
• Easily export .csv or PDF reports.
• Set reminders for when a wine is at its best to enjoy.
• View analytics such as most popular wine enjoyed by type, date range etc. (more applicable if you’re a restaurant or club, of course).

I understand your annoyance with the cloud and crazy fees, but I’d like to understand more about what you’d like in terms of local storage and I’d be happy to work something out.

All fine and great, but this is pretty clearly a commercial post…you should probably take another read through the rules as a new member

I mean…it doesn’t get much more commercial than that, ha!

And side note…that literally sounds exactly like Cellar Tracker. Which is free.

Yeah, but is CellarTracker “modern”?

[Rich_Brown]

All fine and great, but this is pretty clearly a commercial post…you should probably take another read through the rules as a new member

I mean…it doesn’t get much more commercial than that, ha!

And side note…that literally sounds exactly like Cellar Tracker. Which is free.

Yeah, but is CellarTracker “modern”?

I think Max is spot on. The CT interfaxr may not be slick/‘modern’…but its super functional, and literally does everything that Tony mentioned. For free.

And I guess when it comes to cellar inventory software…I really don’t have any need for it to be pretty or modern. Functionality is all that matters, and CT is exactly that.

[Anthony_C]

I don’t mind the CT interface but am looking forward to their updates. Some things take a few too many clicks, but I’d rather have the data good than the interface.

When I have company or am traveling to see family, I just send them the restaurant wine list from CT and selection is easier. I also use the export to excel option a lot for my own on site backups. Overall I’m really happy with it.