News from the Pipemaking Workshop with the Funk.
Talbert Pipes Website - Kentucky Fried Popcorn - My Web Comic.

Tuesday, July 31, 2012

In need of a Web Boffin

Having just put together another website update, and spent some time updating our shipping fees as well, I've been looking into one other issue that I'd love to fix if possible. Paypal's payment buttons currently don't have any way of automatically marking an item sold on our site, so I have to mark each item manually. This is working time that I would love to not have to waste doing this, because it's a pain (Open Photoshop, find catalog item pic, add "Sold" text, run outline action, save, open Dreamweaver, upload pic to site, open item page, mark "Sold" in text, remove payment button... for every single item that sells...), and also it would be handier for buyers if items could be immediately auto-marked as Sold upon purchase.  What happens sometimes is that I'll post an update, then get back to work in the shop, and several people will all try to buy the same thing before I come back to the computer to see it's been sold and mark it accordingly.

From what I can (vaguely) comprehend from Paypal's tech help, the Paypal buttons can be set up to send some sort of acknowledgement to a script on your own page, which can include code to update a site database accordingly.  Now, everything in the latter half of that previous sentence may as well be Russian to me as I know nothing about scripting for sites or site databases.  So my question is, does anyone know of a good tutorial or system which could accomplish this auto-marking of sold items for me?  If it's not horrendously complex I could probably figure it out for myself if there are any plain English explanations available, and obviously it would be desirable to be able to fully understand and operate the system on my own.

My limitations are those of most one-man businesses - I don't have the time to take off a week for learning all about site databases, nor the money to pay a site guru.  Though I would be amenable to some sort of pipe trade if anyone was able to provide some help explaining and/or setting something like this up.  I know there are some shopping cart systems that do this, but those all cost money every month and that's something else I want to avoid - I like using the Paypal buttons because they're free and only pay to PP for items that sell, rather than hitting me with a $50/month bill AND credit card processing fees.  If anyone has any ideas or solutions for this issue, please give me a buzz or leave a comment.

Saturday, July 14, 2012

For New Pipemakers - The Boringness!

Whenever I am stuck for a post subject, one reliable default has been to write How-To articles about pipemaking.  This is usually interesting to everyone, has many pretty pictures, and helps spread useful information.  Today, however, I'm going to write a How-To that's specifically for newer pipemakers, and it's going to be dull as hell - No sexy workshop photos, none of that.  What I'm going to write about is how important it is to know...
A)  How long it takes you to make your pipes, on average, and
B)  What your average hourly wages are per pipe.

You have to know this because if you don't, you will go out of business unless you are so wildly overpricing your work that your income can easily accomodate your lack of planning.  Also, you need to know this because it's the only way you'll know if you're getting faster, and speed is important because as you learn to produce equally good results via more streamlined processes, that's more profit for you and more competitive edge in your pricing.  If you've never kept records of your average times on various pipemaking steps, you need to pay me $350 to come over and hit you with a rolled-up magazine, because it's that important.

Right now, my own records start off here:

I've got a great big Excel file that I use to track our income and expenses, and two pages of this thing are dedicated to figuring out how much time I'm spending on what, between our various types of pipes.  This can have a hugely beneficial effect - For example, for years I didn't make a lot of Ligne Bretagnes because they were lower in average hourly wages than our Talbert Briars.  I knew there was a pay gap there, and over time I calculated it down to my average wage per LB, AND what it needed to be to make equal money to a Talbert Briar.  With those figures in hand, I knew I had to raise prices, and also exactly how much, because I didn't want to overshoot or gouge anyone.  IIRC, I ended up raising the average LB price from something like $119 to $136 - A small jump, but just enough that it bumped the wages on them up to match the Talberts, and it enabled me to make a lot more of them each year.  Before, we made maybe 20-30 LBs a year.  Now, we do about 100-130.

That pic above shows my time measurements for the first stage of a typical handmade Talbert Briar.  If you're new at this, I'd suggest breaking these stages out a lot more - Measure your average times spent drilling (So you can later compare your averages via lathe drilling, drill press drilling, and hand drilling), shaping, measuring, etc.  The value of these initial figures will show up when you can accurately compare, say, the average times for 20 classical shapes turned on the lathe versus 20 freehand shapes styled by hand.  Over my 15 years at this, I've mostly worked out the kinks in my process so I have a good idea what's what, and these days I squish my steps into smaller lumps for a more overall comparison.

It does still help to keep track of times for blasts vs smooths vs rustics, though.  The part of this that will bite you in the ass is the nest step, which is tracking all of your OUTSIDE-the-workshop time for a particular pipe:

That's a bunch of extra time, there - From the photography of the pipe to the website catalog page write-up to the email inquiries, the actual selling of the thing to a buyer, the time it takes to pack it up and box it, all the way to the time spent driving it to the post office and writing Thank-You emails to your customer.  (And if you don't write Thank You letters to your buyers, you deserve to go out of business, but good customer relations is a whole other blog article...)  All that extra time has to be figured into the price of that pipe.

A couple of things you'll notice in that pop-up pic - I keep tabs on what percentage the "after workshop" work is to the total cost, and I also track possible wholesale wages based on easily adjustable wholesale discounts.  I found out two things early on - I can't afford to wholesale Talbert Briars to any dealer at the usual 50-60%, not without taking a whopping wage cut, but I can afford to wholesale Ligne Bretagnes.  The workshop times for the pipes are sufficiently smaller compared to the after-workshop time that if I can eliminate all that after-workshop time by selling 20 of them in one lump to a retailer, I actually make the same amount of money because of the time savings.  Ergo, now you know why we've been retailing LBs via Pipe & Pint these past couple of years!

The bottom line is, you have to know how much you're REALLY making, and then you have to use that to figure out how much you need to set aside each month for taxes, and what you'll have left over... So you know whether you really can afford that new car, or big-screen TV.  AND you'll know, as the years go by and your bills increase, how much more hourly wage you need to cover them, and just how much you need to raise your prices.

If you've read this far, congratulations!  Just by reading this, you've already demonstrated enough regard for the important parts of your business that you're 300% more likely to survive your first two fulltime years than the next guy.  Go forth and make pipes!

Oh, and I lied - Here's one sexy closing picture, at least.