Arts & Crafts Magazine

Why Create an Inventory Database ?

By Somanycolors
I've been making progress on my Inventory database-but slower than I expected. I have forgotten more database basics over the past 10 years than I thought. And I'm using a different database (OpenOffice Base-free!) than I worked with in the past (Lotus Notes.)
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:
  1. How much total yardage of each type I purchase each year
  2. What my cost per yard is including shipping and after shrinkage for each type
  3. What dyed fabric I have in inventory by type, including length, price and selling venue (I have 3)
  4. What I have sold, for what price and where
  5. What I have in remaining inventory, dyed and undyed, for tax purposes
  6. What sells the best by fabric type, color, venue.
Before deciding on a database I tried keeping records of what I bought and what I sold but that didn't tell me what I had on hand in dyed yardage. I calculated the cost per yard and used that in my pricing calculations but didn't think to include shrinkage. Come the end of the year I had to measure each piece of dyed and undyed fabric to come up with my inventory. And I have no good summaries of where the fabric sold, just exported lists from Etsy, ArtFire and my web site.
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.

You Might Also Like :

Back to Featured Articles on Logo Paperblog

These articles might interest you :

  • Tresemme Botanique Detox and Restore Shampoo | Review

    Tresemme Botanique Detox Restore Shampoo Review

    Tresemme BotaniqueLuckily, I haven't faced many issues with hair and I didn't bother much for a good hair care routine. 😄 My hair care routine was only oiling... Read more

    6 hours, 28 minutes ago by   Niharika Verma
  • Refrain


    It's always nice to experience something out of the ordinary in St Helens, and on this occasion it was quite extraordinary as I took to the streets to view a... Read more

    7 hours, 3 minutes ago by   Mike Lindley
  • Republique, the Pub & Terrace Lounge…!

    Republique, Terrace Lounge…!

    How many of you have that one favourite restaurant that you always visit because you know that nothing can go wrong with your food you are happy while... Read more

    8 hours, 12 minutes ago by   Anithanayak
  • Ragin' Ripple Sale Happening Now! Plus Steak, Doublestone and the New Thin...

    Ragin' Ripple Sale Happening Now! Plus Steak, Doublestone Thin Lizzy Tribute with Mothership!

    Time for a huge, ragin' Ripple sale!Let's clear some space in the warehouse for some new, killer releases comin' down the line.While supplies last: $5 CD's and... Read more

    8 hours, 12 minutes ago by   Ripplemusic
  • Berghaus Dragon’s Back Race 2017 – Day Two Review

    Berghaus Dragon’s Back Race 2017 Review

    Berghaus Dragon's Back Race 2017 - Day Two Review Start - Hafod y Llan Campsite Finish- Vanner Farm Campsite Distance covered - 58km Height climbed - 3,600m... Read more

    9 hours, 3 minutes ago by   Abichal
  • And Now for Something Completely Different

    Something Completely Different

    A Black Vulture (and a road-kill groundhog.) As I was driving to the grocery store on Monday, I saw a flock of these birds, maybe twenty, at the roadside and wa... Read more

    9 hours, 42 minutes ago by   Vickilane
  • Creamy Chive & Cheddar Dressing

    Creamy Chive Cheddar Dressing

    We have a bank holiday coming up next weekend and the good news is we are actually expecting some pretty decent weather with it! Salad weather! Yay! I love, LOV... Read more

    10 hours, 16 minutes ago by   Mariealicerayner