Pen inventory - International Association of Penturners
     International Association of Penturners
Pens for Service Members
Support The IAP

Go Back   International Association of Penturners > Welcome to! > Site Help, Tips, How-To
  Forgot Password
Register FAQ Members List Search Today's Posts Mark Forums Read
Site Help, Tips, How-To Get and give help for using the FORUM SOFTWARE.

Logged on members can hide ads!

Welcome to!

You've found the home of The International Association of Penturners. You are currently viewing our site as a guest, which gives you limited access to view discussions, photos, and library articles.

Consider joining our community today. You'll have full access to all of our content, be able to enter our contests, find local chapters near you, and post your questions and share your experience with our members all over the world.

Membership is completely free!!

If you have any problems with the registration process or your account login, please contact us.

LinkBack Thread Tools Display Modes
Old 06-20-2017, 06:51 PM   #1 (permalink)
Firebucket53's Avatar
Join Date: Apr 2017
Location: South Carolina
Posts: 23
Photos: 5

Default Pen inventory

How do you keep track of the pens you make and the pens you have made? I am looking for something that will show how much the pin kit cost, the blanks, and anything else you may put on the pen. It would be nice if you could take a picture of the pin and it told you everything that was on it and the price. Kind of like a pen catalog. Any suggestions?
Of all the things I ever lost I miss my mind the most.
Firebucket53 is offline   Reply With Quote Top
Old 06-20-2017, 08:08 PM   #2 (permalink)
TonyL's Avatar
Join Date: Mar 2014
Location: Alpharetta, GA
Posts: 5,492
Photos: 6


There are some apps/software that some of the tuners use. I don't remember the name, but I'm sure someone will furnish it soon.
Am I not destroying my enemies when I make friends of them? Abraham Lincoln



Member of Local IAP Georgia Chapter meets quarterly in Roswell, GA
TonyL is offline   Reply With Quote Top
Old 06-20-2017, 08:21 PM   #3 (permalink)
Join Date: Mar 2017
Location: Tennessee
Posts: 439
Photos: 4


I have been attempting to do that with an excel spreadsheet, but it is a bit cumbersome.

"Good enough is the enemy of great."

Sent from my iPhone using mobile app
Talltim is offline   Reply With Quote Top
Old 06-20-2017, 09:00 PM   #4 (permalink)
Rolandranch's Avatar
Join Date: Jun 2015
Location: Tucson, AZ
Posts: 964
Photos: 147


I use Google spreadsheets. I have all of that info on it. It's really nice because I could tell you in a few clicks how many pens I've made, how much I sold them for, where I sold them, price, kit and blank cost, etc, etc, etc. I list every pen I make on it as soon as it comes out of the shop. Hope this helps.
Seth, a 18-year-old learning from the experts.

I Corinthians 10:31
Likes: (1)
Rolandranch is offline   Reply With Quote Top
Old 06-20-2017, 09:06 PM   #5 (permalink)
magpens's Avatar
Join Date: Feb 2011
Location: Coquitlam, BC, Canada
Photos: 67


I keep all the information in a text file on my computer, one line per pen. It doesn't take much effort if you keep up-to-date and enter each pen on the day you make it.

I used to have a numbering system that started at 0001 and just went up numerically.
I have kept that for the older pens.
Newer pens are numbered, for example, as CG001 for a Cigar kit.

I put a little "dumbbell" shaped tag on the clip of each pen with the pen number and hoped-for selling price.

I would like to use a spreadsheet like Seth, but I don't have access to that technology.

Kids rule the world !!! .... eventually if not already !

magpens is offline   Reply With Quote Top
Old 06-20-2017, 09:08 PM   #6 (permalink)
BURLMAN's Avatar
Join Date: May 2011
Location: Chattanooga, TN
Posts: 1,231
Photos: 10


I use an excel spreadsheet. Works well.
Likes: (2)
BURLMAN is offline   Reply With Quote Top
Old 06-20-2017, 09:14 PM   #7 (permalink)
Jim15's Avatar
Join Date: Dec 2005
Location: Hamilton, Ohio, USA.
Posts: 17,570
Photos: 66


There is a program called Penventory that does what you want. I haven't used it for quite awhile but it was pretty good. It was made by a member on the site a few years ago. The name escapes me at the moment. If you want more info let me know and I'll see what I can dig up.
Hamilton, Ohio
Likes: (2)
Jim15 is offline   Reply With Quote Top
Old 06-20-2017, 09:16 PM   #8 (permalink)
Join Date: Mar 2017
Location: Tennessee
Posts: 439
Photos: 4


"Good enough is the enemy of great."

Sent from my iPhone using mobile app
Talltim is offline   Reply With Quote Top
Old 06-20-2017, 11:10 PM   #9 (permalink)
Join Date: May 2013
Location: NW Arkansas
Posts: 308
Photos: 6


I use Excel. PM me if you want the template.
Thx, rink.
50+ pens and counting!
The Lord is my shepherd.
Likes: (1)
Rink is offline   Reply With Quote Top
Old 06-21-2017, 12:33 AM   #10 (permalink)
Join Date: Mar 2016
Location: Marietta, GA
Posts: 750
Photos: 64



If you have access to the Internet, then you can get free access to Google spreadsheets.

Here is a link that you can use:
Likes: (1)
eharri446 is offline   Reply With Quote Top
Related Content
Logged on members can hide ads


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

All times are GMT -5. The time now is 07:29 AM.

Powered by vBulletin® Version 3.7.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0

Content Copyright © 2003-2018 by, LLC; All Rights Reserved
Terms Of Service   Acceptable Use Policy