I still think it is the right move. Here's why:
I buy many yards of fabric at a time, 20-50 yards, of at least 4 different types. Yardage is cut, dyed in 3 yard lengths and is then sold in full and partial yards. I want to know:
- How much total yardage of each type I purchase each year
- What my cost per yard is including shipping and after shrinkage for each type
- What dyed fabric I have in inventory by type, including length, price and selling venue (I have 3)
- What I have sold, for what price and where
- What I have in remaining inventory, dyed and undyed, for tax purposes
- What sells the best by fabric type, color, venue.
If I were buying piece goods (scarves, t-shirts) or were selling by the piece rather than by the yard I might be able to do this manually with several lists or spreadsheets. But, inventory rolls over from one year to the next. And I want more information, not just guesses, about what sells by fabric type, color, season and venue.
You may not need a database. For me, it is the only way I'll get the information I need going forward. I'm using January to get all of my 2010 purchases, dyed yardage and sales in order. No new fabric purchased until February-and since I really love dyeing, that will push me along. But I'm also really excited to know that I'll have a tool for building my business by knowing where it has been and where it is now.