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 penturners.org! > 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 penturners.org!

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.

Reply
 
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: 21
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: 4,833
Photos: 6

Default

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

Peace,

Tony
TonyL is offline   Reply With Quote Top
Old 06-20-2017, 08:21 PM   #3 (permalink)
 
Join Date: Mar 2017
Location: Tennessee
Posts: 230
Photos: 4

Default

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 Penturners.org mobile app
Talltim is online now   Reply With Quote Top
Advertisement
Old 06-20-2017, 09:00 PM   #4 (permalink)
 
Rolandranch's Avatar
 
Join Date: Jun 2015
Location: Tucson, AZ
Posts: 584
Photos: 60

Default

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 17-year-old learning from the experts.

https://www.instagram.com/woodnotch/

I Corinthians 10:31
Likes: (1)
Rolandranch is online now   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: 42

Default

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.
__________________
Mal



magpens is online now   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,126
Photos: 10

Default

I use an excel spreadsheet. Works well.
Likes: (1)
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: 16,551
Photos: 64

Default

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.
__________________
jim,
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: 230
Photos: 4

Default

http://www.penventory.com/inv.pl



-------------------------
"Good enough is the enemy of great."

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

Default

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: 649
Photos: 58

Default

Mal,

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

Here is a link that you can use: https://docs.google.com/spreadsheets/u/0/
Likes: (1)
eharri446 is offline   Reply With Quote Top
Related Content
Logged on members can hide ads
Reply

Bookmarks

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 05:04 PM.

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

Content Copyright © 2003-2016 by Penturners.org, LLC; All Rights Reserved
Terms Of Service   Acceptable Use Policy