Keeping Inventory
 

Hey all,
I decided that I'd start the new year out buy taking stock of what I've got in the humidor, and dang is it a big job! Just wondering if anyone else does this and if so how do they do it?

I sure wish I was doing this all along instead of having to start with a full humidor!

Re: Keeping Inventory
 

I tried and gave up. Between buying and bombs from friends here, it got to crazy.

Re: Keeping Inventory
 

What he said. I used to use an iPhone app, and then an Excel spreadsheet and now I just go hunting :)

Re: Keeping Inventory
 

I have an excel spreadsheet where I log the count date received and I have it calculate age for me too. I also use it to keep track of what I paid.

Re: Keeping Inventory
 

+1...I just dig around and sometimes get a nice surprise, the other day I saw that I have quite a few VSG's in there, totally forgot :tu

Re: Keeping Inventory
 

I try to keep track in my head. I also go and look at order history on CI and Cbid and other places to see how much I paid or when I purchased what. :2

Re: Keeping Inventory
 

I use RFID tags.

Re: Keeping Inventory
 

Well I just finished up, and I'm not sure how much good it did me, but at least I know what I've got now.

Now I just know how many amazing sticks I've got that I really want to smoke! Too bad it's 18 degrees here....

Re: Keeping Inventory
 

Hunt and grab. Nothing better than being pleasantly suprised now and then.

Re: Keeping Inventory
 

I was using Google docs and had a pretty nice spreadsheet going for a while. I gave up on that and now I just hunt through the humidor.

Re: Keeping Inventory
 

I have tried to do this several times using Excel and just didn't keep it current. Now it's just happy hunting as I dig through the humies and coolers. :D

Re: Keeping Inventory
 

:tpd:

I enjoy the surprises I get when engaging in wineador archeology. :D

Re: Keeping Inventory
 

:tpd:

Re: Keeping Inventory
 

The best I can do is marking the year on finger bags.
If I can do that, I feel like I've won.

Re: Keeping Inventory
 

I am keeping track, but of boxes only. Singles would get too ridiculous. I have been writing down on a sticky and attaching it to the box of price paid/purchase date.

I also am using a program that keeps track of all the cigars, but trying to keep up with what you smoke, gave away, etc etc it is hard to keep it accurate. It does serve as a good snapshot of what I have along w/ box codes and I update the counts on occasion by memory.

Re: Keeping Inventory
 

Now that I've done it I guess the only thing I will likely use it for is keeping track of ages on the sticks. Once I get into boxes it will be much easier.

Re: Keeping Inventory
 

I don't inventory singles and I stopped inventorying boxes.

Re: Keeping Inventory
 

Hunt and grab for me. Its fun finding old stuff you didn't realize you had. Its how I got my first personally aged cigar. Lost an Oliva O for a year not too long after I got started and got a nice surprise when I transferred things over to the larger humidor I got.

Re: Keeping Inventory
 

It's like putting on a pair of pants that you haven't worn for a while and you find a dollar in the pocket. :tu

Re: Keeping Inventory
 

You're not supposed to smoke those pants dollars.

;)

Re: Keeping Inventory
 

I had an app on my phone , but it was too much of a PITA to add or subtract cigars all the time.

Re: Keeping Inventory
 

It's easier to divide cigars into groups rather than keeping individual inventory.

Re: Keeping Inventory
 

I was heavily bombed, a few CI orders, Christmas gifting, trying to keep track while not impossible, instantly difficult.

I could magic marker the cellophane with year and date. Could take hours/days.

Re: Keeping Inventory
 

I use a simple excel spread sheet to keep my cigar inventory and it even works on my Android phone or tablet. The only time I have an issue is when I get too lazy to update all three versions to match. Been using this method for about 6 years and havent had any other issues.

Re: Keeping Inventory
 

I was inspired by this thread to do inventory today. I knew I had a lot of cigars but what I found was crazy. When the FDA started talking about a clamp down on cigars I hit the Devil Site hard. Too hard.;)
I found 21 boxes of Cuba Libre Ones after telling the bride I thought I had a half dozen or so. Proof there that large amounts of beer do make me do foolish things. I could just kick myself.:gary

Re: Keeping Inventory
 

I use both Cedar and Cigar Boss apps on the iPhone. But I don't have the types of collections many of you have. I have between 25-40 cigars at any given time. Mostly singles sometimes I will buy a 5 pack or something like that.

Re: Keeping Inventory
 

I don't keep an inventory. I like to jump in like Scrooge McDuck and just see what I come up with.

Re: Keeping Inventory
 

I just did my inventory this weekend. I tried to find a good Android app for free but didn't like any of them. I ended up making a spreadsheet in Google Docs (Google Sheets) that keeps track of age, price, count and a block for some notes. I think this will work well as I can access it from my computer, or anywhere I can access the web, and there's a Google Sheets app for my phone. I think I can keep track of my modest stockpile with this.

Flynnster, what method did you end up going with for your inventory?

Re: Keeping Inventory
 

A pivot table would be good if you have a large inventory. Quick and easy tool.

Re: Keeping Inventory
 

Yea but he's a pastor and afford $100's.

:D

Re: Keeping Inventory
 

I used to have an app and I was very dedicated to keeping track. At some point the app had an update and lost all my info. I never attempted to re-enter every thing.

Re: Keeping Inventory
 

Pants dollars are for buying more sticks not smoking. I go to my purchase history on ci or the devil site for dates or price I payed if I'm curious.

Re: Keeping Inventory
 

Large inventory + my increasing age = I forgot when I stopped keeping track. :-)

Re: Keeping Inventory
 

Being a noob, I keep a spreadsheet listing brand and type of cigar, where I purchased it, amount paid and then a final column where I describe the smoking experience and if I would purchase again.