So I sat down and did what I always do when I'm confused. I write all out where I can see it! Once I can look at the big picture, all the pieces parts start to make sense!
I realized there were four categories of information I was trying to track:
The tabs of my four page spreadsheet
- Tracking: Where a listing was (and where it had been...I don't want to relist an item in the same venue when I just listed it there yesterday!)
- Listing: What did I say about that bead and did I remember to say it's annealed?? I can't tell you how I hate having to rewite listings after hastily deleted before pasting! I also need to know where the photos are on my computer or what they are called.
- Sales: Who bought what for how much? Did I ship it? Am I holding it?
- Groups: It's a PITA to look up the rules every time you list... So I made a list with links to the groups and basic rules I need to remember...like how many listings I can have in a specific group!
- Name: What I call the bead
- Page Listed: As you can see, I use abbreviations. LA = Lampwork Auctions. LBA = Lampwork Bead Auctions
- List Dates: Dates the listing was / is active
- Result: I track likability and comments by buyers to gauge whether I should relist or wait a bit. Notice none on this page are sold...more on that in a bit!
- Link: Hyperlink to the active listing. I delete when the listing is over as I don't want to accidentally paste the wrong hyperlink into a promotions photo on my fan page! Klutz prevention!
- When I get a bid or BIN, I write that in the results column and cut the name / Page listed / Dates / Results and transfer it to the SALES page. I then delete the enter line with the link to keep things tidy.
- When it doesn't sell, it gets highlighted and moved.
- About the colors: White is an Active Listing, Green means Go Relist. Yellow is expired and something I'm pondering... Move it another sales page, Etsy or my website.
This page only has two columns:
- Jpg names: the name of the photo on my computer. Alternately, I will list what file it's in.
- Description: The actual listing copy pasted into my Facebook listing. Tip for EXCEL: if you click in a cell and paste a listing with spaces in it... it pastes them in multiple cells. If you double click...it pastes all the formatting in one cell!
The Sales Page: Again, the first four columns are pasted from the tracking page. Then I add:
- Sold To: Buyer's name
- Contact: Have I found her Facebook contact info... did it go to the Other mailbox?
- Shipped: The date I mailed it.
- Price: The price they paid.
- Ship: The shipping costs I need to add (I give discounts for multiple items.)
- Total Sales: I add a little math widget to total my sales for a given period.
The Groups Page - Again, I use this to keep the hyperlinks to the groups home pages handy and to keep any rules I need to be aware of easy for me to find. That being said, some groups change their rules quite often.
Columns here are:
- Main link - hyperlink to home pages
- Listing numbers - How many active listing are allowed.
- Nutshell - Any rules I need to watch out for or actions I need to take.
This may be overkill but it's what I need to keep track of it all. I hope it helps you as well!
I have uploaded a blank version of my doc for your use ( I did keep the groups page intact... no need to put you through more research!). It will run on Excel.
If you enjoyed this tut and found it useful, please consider supporting the starving artist that wrote it.
My glass beads and tools are here.
My Starbucks account. Click the link and enter my card # 6044305060554270