kandyking Posted May 6, 2012 Share Posted May 6, 2012 How do you guys keep track of your machines and what keys correspond with what machines? I engrave my machines with a unique number as soon as they are purchased and log the number and the type of key used in a spreadsheet that I made. I am hoping someone has a more efficient way to keep track of inventory and keys. Link to comment Share on other sites More sharing options...
havending Posted May 6, 2012 Share Posted May 6, 2012 You can buy labels on a roll at any office store. Invest in a keyed alike locks. Link to comment Share on other sites More sharing options...
PerformaVending Posted May 6, 2012 Share Posted May 6, 2012 All my machines have their serial number, I.D. number (that I assign) and my contact info engraved on the bottom, and on the inside of the unit. I put a lot of my I.D. stickers on all of them. I have a spreadsheet that tells me where all my machines are, with accompanying graphs and other useful information, including contact names, numbers, business hours, etc. on my laptop. My spreadsheet program of choice is Excel 2000. I have a mini notepad inside some choice machines (typically the last machine I service on a string) and record any service issues I have dealt with, or might have to deal with in the future. It's probably overkill, but for a route as small as mine, I can update the whole thing in exquisite detail in under 30 minutes. Link to comment Share on other sites More sharing options...
dkochan Posted May 7, 2012 Share Posted May 7, 2012 I built a database that tracks which machine, key code and product is placed at each location. For example: Location A: Northwestern Super 60 - Red: Gumballs, Key: NC705 Northwestern Super 60 - Red: 1.1" Sticky Mix, Key: NC705 Northwestern Super 60 - Red: Skittles, Key: NC705 Northwestern Super 80 - Red: 2" Treasure Mix, Key: NC705 Northwestern Super 80 - Red: 2" Pocket Pets, Key: NC705 Link to comment Share on other sites More sharing options...
Action Vending Posted June 10, 2012 Share Posted June 10, 2012 I have most of my locks that are keyed alike and from camlock systems, wiczer distributing is the best place to buy for me. They cost more but theres not a bunch of keys out there like stock keys nc 705 anyone who has ever ordered a northwestern machine probably has a nc 705 chicago lock keys are good for places with no competition or in a place like a break room where some one wont break into them. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.