Feeds:
Posts
Comments

Posts Tagged ‘Listing your craft stock’

Wecome back.

Today is a tutorial for anyone wishing to list their craft collection in more detail than yesterday’s images. Amend this idea to suit your own type of craft products. You are free to use this idea for your own personal use but this is my own concept, so please do not re-sell the idea as your own!

Detailed stash listing

If you need to keep track of the value of your craft stash, then the following is a way of doing so. For this project you will need;

  • A ring binder;
  • Paper;
  • Page protectors, and page dividers, if desired.

The first thing to consider would be, is it important for you to know how much you spend on different aspects of your crafting? If it is, then you will need to divide your folder up into the aspects that are of particular interest. For example, do you want to separate rubber stamps from the rest of your products or tools separate from consumables etc.? If you are just looking to have a good idea of what all your stash is worth then it isn’t necessary to divide your folder up. 

How much detail do I need to go into with this listing?

Again this is entirely personal preference and depends on what you are listing all this for. I tend to list as much information as possible, as it is often useful to know where you got a product from, especially if something wears out and you want to replace it. If that level of detail is not required then record what information you require.

So how would all this look on a page?

Here is an example of how I would enter my new Willow coloured ink pad onto my detailed list.

Brand;     Ranger
Range;    Adirondack Lights
Code;      ALP07319 (this was found on the back of the ink pad)
Product;  Ink pad
Type;      Dye Ink
Size;        Large pad
Date;       20 Feb 2008
From;       (shop name)
Price;       £4.49

Everything in the first column shown above would be the titles for your columns.  This gives you a universal page that can be used to list all types of products. If you are handy on the computer, you can print your own pages using Word or similar word processing package. Insert a table and enter the column headings as listed above. Save this on your computer and you can print additional sheets as required.  Go for a landscape page as this will give you much more room for all the headings.

Brand Range Code Product Type Size Date From Price
Ranger Adirondack Willow ALP07319 Ink Pad Dye Ink Large Pad 20 Feb 2008 (shop name) £4.49

If you prefer a more computer based approach consider listing in something like Excel, as this then gives you the option of having the computer add things up as you go.  The only issue I have with that option is that you then need to start up your computer to list anything. For me it is quicker to use the folder, as it is just there on the shelf. Having said that, if you have lots of time and need a back up copy of this listing in case the worst happens, you could copy the detail from your paper list into Excel.

I can’t bear to think how much it is all worth

That’s ok, for those of you who prefer denial (just kidding) rather than keeping a running total, just add up your totals per page and write them at the foot of each page. If you have another half who needs to know these figures for insurance reasons and telling them wouldn’t end a marriage (hehe), then they can add up the page totals to record totals where they need to.

What about new items?

Each time you buy something, you simply list it in the folder before storing it, so it really doesn’t take long. You will have the receipt for prices and shop name and the product in front of you for its details.  If you wish to do this listing for all your stash, you won’t have prices, shop details or dates. Estimate dates – just put in a year for example. As for prices, look up your product either in your local store or online to give you a price. As for shop details, if you remember, great; if not, well that information is really only useful if you wanted to buy replacement items.

 

I think that’s more than enough for one day;  thanks for reading and check back tomorrow for design tips.

Best wishes

Billie

Read Full Post »

Follow

Get every new post delivered to your Inbox.

Join 249 other followers