WP eCommerce – get max variation price

I wanted to add a line of clarity

?I expected this: when the page loads, by default the highest price variation should display (the 15oz) not the 2oz

I created A fix not sure if its the best method, nevertheless I wanted to share it for the community and perhaps someone could expound on it.

<div id="single-product-price">
										<?php  //wpsc_the_product_price_display( array( 'price_text' => '%s' ) ) ?>
                                        <p class="pricedisplay">

                                        	<span id="product_price_<?php echo wpsc_the_product_id(); ?>" class="currentprice pricedisplay 10">

												<?php if (wpsc_have_variation_groups()) { ?>

													<?php
                                                        $product_price = get_highest_variation( wpsc_the_product_id() );
                                                        echo "$" . $product_price[0]->meta_value;
                                                        //echo var_dump ($product_price);
												    ?>
                                               <?php
													} else {
                                                		echo wpsc_the_product_price_display( array( 'price_text' => '%s' ) );
                                                	}
												?>
                                            </span>

                                        </p>
                                    </div>

put the below code in functions.php

function get_highest_variation($product_id){
	global $wpdb;

	$rst = $wpdb->get_results( $wpdb->prepare("SELECT
													pm.meta_value
													FROM (	wp_posts AS wpp LEFT JOIN
															wp_postmeta AS pm
														  ON
															wpp.id = pm.post_id) LEFT JOIN
														wp_wpsc_meta AS wpscmeta
													ON
														pm.meta_id = wpscmeta.meta_id
													WHERE
														(((wpp.post_type)='wpsc-product')
													AND
														((pm.meta_key)='_wpsc_price')
													AND
														((wpp.post_parent)='%s'))
													GROUP BY
														pm.meta_value
													ORDER BY
														pm.meta_value DESC
													LIMIT
														1"
													,
													$product_id
												));

	//echo $wpdb->last_query;
	return $rst;
	//echo var_dump($rst);
}

the break down
1. if product has variations
2. call function from functions.php and get max variation price
3. else (product doesn’t have variation)
4. echo wpsc_the_product_price_display( array( 'price_text' => '%s' )