What is your process in automatically updating Price Lists?

Hello Everyone,

This is more of a question for the entire community regarding price list updates in Netsuite and the related processes.

Currently we have MANY price lists in Netsuite - below is a sample but we have about 40 lists all together. Some are basic price lists that im sure most customers use like MSRP and distributor costs. We also have some very specific price lists for specific customers , like Ferguson below.

Throughout the year, we have price updates we receive from our Corporate factory. All our pricing calculations are handled via Excel. We calculate all margins for all our price lists then import into Netsuite. We could have 1 or several price updates throughout the year. And we go through this very manual price update process every time.