Former_Member
Not applicable

how do you keep track of product prices and your inventory?

tons of beads, chain, wire, sheet to keep track of where purchased, and cost per pc
how do you keep track?
i've mostly written on an index card, slipped inside a plastic bag w/ the product but if i just use 1 card, it can get separated from the product so i was thinking about doing two index cards and keep the 2nd one in an index file box..

i know there are software programs but i wanted something off the computer as i don't always have one around where i'm creating
Translate to English There was a problem fetching the translation.
0 Likes
15 Replies
Former_Member
Not applicable

Re: how do you keep track of product prices and your inventory?

For smaller items like buttons and trim I use zip loc bags and write everything on the outside in Sharpie marker. The heavier zipper like ones with the gusseted bottom are also good for bulkier items. Sharpie makes a click pen now that has a nice fine tip which is what I prefer.
Hope this helps.
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...

Re: how do you keep track of product prices and your inventory?

Ditto.
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...

Re: how do you keep track of product prices and your inventory?

I keep little sundries and findings in those plastic drawer cabinets put any pertinent info -- usually just what it is, who from and price on a little sticky tag and slap it in the compartment. havent had too many mis-id items, admittedly I only have about 80 drawers of findings and beads tho, so not too many to confuse.
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...
Former_Member
Not applicable

Re: how do you keep track of product prices and your inventory?

hi barney! sadly i'm in the process of accumulating entire retail stores inventory it seems. somebody take my charge card!
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...
Former_Member
Not applicable

Re: how do you keep track of product prices and your inventory?

Basically when I purchase packaged supplies I'll use Avery removable Print-n-Write labels to record right on the package what price I paid, the date, and a little code that represents where I purchased it, then put the packages up on peg board. Once the package is opened (or for loose purchased items) I use 4"x6" zipper top baggies. I put the little label on the outside of the package and inside I include a 3"x5" index card where I record the total number of pieces (or inchs) for the purchase price, how many pieces I've taken to use on which project, and if there were any damaged/unusable pieces. All of these go into 1 of those 12"x12"x4" scrap book crafting containers. For most beads I organize by color and seperated by glass, stone, Swarovski, and other inside the individual storage case. Each metal has it's own case regards of what the products is, and that I seperate by finding, bead, and other.

When I'm working on a piece I'll keep the entire package or baggie from each supply together in a different smaller storage box about the size of a basic bead board. Inside the small box I include a regular sheet of paper to write down any design specs or ideas as well as the list of "ingrediants and the supply price. This way if I'm side tracked and need to put the project aside I can return to it later and have notes on what I was planning to do and what the cost of supplies used already on the piece.
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...

Re: how do you keep track of product prices and your inventory?

Luckily I don't have to keep track of small items like beads, but for my materials I just keep the receipts and then enter them on an excel spreadsheet with the original # of items in the package. Then at the end of the year I just count what's left and then the difference is what I've used. Don't know if this will work as well for beads or not.
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...

Re: how do you keep track of product prices and your inventory?

I'm so terrible at tracking expenses that I actually spent like $250 on Jewelery Design Manager software thinking that would be a good investment. I used it about 3 times and got totally overwhelmed by the amount of time it required to log everything, and frankly it made me realize that even though I'm on the high end for Etsy with the type of jewelry I make, it's still way underpriced for retail, which was a little depressing.

If and when I take things to the next level, I'll have to keep better track, so I'll give it a whirl again at some point. It's pretty sophisticated, I got the version that would let me add photos, but I felt like I'd spend half my day just using the software. If you're an organization freak, though, you'd love it. Right now it's all I can do just to keep the prices attached to my beads, and trying to determine what my true materials cost is in a finished piece of silver jewelry I've cut from sheet & wire is nearly impossible, but that's my personal shortcoming - the math and organization piece.
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...

Re: how do you keep track of product prices and your inventory?

I have a price list that I made for when I gi to shows but I find myself looking at it when I'm home also. As for where I keep my stuff, I'm gonna say it's an organized mess. I know EXACTLY where everything is, but it ain't pretty. I've got a few containers in different sizes from the container store that I got on sale a while back to put everything in, but I'm afraid that if I do I won't know when anything is.

To make a long story short (too late) if doesn't have to be pretty, but as long as you know where everything is and how much it costs you should be fine...
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...
Former_Member
Not applicable

Re: how do you keep track of product prices and your inventory?

i have a whole retail store of supplies now lol. i do have a system down now that seems to be working... i keeping my small beads that started out in the 3 drawer sterilite cubes where they are sorted by color in their own small plastic bags.
they are on one 4 shelf wire bookcase, behind them is the exact 4 ft wide wire bookcase that i've hung plastic page protectors w/ individual sandwich size plastic bag of beads and chain. the page protectors that have multiple items say on top rt corner "chain" sterling silver" etc. they are hung on the wire grid w/ paper clips, easy to pull down.the is working well for my 10strand stone bead purchases
i've started using carbon paper, man that is hard to find! a dinosaur item...so i record on 2 4x6 index cards at the same time. top rt corner bead silver plate 2mm, lf top line where purchased and date
under neath that the product number and complete description. then number of pcs/cost and cost per pc..
1 card goes in the product bag, one goes in an index card file box by category... i would like to get a software program but as others have said that takes alot of time away from the other parts of the business

the finished product i will go back to keeping in plastic bags w/ notebook rings through the corner, separated by category... then i can flip through the bags quickly to find . i make up a item index card listing all components and where purchased, cost to make, time all the little things
on a side note, i'm really liking the early earring card punch i bought off etsy. the cards i'm using are scrapbook paper, i intend to attach a hanging earring card tab to hang them on a wire grid but they can also stand up in a box to flip forward..
out to the studio i go 8 days to get ready for a show
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...
Former_Member
Not applicable

Re: how do you keep track of product prices and your inventory?

I keep track of all my supply purchases on an Excel spreadsheet.

The date purchased, quantity purchased, price paid, unit price, and any other notes that I want to keep is all there. I also have a column to make a note whether or not I need to reorder.
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...
Former_Member
Not applicable

Re: how do you keep track of product prices and your inventory?

wow, ya'll are so organized!!

I thought I was doing good keeping all of my receipts in one place:)
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...
Former_Member
Not applicable

Re: how do you keep track of product prices and your inventory?

Steph, I'm with you! I need to be more organized.
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...

Re: how do you keep track of product prices and your inventory?

I used to put a note in a baggie with supplies, with cost and source, but since I've been selling supplies had to start tracking everything on an excel spreadsheet....I've found this works a lot better, even for my own personal stash of supplies for my jewelry making. Whenever I receive an order, everything goes on the spreadsheet as I unpack it.
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...
Former_Member
Not applicable

Re: how do you keep track of product prices and your inventory?

Steph from StephanieMakesAll says

wow, ya'll are so organized!!
-------------------------------------------------------------------------------

If one isn't organized, things can get into a real mess very quickly.
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...
Former_Member
Not applicable

Re: how do you keep track of product prices and your inventory?

*Shaking head in shame at how disorganzed I am... :P
Translate to English There was a problem fetching the translation.
0 Likes
Reply
Loading...
Reply
You must log in to join this conversation.
Remember that posts are subject to Etsy's Community Policy.