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.
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.
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.
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.
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.
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.
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.
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.
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.
Where can I get this Pen Kit Inventory?
I thought you'd never ask : )
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!