Over the past few years of making pens I’ve seen the question of inventory pop up again and again in the Facebook groups. I never really cared too much about keeping inventory until the 2nd annual Mid-Ohio Valley Pen Turner’s Gathering where I was confronted with all sorts of great deals. I knew I wanted to buy some more pen kits and I knew I had some at home but I didn’t know what finishes and how many. And that led to the birth of Pen Kit Inventory.
If you’re coming to Pen Kit Inventory for the first time then you’ll see the screen on the left asking you to create a login. If you already have an account then you’ll see the screen on the right.Sign-up screen Sign-in screen
Once you’re signed in you’ll see the four blocks with a number of how many items in that category and the total dollar amount (if you’ve added that). You can also see in the left sidebar that the Dashboard icon is blue which indicates that is the current view.
Each of the 4 blocks is a button that will display a table view of that category.Dashboard view View of Pen Kits
Each of the table views has a downward pointing arrow at the top right which is there in case you ever wish to pull your data out of Pen Kit Inventory. Clicking that icon will download all your database records in the form of a CSV file.pen kits exported as CSV file
Add Pen Kits
To add pen kits, click the + Pen Kits in the left sidebar. The light gray helper text will go away as soon as you begin to add your content, it’s only there to help in case you aren’t sure what to input. None of the fields are required so don’t feel you have to fill in each field.
In the Supplier field, I often just put the URL to the store where I bought the item. I do this so I know where to return in case I want to buy more.
The View Pen Kits button on the right above the table will take you to the table view of pen kits already in the system.Add Pen Kits
As you can see, each menu item brings up a form where you will input details about your inventory.
Each of the table views has a button on the right above that table that will take you to the table view where you can see all the items in that category.Add blanks
Under the Supplies menu item you’ll see forms for
- Drill Bits
The Completed Pens form is where you put the pens that are made. When inputting this information you’ll be required to choose from pick menus for Pen Kit Used and Blank Used. Those two fields will subtract from the quantity of your Pen Kits and Blanks that were added.
I find the Description field to be a useful place to keep the description I use for selling online. I just copy from here and paste into the online sales system.Add Completed Pens
In the image below I have 3 pen kits that were added so when adding a Completed Pen I’ll need to choose which one was used in order to subtract from the inventory.Select from Pen Kits already in the system
In the image below I have 2 blanks that were added so when adding a Completed Pen I’ll need to choose which one was used in order to subtract from the inventory.Select from Blanks already in the system
What is Pen Status?
I added this menu because not all the pens I make go online for sale and I found I was interested to know where a pen ended up. I made it a pick menu for consistency because the columns in the table view are sortable.Select a Pen Status
There isn’t much to the User Settings. As you can see:
- My email address
- Number of database entries
- Date I started using Pen Kit Inventory
- Delete button — THIS WILL DELETE YOUR ACCOUNT
- Change your password
Where can I get this Pen Kit Inventory?
I thought you’d never ask : )Get Pen Kit Inventory
Pen Kit Inventory is free. It should remain free for the foreseeable future.
I’m paying the bill for the server space, SSL certificate, and domain name. Who knows, maybe one day it’ll grow into something way more complex with connections to your Shopify or WooCommerce stores — oooh!!
There aren’t a lot of features and the application seems simple to me but I designed it for how it made sense for me to use so after you give it a try feel free to comment below and provide some feedback.
Thanks for reading!