Pricing Import for Single SKU on Multiple Listings

I am trying to import pricing CSV files to update pricing on our website. I am a reseller so I get a pricing file from a manufacturer with all of the updates and then transfer the data to a CSV to import. The CSV is 3 columns: SKU, Sale Price, and Regular Price.

Due to the nature of our industry, many single SKUs are used for a wide variety of applications and thus we have a single unique SKU listed on multiple variations and sometimes on multiple pages (for example: a bolt that is used on a Honda can also be used on a Yamaha so that one SKU for the bolt is listed on both the Honda hardware page and the Yamaha hardware page). I understand this is achieved through a php function and normally WooCommerce does not allow multiple instances of the same unique SKU.

When importing a pricing CSV I noticed it will only update the first instance of the SKU and ignores all other instances. Is there a way to have the import feature update all instances of a single unique SKU on the site? In the example above the import only updates the price for the SKU on the Honda page since it was published first even though the Yamaha page also has the exact same SKU listed.

I use the import feature as it saves countless hours of manually updating pricing, however, if it does not support duplicate SKUs I may need to find another option. With over 25,000 individual variations on our site finding the duplicate SKUs that did not get updated is like finding a needle in a haystack.

Thank you.