Author Topic: Beer Bottle Inventory via Input by Barcode  (Read 3422 times)

Offline friendofbeer

  • 1st Kit
  • *
  • Posts: 4
    • View Profile
Beer Bottle Inventory via Input by Barcode
« on: September 02, 2010, 07:43:13 PM »
Hi All!

I am trying to find an elegant solution to keep an inventory of my current bottle list at home.  Ideally I want to scan into and out of inventory via the bottle's bar code.  The only solutions I am able to find are made for bars / pubs.  I've tried a few inventory apps for my Droid phone, but none of them are really geared to what I'm trying to do.

Does any one else keep a list of what they have?  Have you come up with an easy way to keep track of what's left in the house?

Joey
www.wetyourwhistles.com

Offline Slowbrew

  • Senior Brewmaster
  • ******
  • Posts: 1654
  • The Slowly Losing IT Brewery in Urbandale, IA
    • View Profile
Re: Beer Bottle Inventory via Input by Barcode
« Reply #1 on: September 03, 2010, 07:31:17 AM »
I use a clipboard and a pencil but that's just me. 

I normally geek out on techie solutions as much as the next guy but tracking bottles by bar code would be beyond my needs.  Using RFIDs might be fun though.   ;D

Paul
Where the heck are we going?  And what's with this hand basket?

Offline friendofbeer

  • 1st Kit
  • *
  • Posts: 4
    • View Profile
Re: Beer Bottle Inventory via Input by Barcode
« Reply #2 on: September 03, 2010, 09:35:24 AM »
Mmm tasty RFIDs.

I'm having a hard time believing that I'm the first one to want this type of solution.  I need a programmer STAT, I smell a new Apple / Android app!

Offline kgs

  • Brewmaster
  • *****
  • Posts: 754
  • San Francisco, CA
    • View Profile
Re: Beer Bottle Inventory via Input by Barcode
« Reply #3 on: September 03, 2010, 10:40:09 AM »
RFID sounds expensive per item, due to the tag and equipment cost (we have an RFID system at work, good for what it is but I'm all too aware of the resource requirements). I would suggest that unless you have a security requirement and/or are doing very long-term inventory management of a large number of items that move from place to place (e.g. books in and out of a library), don't add that kind of cost per item.

What about QR codes? You can print them yourself, and you can embed a lot of info in them, and common devices such as cell phones can read them.

http://en.wikipedia.org/wiki/QR_Code

(Get a librarian started on inventory management...)
K.G. Schneider
AHA Member

Offline friendofbeer

  • 1st Kit
  • *
  • Posts: 4
    • View Profile
Re: Beer Bottle Inventory via Input by Barcode
« Reply #4 on: September 03, 2010, 11:03:52 AM »
I do love the QR code idea, but would much rather not reinvent the wheel.  I've already got the beers barcode, and a barcode scanner (droid phone), and the spreadsheet waiting to be used.  I'm just not sure how to pull it all together.

Offline kgs

  • Brewmaster
  • *****
  • Posts: 754
  • San Francisco, CA
    • View Profile
Re: Beer Bottle Inventory via Input by Barcode
« Reply #5 on: September 03, 2010, 11:14:09 AM »
I do love the QR code idea, but would much rather not reinvent the wheel.  I've already got the beers barcode, and a barcode scanner (droid phone), and the spreadsheet waiting to be used.  I'm just not sure how to pull it all together.

Oh, ok, gotcha. If there is any way you can tie barcode ranges to batches, that would reduce the number of access points you need for your metadata. But if they are like most barcodes that's not going to work. My best advice, from years managing metadata, is to use as many access points as you actually need (name, date brewed, location, etc.) but no more. I wonder if you also should use a separate worksheet for each batch. Or if you should actually be using Access or something like that.

If the Droid barcode scanner turns out to be sketchy, LibraryThing sells a CueCat barcode wand that works fine for home use.

Now wondering if anyone already developed an inventory/cataloging program for beer...
K.G. Schneider
AHA Member

Offline weithman5

  • Senior Brewmaster
  • ******
  • Posts: 1668
  • naperville, il
    • View Profile
Re: Beer Bottle Inventory via Input by Barcode
« Reply #6 on: September 03, 2010, 12:11:59 PM »
sounds like it is time to keg.   ;D
Don AHA member

Offline dak0415

  • Brewer
  • ****
  • Posts: 488
  • Winston-Salem, NC
    • View Profile
Re: Beer Bottle Inventory via Input by Barcode
« Reply #7 on: September 03, 2010, 12:29:04 PM »
That's WAY too anal, even for me, and I'm a programmer!
Dave Koenig
Anything worth doing - is worth overdoing!

Offline theoman

  • Brewer
  • ****
  • Posts: 495
  • Outskirts of Brussels, Belgium
    • View Profile
Re: Beer Bottle Inventory via Input by Barcode
« Reply #8 on: September 03, 2010, 12:41:48 PM »
Coming across a beer you brewed a couple years earlier in some hidden corner of the cellar is kinda fun.

Offline friendofbeer

  • 1st Kit
  • *
  • Posts: 4
    • View Profile
Re: Beer Bottle Inventory via Input by Barcode
« Reply #9 on: September 03, 2010, 12:46:06 PM »
Thanks for the great feedback!

I should clarify that I'm also talking about commercial products, which might honestly be easier.  I'm hoping that to do a barcode scan to find pre-existing product data? Am I dreaming?

Offline weithman5

  • Senior Brewmaster
  • ******
  • Posts: 1668
  • naperville, il
    • View Profile
Re: Beer Bottle Inventory via Input by Barcode
« Reply #10 on: September 03, 2010, 01:07:15 PM »
If you just drink them all you won't need to keep track of how many are left ;D
Don AHA member

Offline glitterbug

  • Assistant Brewer
  • ***
  • Posts: 234
  • dallas, tx
    • View Profile
Re: Beer Bottle Inventory via Input by Barcode
« Reply #11 on: September 03, 2010, 01:14:56 PM »
All of this can easily be done with some programming. I've done some work writing inventory systems. Here are the quick plans. You could probably do all of this in excel and a pos scanner.

1. Create a form with an incoming and outgoing text box
2. When you put beer into the fridge, you put the cursor into the incoming text field and scan the label. The scanner will convert the barcode to a unique number (upc).
3. Your query your database\spreadsheet for the barcode number
3a. Barcode found- You enter how many beers are going in
3b. A form pops up for you to create a "beer profile" (name, company, product, abv, etc..). You will enter the details so you do not need to deal with the UPC database. You enter the number of beers going in
4. A "lot" is created with the inventory amount
5. When a beer is removed, you put the cursor into the outgoing text box and scan
6. You enter the number being removed and this number is subtracted from the "lot" quantity based on the barcode number you entered earlier
7. A report will list the lots with quantities and other info
8. Homebrew can be inventoried by printing "3of9" barcodes on suitable media (round cap stickers?)

Good luck :)
 
A witty saying proves nothing - Voltaire

Offline IHBHS

  • Assistant Brewer
  • ***
  • Posts: 101
    • View Profile
    • Ice Harbor Brewing Co.
Re: Beer Bottle Inventory via Input by Barcode
« Reply #12 on: September 03, 2010, 01:19:03 PM »
a desso plug and play barcode scanner and beer smith using the inventory tracker on it and put the number of the upc as the alternative lookup number for the item
Ice Harbor Brewing Co.
www.iceharbor.com

Offline kgs

  • Brewmaster
  • *****
  • Posts: 754
  • San Francisco, CA
    • View Profile
Re: Beer Bottle Inventory via Input by Barcode
« Reply #13 on: September 03, 2010, 02:00:29 PM »
Thanks for the great feedback!

I should clarify that I'm also talking about commercial products, which might honestly be easier.  I'm hoping that to do a barcode scan to find pre-existing product data? Am I dreaming?

It would be great if there were a web-scale app that had metadata for known beer styles preloaded so that brewers could at least inventory/share at the batch if not the bottle level. Librarything for homebrewers, basically.
K.G. Schneider
AHA Member

Offline Thirsty_Monk

  • Senior Brewmaster
  • ******
  • Posts: 1835
  • Eau Claire WI
    • View Profile
Re: Beer Bottle Inventory via Input by Barcode
« Reply #14 on: September 03, 2010, 02:37:57 PM »
Coming across a beer you brewed a couple years earlier in some hidden corner of the cellar is kinda fun.
Could never happen in my household.. ;D
Na Zdravie

On Tap At The TapRoom:
Bohemian Pilsner
Bohemian Dark Lager
Smoked Bock
MaiBock
American Brown Ale
Marzen
Root beer