This is a major hindrance to using partner pricing. We have a database that we have been keeping up to date for years via Excel imports. No real easy way to switch to partner pricing except one product at a time.