Is there a way, not using the variant prices, to handle the sale price of products on the variant level? Anytime we change a product variant's price, every variant is changed. Variant Prices is not a viable option since the process to update variants on a large scale is not realistic. The price list is currently not searchable and importing and exporting it every time to update prices does not make sense.

EXAMPLE:

Product: Medal A

Attribute {Variants}: Metal {Silver, Gold Filled, 14kt Gold}, Size {Small, Medium, Large}

Sale Price:

Medal A Silver, Small: $10

Medal A Silver, Medium: $18

Medal A Silver, Large: $23

Medal A Gold Filled, Small: $21

etc... 

There is no real pattern or easy equation to use to apply on these products sale prices. We have this same setup for roughly 9000 medals. We get a list of individual items and prices from the supplier we need to update and would be easier to do in a single file upload to product variants and not on each item. 

EDIT: the price difference from silver to gold on Medal A is not the same on Medal B, C, etc. the same is true with the size. Each product variant has a distinct sale price from the supplier and a pattern cannot be created from what we are given. These prices cannot be altered since they come prelabled with prices. We need Odoo to reflect what is on these tags.

Using individual sale prices on product variants helps to clean up the website since customers can search Medal A and see all options and prices on one page and not have to click around, or have to scroll through 20000 variants on the site to find the one they want. 

Odoo V10 Enterprise, Ubuntu 16.04 (moving to V11 when available for upgrade, but would like a solution now.)