search  current discussion  categories  business - sales & marketing 

sales inventory

updated wed 22 mar 06

 

Kathy Rhoades on mon 20 mar 06


Hello, my names Kathy, and I'm a lurker! There I"ve said it and now it's out. I have posted a few times in the last 10 months giving my .00002 cents. worth of advice, etc. Now I have a question of my own. I have been selling my wares at a local venue for a short time now, things are starting to pick up a little. I'm trying to come up with an inventory system that makes sense so that I can keep track of whats been sold and whats still hanging around. I've looked in the archives and either I'm not wording my search properly or nothing is in there on this subject. I have begun a system of my own, but I'd like to hear what others are doing.

I really appreciate this venue of information and humor. I check it several times a day when I can, I read what is relevant to me at the time and skip over topics that will be of more importance to me as time goes by. I watch the banter through certain topics and wonder at the outcome but sense that there will be a civil ending, in most cases. It's a family!!!!! I don't agree with what your saying but I love you. You have the information wrong, but I love you. Your full of yourself, but I love you. Boy your an ass today, but I love you anyway. You've got the parents, the siblings, the cousins and the long lost cousins. A few illegitamate children here and there and some you never knew you conceived. Many are lurking waiting to reveal themselves as your aspiring children.

I'm done, thanks in advance for your thoughts and ideas
Kathy Rhoades in Pa where the sun is out but the temp is freezing.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Jennifer Boyer on mon 20 mar 06


One way is to set up computer based business bookkeeping software
that you use to record you checking account. I use Quickbooks which
allows me to set up items that I sell. Every time I take in income I
create a sales receipt on which I show exactly what's sold. I also
have "classes" that allow me to see how colors are selling in
relation to each other. I'm always amazed how I can't "guess" how
sales are going for certain items or colors: my own bias skews the
facts!! Quickbooks tells all and every year I weed out the low
sellers and come up with new ideas to try. I think it takes a year at
least to detect a pattern. You have to be patient and allow the data
to add up......I know Quicken is the cheaper bookkeeping software.
You just need software that allows you to define items. One thing I
don't like about Quickbooks is it doesn't let me sort a sales report
by best-to-worst sellers. I have to export the data to a spreadsheet
to do that. You could also set up this kind of system in a
spreadsheet or database.

Hope this helps
Jennifer
On Mar 20, 2006, at 12:32 PM, Kathy Rhoades wrote:

> Hello, my names Kathy, and I'm a lurker! There I"ve said it and
> now it's out. I have posted a few times in the last 10 months
> giving my .00002 cents. worth of advice, etc. Now I have a
> question of my own. I have been selling my wares at a local venue
> for a short time now, things are starting to pick up a little. I'm
> trying to come up with an inventory system that makes sense so that
> I can keep track of whats been sold and whats still hanging
> around. I've looked in the archives and either I'm not wording my
> search properly or nothing is in there on this subject. I have
> begun a system of my own, but I'd like to hear what others are doing.

*****************************
Jennifer Boyer
Thistle Hill Pottery
Montpelier, VT
http://thistlehillpottery.com
*****************************

Kathy Rhoades on mon 20 mar 06


Thanks Jennifer,
I did start a spreadsheet and I gave each glaze initials and each pot a number. I like the Quickbooks idea, never thought of using one of those programs, and it makes sense to go that route. I've made up my mind that I'm going to move slow and steady, figure out things instead of jumping in. So far I feel pretty fortunate to be able to sell what I've made, you know....if you make it they will come......and now that it seems to be moving forward I realize that I do need some kind of system. So I really do appreciate your input.
Thanks,
Kathy
Jennifer Boyer wrote:
One way is to set up computer based business bookkeeping software
that you use to record you checking account. I use Quickbooks which
allows me to set up items that I sell. Every time I take in income I
create a sales receipt on which I show exactly what's sold. I also
have "classes" that allow me to see how colors are selling in
relation to each other. I'm always amazed how I can't "guess" how
sales are going for certain items or colors: my own bias skews the
facts!! Quickbooks tells all and every year I weed out the low
sellers and come up with new ideas to try. I think it takes a year at
least to detect a pattern. You have to be patient and allow the data
to add up......I know Quicken is the cheaper bookkeeping software.
You just need software that allows you to define items. One thing I
don't like about Quickbooks is it doesn't let me sort a sales report
by best-to-worst sellers. I have to export the data to a spreadsheet
to do that. You could also set up this kind of system in a
spreadsheet or database.

Hope this helps
Jennifer
On Mar 20, 2006, at 12:32 PM, Kathy Rhoades wrote:

> Hello, my names Kathy, and I'm a lurker! There I"ve said it and
> now it's out. I have posted a few times in the last 10 months
> giving my .00002 cents. worth of advice, etc. Now I have a
> question of my own. I have been selling my wares at a local venue
> for a short time now, things are starting to pick up a little. I'm
> trying to come up with an inventory system that makes sense so that
> I can keep track of whats been sold and whats still hanging
> around. I've looked in the archives and either I'm not wording my
> search properly or nothing is in there on this subject. I have
> begun a system of my own, but I'd like to hear what others are doing.

*****************************
Jennifer Boyer
Thistle Hill Pottery
Montpelier, VT
http://thistlehillpottery.com
*****************************

______________________________________________________________________________
Send postings to clayart@lsv.ceramics.org

You may look at the archives for the list or change your subscription
settings from http://www.ceramics.org/clayart/

Moderator of the list is Mel Jacobson who may be reached at melpots@pclink.com.



---------------------------------
Relax. Yahoo! Mail virus scanning helps detect nasty viruses!

W J Seidl on mon 20 mar 06


Jennifer and all
It depends on the version of QB that you're using. I've used every version
since v.3. The new version (2006) allows you to sort report results based
on any field you choose. Might be time to upgrade, dear.

Best,
Wayne Seidl

-----Original Message-----
From: Clayart [mailto:CLAYART@LSV.CERAMICS.ORG] On Behalf Of Jennifer Boyer
Sent: Monday, March 20, 2006 1:24 PM
To: CLAYART@LSV.CERAMICS.ORG
Subject: Re: sales inventory

snip

One thing I
don't like about Quickbooks is it doesn't let me sort a sales report
by best-to-worst sellers. I have to export the data to a spreadsheet
to do that. You could also set up this kind of system in a
spreadsheet or database.

Hope this helps
Jennifer
On Mar 20, 2006, at 12:32 PM, Kathy Rhoades wrote:

Lauren Bellero on tue 21 mar 06


kathy rhoades wrote:
>I'm trying to come up with an inventory system that makes sense so that I can
>keep track of whats been sold and whats still hanging around

hi kathy,
i use an excel spreadsheet (very handy for sorting the data all kinds of
ways). the headings of my columns are:
ITEM#, IMAGE (this is a link to each individual image so that i can
see what pot it is -- yes, i photo every piece), DESCRIPTION,
YEAR MADE, PRICE, DATE SOLD, VENUE, BUYER, NOTES, TAX QTR

at times it is tedious, but so worth it for me since i often
require an external brain!
hope this helps.

all the best!
lauren
--
Lauren Bellero, Mudslingers Pottery
http://mudslingerspottery.net
Red Bank, NJ