I make candles and bath and body stuff. I have way too many FO and I just thought I would add a little tip on how to keep them organized. I have several suppliers so sometimes it is hard. Here is what I do.
Using excel, I made a spreadsheet and listed all my fo's; a different sheet within the workbook for each supplier. On that spreadsheet I have four columns. First one is my stock number, second one is the name of the scent, third one is for the renamed scent and the fourth one is for the color, such as 2D blue and 1/4 B red (D= drops, B=block) P.S. You can hand write your list if you don't like computers.
For an example, I will use Natures Garden Candles Christmas Splendor, Hillbilly Home Brew and The Scent Works Pink Sugar and Head Over Heels In Love...so it looks likes this:
Stock- Fragrance- Renamed- Color
NG01 - Christmas Splendor- Santa's Rockin Sleigh Ride- 4D red 1/2 B red
NG02- Hillybilly Home Brew -Redneck Mulled Cider - 3D brown 2D red
On another sheet in the workbook
Stock- Fragrance- Renamed- Color
TSW01-Pink Sugar- Kenna's Kisses-1/2 B pink
TSW02-Head Over Hells in Love- Twitterpated-5D Red
Now on my FO caps, I took a permanant marker and wrote my stock numbers: NG01 on the top of the Christmas Splendor bottle, NG02 on the Hillbilly Home Brew, etc.
Sometimes the oils will get on the cap so I also put it on the side of the bottle. I also put the amount I paid per ounce so I know how much to charge for the particular item made with that scent. If you paid 5.95 for 2 ounces then you paid $2.98 per ounce. :shock: Must of been a real good scent, huh!
Then I went to Wal-mart and got two or three of the plastic see through file cabinets. The one that have the 2 little drawers and 3 or 4 big drawers (get the ones with wheels). I use the little drawers for my wicks, lids, caps, sprayers etc.
The big drawers were labeled with the names of my suppliers in alaphbetical order. Sometimes I had to share a drawer with two or three suppliers. After writing the stock numbers on the tops of all my fo bottles I just simply placed them in the appropiate filing drawer. (make sure they don't fall over or they may leak).
I made a copy of my spread sheet and placed it by my FO's. When I need a specific scent, I go to my list and find the number, go to the drawer and pull it out!
OMG, life is so much eaiser now. It took alot of work up front but it was a great help! I hope this helps others get creative and get organized! If you have any questions, just ask! :wink:
Using excel, I made a spreadsheet and listed all my fo's; a different sheet within the workbook for each supplier. On that spreadsheet I have four columns. First one is my stock number, second one is the name of the scent, third one is for the renamed scent and the fourth one is for the color, such as 2D blue and 1/4 B red (D= drops, B=block) P.S. You can hand write your list if you don't like computers.
For an example, I will use Natures Garden Candles Christmas Splendor, Hillbilly Home Brew and The Scent Works Pink Sugar and Head Over Heels In Love...so it looks likes this:
Stock- Fragrance- Renamed- Color
NG01 - Christmas Splendor- Santa's Rockin Sleigh Ride- 4D red 1/2 B red
NG02- Hillybilly Home Brew -Redneck Mulled Cider - 3D brown 2D red
On another sheet in the workbook
Stock- Fragrance- Renamed- Color
TSW01-Pink Sugar- Kenna's Kisses-1/2 B pink
TSW02-Head Over Hells in Love- Twitterpated-5D Red
Now on my FO caps, I took a permanant marker and wrote my stock numbers: NG01 on the top of the Christmas Splendor bottle, NG02 on the Hillbilly Home Brew, etc.
Sometimes the oils will get on the cap so I also put it on the side of the bottle. I also put the amount I paid per ounce so I know how much to charge for the particular item made with that scent. If you paid 5.95 for 2 ounces then you paid $2.98 per ounce. :shock: Must of been a real good scent, huh!
Then I went to Wal-mart and got two or three of the plastic see through file cabinets. The one that have the 2 little drawers and 3 or 4 big drawers (get the ones with wheels). I use the little drawers for my wicks, lids, caps, sprayers etc.
The big drawers were labeled with the names of my suppliers in alaphbetical order. Sometimes I had to share a drawer with two or three suppliers. After writing the stock numbers on the tops of all my fo bottles I just simply placed them in the appropiate filing drawer. (make sure they don't fall over or they may leak).
I made a copy of my spread sheet and placed it by my FO's. When I need a specific scent, I go to my list and find the number, go to the drawer and pull it out!
OMG, life is so much eaiser now. It took alot of work up front but it was a great help! I hope this helps others get creative and get organized! If you have any questions, just ask! :wink: