Matt, Pricelist works very well. If a product or variant has a pricelist, Odoo uses it on the Sales orders, if not it looks at the "Sale Price" field on the products or product variants.

All our pricelists records have "Apply to" set to "Product" and Product, Variant fields are provided for each record. This way all our items have a price. We have multiple pricelists for each item.

I think the "Sale Price" field on the products (and variants) was put there as a quick and simple way to set prices for those who do not want to dig into pricelists.

Pricelists work. Yep. But that's not the core. The thing is that we can not change the Sales Price of each individual variant of the product in inventory. The only way to do it is by using a tool not designed, and not meant for this purpose - pricelist. It's so irritating and basic I start to regret switch to odoo.

I have the same problem.

Matt,

Odoo is designed to take a simple price field for product and for variants BUT if pricelist is available, then it takes over and those fields are ignored. The intention must have been to give users who just need one price field a simple way to get what they need and for more sophisticated scenarios , the pricelists are used. I get it that the approach with variant price being added to product price is a bit ridiculous. It may be useful for some but not all users.

However, pricelist takes care of that. You CAN set the exact price per variant in the price lists (You can even have multiple pricelist records per variant if you want):

Select a product or Product Variant
Click on PriceList smart button then New
Select Apply To > "Product"
If product has any variant, you will see a new field "Variant" appear with default value "All Variants", change that to have your "Fixed price" apply to that variant only.

You can easily export the right columns, set prices, and import it back for mass updates. For new records, export a list of product variants first to get their external IDs , then make a new file to import into pricelist (with the ID of a pre-existing pricelist) and the prices you want, to set per variant prices. This will create a new record in price list for each variant.

Amir

Not everyone can use price list.
See here why:

https://www.odoo.com/forum/help-1/how-can-i-show-the-variant-prices-of-a-product-in-the-shop-list-on-the-website-shop-using-price-list-and-not-product-template-price-238260

Amir,

In short.

Odoo cannot show the Product variant price list in the Ecommerce.
So we cannot use Price list.