Automated price update in Oracle fusion as per latest purchase

Summary:

With the annual price increases and tariffs, it would be convenient if the system would update the item master price for a vendor to the last price paid for that item to that vendor?

This would be more efficient as compared to a 1 by 1 manual update of many prices.

So, the request is - Is there a process or a spreadsheet upload that could take the place of the manual one by one update? 

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):