In an earlier blog post, I talked a little (ok, a lot) about my inventory tracking system that I was setting up on Excel. I thought today I would post some photos showing how I organize my fabric and how I came up with my shelf-naming system which is being input into my Excel spreadsheet.
Just to back up a bit, I actually thought for awhile about how I was going to do this. However, the system is so easy, you're probably wondering why I spent any time thinking about it at all. In any case, here's what I came up with:
If the shelf on which the fabric is stored is a metal shelf, it gets the leading letters MS. If it is a wood shelf, it gets the leading letters...drum roll, please...WS; plastic shelves get the leading letters PS and so on. I even have a BS designation which is for fabric piled onto stacks of boxes!
Since I have a few sets of metal shelves, each shelf gets a unique number, so that I have MS1, MS2 etc. And I have one large set of wood shelves which get the designations WS1 and WS1B, WS2 and WS2B, etc (the Bs are on the right hand side, as shown in the photo below):
[My shelves in this example get named WS (wood shelf) follwed by a number. The letter B is added after the number, for shelves on the right side.]
Here is another view:
Another method of storing my fabric is to hang them on hangers in my closet, as shown in the photo below. Fabrics stored this way get the Excel entry CH1 as their location:
[The location for these fabrics is CH (closet hangers) follwed by the number ONE (1).]
And finally, here is a screen shot of my new and improved Excel spreadsheet which has already saved me tons of time looking for fabric that has sold:
[Column A shows the stock number for each individual piece of fabric. Column C is where the location is recorded. This makes it easy to quickly locate any fabric in order to ship it to the buyer.]
Depending on what items you have to keep track of, a shelving system like this may not be practical. However, you can use these same principles for storing items in drawers or plastic tubs. Do you have an easy way to quickly locate items in your inventory?