Thanks for the clarification, all makes sense now.
Thanks for the clarification Mike, do you know at which version they became redundant?
I think I may have misunderstood your answer slightly, so each of the following SQL entries are calculated by WooCommerce?
_min_variation_price
_max_variation_price
_min_variation_regular_price
_max_variation_regular_price
_min_variation_sale_price
_max_variation_sale_price
Some of my variable products have these entries and others do not, very confusing
So _min_variation_price and _max_variation_price are calculated by WooCommerce?
How does WooCommerce determine if a product sale price is to be displayed? I have removed the sale price in the dashboard but the SQL database is still showing a sale price.