Page 1 of 3 1 2 3 Last
  1. #1
    Senior Member mel0622's Avatar
    Join Date
    Sep 2005
    Location
    Las Vegas, NV
    Posts
    955

    How do you keep inventory on your mac?

    how do you do it? do u keep a list? i wanna do mine i'm using microsoft excel but wanna know if theres a better way to do it.
    "Elegance doesn't mean being noticed, it means being remembered." -Giorgio Armani

    http://www.myspace.com/7046107

  2. #2
    i keep my eyeshadows through a list on microsoft excel. its so easy

  3. #3
    Senior Member caffn8me's Avatar
    Join Date
    Sep 2005
    Location
    London & Oxford, UK
    Posts
    2,745
    I use Open Office's equivalent of Excel. My inventory has been getting quite a bit of updating in the past three days

    I have my "wish list" on a separate spreadsheet and I rate things by a priority of 1 to 3. 1s I must get before I buy 2s and 3s.
    Sarah - Flying M·A·Caholic

  4. #4
    Senior Member Brianne's Avatar
    Join Date
    Apr 2005
    Location
    Virginia
    Posts
    371
    I use Excel.

  5. #5
    Junior Member misslexuh's Avatar
    Join Date
    Dec 2005
    Location
    Muncie, IN
    Posts
    11
    should i start keeping an inventory now?? how will it help me in the future??

  6. #6
    Senior Member MissMarley's Avatar
    Join Date
    Oct 2005
    Location
    Midwest
    Posts
    1,030
    I use excel for inventory and I just use word for my "wishlist"
    Blessing someone does not always mean agreeing with them....


    Read my blog!
    A Deeply Superficial Person

  7. #7
    Senior Member mel0622's Avatar
    Join Date
    Sep 2005
    Location
    Las Vegas, NV
    Posts
    955
    so when u use excel its just basically a list?
    "Elegance doesn't mean being noticed, it means being remembered." -Giorgio Armani

    http://www.myspace.com/7046107

  8. #8
    Senior Member caffn8me's Avatar
    Join Date
    Sep 2005
    Location
    London & Oxford, UK
    Posts
    2,745
    Quote:
    Originally Posted by misslexuh
    should i start keeping an inventory now?? how will it help me in the future??

    It can help you in a number of ways: You can use it to plan future purchases. If the worst comes to the worst and your collection gets stolen or lost you can use it for insurance purposes. Insurers may not be inclined to believe your makeup collection is worth as much as you say it is but an inventory can back up a claim.

    I use a spreadsheet for my wishlist so I can work out exactly how much things will cost and plan my spending within my budget.
    Sarah - Flying M·A·Caholic

  9. #9
    Senior Member angela's Avatar
    Join Date
    Jun 2005
    Location
    Bay Area, CA
    Posts
    410
    Quote:
    Originally Posted by caffn8me

    I have my "wish list" on a separate spreadsheet and I rate things by a priority of 1 to 3. 1s I must get before I buy 2s and 3s.

    omg that's exactly what I do! great minds think alike! i love having a seperate wish list and listing items in order of priority.. it really saves me time wandering around the counter! I swear its soo easy to get distracted when you're shopping for MAC, but if I have my list with me, it'll keep me from getting side tracked and keep me from spending more than what I intend to!
    get ur MAC on

  10. #10
    Senior Member mel0622's Avatar
    Join Date
    Sep 2005
    Location
    Las Vegas, NV
    Posts
    955
    Quote:
    Originally Posted by angela
    I swear its soo easy to get distracted when you're shopping for MAC, but if I have my list with me, it'll keep me from getting side tracked and keep me from spending more than what I intend to!

    exactly! lol i always go to mac w/ a list. if i dont know i'll spend more than i have. haha.
    "Elegance doesn't mean being noticed, it means being remembered." -Giorgio Armani

    http://www.myspace.com/7046107

  11. #11
    Senior Member caffn8me's Avatar
    Join Date
    Sep 2005
    Location
    London & Oxford, UK
    Posts
    2,745
    Quote:
    Originally Posted by mel0622
    so when u use excel its just basically a list?

    My inventory spreadsheet has the following columns from left to right;
    • Total quantity of a particular product owned
    • Product type (e.g. 'Lipstick', 'Cream Colour Base', 'StudioFix')
    • Shade
    • Retail price
    • Retail price multiplied by total quantity owned
    • Quantity carried in my knapsack and traincase
    • Value of item carried in knapsack or traincase.

    Everything is totalled up for my entire collection and that part of the collection which goes out on the road in my train case or knapsack when I'm doing makeup for other people. This means that at any time I know how much the retail replacement value of the knapsack and traincase would be in the event they got stolen. Because all the calculations are done by the spreadsheet it updates itself automatically when I add new items to my inventory. The total for just my knapsack comes to £1,883.53 at the moment - which works out at about $3,256. Knowing that makes me much more careful with it!
    Sarah - Flying M·A·Caholic

  12. #12
    Senior Member aziajs's Avatar
    Join Date
    Oct 2005
    Location
    USA
    Posts
    5,920
    I honestly just keep a mental inventory.
    My Blog:Beauty in color || Beauty of color

  13. #13
    Senior Member caffn8me's Avatar
    Join Date
    Sep 2005
    Location
    London & Oxford, UK
    Posts
    2,745
    Quote:
    Originally Posted by angela
    omg that's exactly what I do! great minds think alike! i love having a seperate wish list and listing items in order of priority.. it really saves me time wandering around the counter! I swear its soo easy to get distracted when you're shopping for MAC, but if I have my list with me, it'll keep me from getting side tracked and keep me from spending more than what I intend to!

    What I do is copy and paste from my wishlist into a brand new "shopping list" which just shows the items I want to buy that day and the price I expect to pay for them including discount. It's all totalled up and I print it out and hand it to the assistant. That way I'm much less likely to be distracted and end up with things which aren't really a priority or things I can't actually afford!

    As time goes by I see the outstanding value of my priority 1 items going down steadily and I feel like I'm making real progress My priority 1 list is currently at about £190 and it started at over £500. My priority 2 list has a value of £126 and my priority 3 list comes in at £335. Occasionally as I gain skills and experience I will reevaluate the priorities of items still outstanding and change them to match my actual needs more closely.
    Sarah - Flying M·A·Caholic

  14. #14
    Senior Member asnbrb's Avatar
    Join Date
    Jul 2005
    Location
    aiea, hawaii
    Posts
    653
    God, I need to start keeping a list. I had one on Access, but it BADLY needs updating.

  15. #15
    Senior Member ledonatella's Avatar
    Join Date
    Jun 2004
    Location
    Ohio
    Posts
    793
    I just keep a basic list on my MS Word, it just lists type of item, brand & shade name
    "You can't have the femme without the fatale....." ~ Madonna

  16. #16
    lol I'm so not fancy. I just keep a list on Word, with purchases for each month, where I got it [ie. Dillard's, online], and who paid for it [mom, Christmas present, etc.]. I keep a running total, sans taxes and just write it next to the final item on the list.

  17. #17
    Senior Member Julia Vanhorn's Avatar
    Join Date
    Dec 2005
    Location
    Georgia
    Posts
    224
    I do my inventory on Excel as well. First I would put them in three catagories: eyes, lips and face. Then I would break it down into the type of product that it is, for example: eyeshadows, paints, pigments, and eyeliners. For each catagory I would list all the items. Each item that I have I would have the shade name, texture of product, batch number (just to get an idea of how old the product is), if it is a limited edition, and the date that purchased it on.

    I might go back and change it a little if I feel that I need more information on it.
    There is a reason why Make-up Artists uses the initials "MA", it stands for "Makeup-addict Anonymous" Is being a Drag Queen an excuse for dramatic make-up? -Love, the MAC Queen

  18. #18
    Senior Member merleskaya's Avatar
    Join Date
    Jan 2006
    Location
    STL
    Posts
    150
    I have a Palm and created a document in Memos titled "MAC". I have items listed by category, and then by color (Paints--Canton Candy, Untitled, Shimma, Mauvism. In the Lipstick category, I have the colors subdivided into Amplified, Frost, etc.) I also note in parentheses whether a shade is LE or d/c. At the bottom of this document I have a wish list with colors I'm interested in trying.

    I can sync between my Palm, which is always with me, and my computer at home...my main reason for doing it is to keep track of what I want and avoid buying colors that are too similar to shades I already have. (I get into trouble with pink shadows and red lipsticks.) I also like being able to "glance" at my collection!

    merleskaya

  19. #19
    Senior Member Viva_la_MAC_Girl's Avatar
    Join Date
    Jul 2005
    Location
    Arizona
    Posts
    1,226
    I use Excel spreadsheet, and then I have Documents to Go .. for my Palm .. so if im out I have it to reference to... ( lol i'm a nut )

    I have mine like this ..

    Eyeshadow.. ** By Finish **

    Brushes .. ** by if they are for eye, lip, face.. ect **

    Lipstick .. by finish

    and so on.. its all alphabetical ( of course )

    If you need help setting it up let me know I would be happy to - just send me an email!
    "I never think of myself as an icon. What is in other people's minds is not in my mind. I just do my thing.â - Audrey Hepburn

  20. #20
    Oh NO I don't need a list! That's all I need is somethig showing me how much I have!

    I go through my m/u enough to know what I have. If I did do a list I would do it by category probably in excel or place it somewhere online.

  21. #21
    Senior Member Turbokittykat's Avatar
    Join Date
    Mar 2005
    Location
    Hampshire, UK
    Posts
    528
    I keep a complete list of my MAC collection, (just MAC, no other brands), on my iPAQ organiser. I first created it after a couple of incidents where I accidentally bought duplicates of items I already had. I recently used it to estimate the total retail cost of my collection and I didn't like the result very much!

  22. #22
    Senior Member Julia Vanhorn's Avatar
    Join Date
    Dec 2005
    Location
    Georgia
    Posts
    224
    You know for the longest time I swore that I had White Frost e/s (I had this one for two years) then after I did this inventory a week ago, I discovered that it was Chill and not White Frost. I don't know how I missed that one for two years. And no, I am not blonde, just a DBID.
    There is a reason why Make-up Artists uses the initials "MA", it stands for "Makeup-addict Anonymous" Is being a Drag Queen an excuse for dramatic make-up? -Love, the MAC Queen

  23. #23
    Senior Member xiahe's Avatar
    Join Date
    Jun 2005
    Location
    Cleveland/Akron, Ohio
    Posts
    1,167
    i use excel, even tho my collection isn't hard to keep track of...it's so tiny.

  24. #24
    MS Access is great for a MAC inventory!!!

  25. #25
    Senior Member MisStarrlight's Avatar
    Join Date
    Jan 2006
    Location
    Upstate, NY
    Posts
    931
    Wow, you guys are waaaay organzed. I know I should start keeping a list, but I know that I'd never keep up with it. I seriously give half my paycheck back to the company every week.

    With this new year, I've started keeping my receipts though. My accountant said he'd let me write off my MAC this year, but next year I'm gonna have to prove it. (He didn't believe I could have spent that much on makeup in 1 year). It doesn't help with inventory, but it's a good thing to keep in mind.
    "Dorks die when bullets hit them. Dorks cry real tears"~Kathleen Hanna

  26. #26
    Junior Member nenalinda27's Avatar
    Join Date
    Jan 2006
    Location
    Long Island
    Posts
    28
    I keep an excel spreadsheet of what I have and want. Or else I forget and buy doubles. My phone also has a little notepad option, so I'm able to keep a list of my most wanted items at all times. Cuz you never know when you'll end up in the mac store.

  27. #27
    I use excel to take note of all my items and for my wantlist, I just keep it in my head LOL.
    Dimpled chin, devil within.

  28. #28
    Senior Member LineausBH58's Avatar
    Join Date
    Mar 2006
    Location
    NYC area
    Posts
    838
    ohh i want to do this..... i think i willl next weekend when i'm off from work

  29. #29
    Member thejadedstar's Avatar
    Join Date
    Feb 2006
    Location
    Metro Philadelphia, PA
    Posts
    46
    I keep a website (on geocities at the moment) that I can update easily with my new MAC products. I have them organized by type, and also have my own system of notation so I can tell if a product is part of a quad or pallett, or if its a sample. It ends up helping me a lot when I'm trying to work out a swap or a purchase, because I have the entire contents of my collection right in front of my face. I resorted to this because I kept buying doubles of items that I already had. I use MUA for a wishlist/shopping list, just because it's easier.
    [color=Magenta][color=Magenta][font=Lucida Console]Fat and Fab : I embrace my inner drag queen!

  30. #30
    Member ladycandy's Avatar
    Join Date
    Aug 2005
    Location
    Australia
    Posts
    50
    Quote:
    Originally Posted by caffn8me
    My inventory spreadsheet has the following columns from left to right;
    • Total quantity of a particular product owned
    • Product type (e.g. 'Lipstick', 'Cream Colour Base', 'StudioFix')
    • Shade
    • Retail price
    • Retail price multiplied by total quantity owned
    • Quantity carried in my knapsack and traincase
    • Value of item carried in knapsack or traincase.

    Everything is totalled up for my entire collection and that part of the collection which goes out on the road in my train case or knapsack when I'm doing makeup for other people. This means that at any time I know how much the retail replacement value of the knapsack and traincase would be in the event they got stolen. Because all the calculations are done by the spreadsheet it updates itself automatically when I add new items to my inventory. The total for just my knapsack comes to £1,883.53 at the moment - which works out at about $3,256. Knowing that makes me much more careful with it!


    i love this idea!!
    Hope you don't mind if i borrow it!!

Page 1 of 3 1 2 3 Last

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •