This may be easier
I just think its easier since your site is dynamic to create a wholesale subdomain and use the column wholesale price as the value when they log in to avoid some more time consuming steps. At least that is what I would and make it just restricted to those who are wholesalers. Easy enough because I try not to get too techy, I not advanced but I get the job done.