Chuckle....I worked at Mary Kay on a three month contract in the IT dept.
It took literally millions of dollars and hundreds of people to keep track
of the corporate production and inventory systems....
Back on topic:
Do you want to use a spreadsheet as indicated in your subject line, or a
database, as indicated by the newsgroup you posted in? Do you have a copy
of Access (part of Office professional) on your PC?
I have been using a program called mymkinventory (http://www.mymkinventory.com) to keep track of my Mary Kay inventory and I don't know how I got along without it. They keep the product updated and all you have to do is enter your quantities. I even use my cell phone to check my inventory levels because they have a mobile app too! I hope this helps!
My girlfriend and several of her Mary Kay friends use a program called "qtinventory" (www.qtinventory.com)
It handles your inventory, customers, datebook... everything. I know she likes it because she can create an invoice and it pulls from the inventory and creates a reciept for her customer...
It does a lot of other things too, like product history, follow ups ect....
Looking for help with your MK inventory? UnitWise has you covered.
It's got automatic inventory updates straight from Intouch. As soon as new products are released, you'll have them over night--no quarterly update fees or downloads necessary. Then when you create an invoice, products will come out of the inventory, and when you receive an order, they'll get put back in. Cool huh?
That's just a fraction of what's on offer at UnitWise too. You also get customer management, money management, time management, email marketing tools, a full-featured customizable website, and so much more.