Supplier Specific Pricing / Item (SKU) Updates

Our industry is very dynamic, we have easily 20% new items and 20% discontinued items every year or sooner as well as 1-2 price changes per year per supplier. We have over 100 Suppliers. 

So far we've been unable to find a way to easily upload new pricing from our supplier directly to cin7 without overwriting locally modified product names, Minimums, Reorder Qtys and other item specific data including family details. . 

In addition, we need to identify discontinued items so that they can be selectively deprecated once they are out of stock. (that's a separate Feature Request)

One of our employees wrote a rather crude java script to take the CSV file of the Brand from Cin 7 and compare it to the CSV file of the new price list from that brand, identify discontinued items, output them to a separate CSV File and Change ONLY the 11 pricing Columns Fixed Price through T10 without effecting anything else.

It seems to me this should be a function built in to Cin 7 Core. Maybe it is and I am missing it.

Suggestions ??