Taking Inventory
Are there any programs out there for Stampers Inventory?
|
anyone have any clever ideas for inventory on the computer?
|
I have to be honest - I just took my internet orders and moved them over to Excel and that decided my categories. Then I added pictures from their sites. At the moment they are sorted by manufacturer however I hope to add categories and I also need to add my stamps that I bought at shops.
I didn't see any need to re-invent the wheel and that is why I went with copying and pasting. HTH at least a little bit. |
This is something I need to do. But I think as I clean out my stamp room. I will make a list of all the Stuff I have. Then put it on my computer.
Listing all the TAC stuff I have, SU stamps and paper, supplies. Clear And simple stamps sets. Magazines and so forth. I'm still in need of re-doing my Craft room. |
I keep my materials (non disposable, e.g. stamps and tools) in an Excel document. That can be handy.
My supplies (disposable, e.g. ink and paper), I don't worry about. I tried that, but it was more frustrating than benefical. I'm the kinda person that has to follow through in detail if I'm going to do something. For me, that meant feeling obligated to run to my computer everytime I used a couple sheets of paper so that my inventory was current. Ugh! |
I also created an Excel spreadsheet. I started it just for my SU! stuff but then decided to list everything in my craft room for insurance purposes. I have a tab for the following:
SU! sets/wheels - Name, Product #, Price, Hostess set or not, Catalog, Page, and Year that it retired Inks/Coloring Implements: Name, Product #, Price, Company, Catalog (if in one), Page, and Year it retired Non-SU! stamps: Name or description, If it is a set or not, How many images, Price, Theme, Company, Catalog, Page Books/Magazines: Name, Date, ISBN #, Price, Theme, Company Tools: Description, Price, Theme, Company The prices I listed were what it would cost to replace the items (if possible) not what I actually paid for them due to my SU! discount and coupons/sales for Non-SU! stuff. I will not tell you how much it added up to but my husband was a bit shocked.:D I do not keep an inventory of consumables (papers, embellishments, yarn, etc.) The hardest part was putting everything in to begin with it. Very time consuming, but I would just bring a catalog or a stack of items and enter the info. If I didn't have a price or name, I'd look on the internet at company websites or do a search for the item to find info on it. Now when I buy something new, I immediately put it in the spreadsheet before taking it to my room. Best of luck on finding and inventory process that works for you. |
I've got a very simple database set up in Access which I've been filling in as I get to each shelf in the craft room. (Trying to re-organize, lol!)
I like Access better than Excel mostly because I learned database before I learned spreadsheet so I am much more comfortable doing searches on Access. I like that I can pull up all my stamps that are "sentiments" or all my "scenic" or whatever- so, obviously I have a "stamp type" category. I really like the way a database sorts. Whatever you choose, it's not hard and very helpful when you have a lot of stamps. |
Quote:
|
All times are GMT -8. The time now is 10:40 PM. |