"Must have experience with the Home Depot vendor system"
I mean, what if someone fulfilled all my "musts"?!? That'd be the perfect person.
But you hardly ever find rock stars. And so you hire the best person who doesn't have all the required skills. Don't let job requirements stop you from applying. And don't think that I'm being unrealistic for asking for what I probably won't get.