Inventory program?
jim miles - Charlote NC
Anyone have suggestion for a good simple computer program to keep track of woodturning inventory. I'm selling maybe 100 pieces a year and need something better that a legal pad. Thanks
Knowledge You Can Build On — Est. 1998
Inventory program?
jim miles - Charlote NC
Anyone have suggestion for a good simple computer program to keep track of woodturning inventory. I'm selling maybe 100 pieces a year and need something better that a legal pad. Thanks
Spread Sheet...
Chuck Jones - West TN
A simple spread sheet using MS Excel or Open Office Calc is hard to beat.
A table in Word would be simple, too.
Charles Yawn
Re: Inventory program?
Rob Wallace
Hi Jim!
I agree with Chuck - for the past 4.5 years I've been using MS Excel to keep an inventory of the work I have out in the four galleries I'm selling through. With each submission of work for sale, the piece gets assigned an individual ID number by the gallery, and in addition to this, I record the date submitted, piece title, size, description (species of wood, etc.), selling price, and other information. I have individual sheets for each gallery; or I can combine them into a "master list", and then can sort the data in any number of ways: by gallery, what pieces are selling at what gallery, piece sizes or species selling most, etc. Helps determine "whats hot and what's not". When the gallery sends a payment sheet and check to me, I then record the pieces that were sold, I add the sale date and amount(s) to the spreadsheet, and if I want, at any time I can generate a "sold" vs. "on sale" list for the work I have out. At least twice in the past I have used my own inventory spreadsheet to document that I had not peen paid for an item that had been sold.
I also have a separate sheet for commissioned pieces to record this information separately. It's not a long list, but still can be useful to get an overall picture for production and sales.
The maintaining of an accurate inventory is very much worth doing.
Rob Wallace