We buy some expensive wines from time to time that deserve special care and attention, so I decided to create a Home Assistant dashboard and some alerts:
Aims
- Know which wines are available and if they’ve been cellared long enough
- Get alerted when:
- Wine stock is low
- Fridge temperature or humidity goes out of bounds
Equipment
- grocy 3.3.0 (with the new Stock Notes feature - not possible otherwise)
- Wine fridge
- Xiaomi Temperature & Humidity sensor
Setup
In grocy, I’ve got a single product for “Wine” and whenever I purchase new wines, I add the wine’s name and vintage to the note.
Once you have added your wines to grocy, you can get an embed URL to add into your Home Assistant dashboard that looks like this:
https://my.grocy.url/stockentries?embedded&product=151
You’ll need to replace your product ID and grocy hostname accordingly, but it can be added simply through the dashboard YAML:
- icon: mdi:glass-wine
type: sidebar
badges: []
cards:
...
- type: iframe
url: https://my.grocy.url/stockentries?embedded&product=151
aspect_ratio: 80%
I like an 80% aspect ratio to make it usable on my phone. Also, the sidebar is nice to add your temperature and humidity gauges to.
Meanwhile for the gauges, I configured those with bounds like so:
- type: gauge
entity: sensor.0xa4c13837fd1eaeba_temperature
min: 10
max: 24
name: Wine fridge temperature
severity:
green: 12
yellow: 14
red: 18
view_layout:
position: sidebar
- type: gauge
min: 0
max: 100
entity: sensor.0xa4c13837fd1eaeba_humidity
name: Wine fridge humidity
severity:
green: 50
yellow: 70
red: 0
view_layout:
position: sidebar
Keen to hear others’ thoughts. How would you extend/improve this for your needs?