WP Ecommerce: Display the “Order Notes” as column in the Sales Log [closed]
You can use a small SQL statement to retrieve the notes: global $wpdb; $sql = $wpdb->prepare(‘ SELECT notes FROM ‘.WPSC_TABLE_PURCHASE_LOGS.’ WHERE id=%d ‘,$item->id); echo $wpdb->get_var($sql); Read more in this post