Bloke

But my Sites that are on 3.7 have not done any updates but my site at 3.8 went to 3.8.1

I was able to not show the description on the rest of the pages. Changed this line of the wpsc-products_page.php
if(wpsc_show_category_description() && wpsc_category_description()) :

to this:
if(wpsc_show_category_description() && wpsc_category_description() && wpsc_a_page_url() == '' ) :

But it still shows on the source of the page. So I guess I will need to ask in the Yoast SEO plugin forum

I always thought it was working because most of my products are unique to each category. But as I have about 900 products I have gone back to organize some in one category and noticed they don’t retain their order. You may assume its working say you have product #5 and it happens to be product #5 in the order also in another category. Then it would appear its sorting correctly but it is not. It is saving it to a field called menu_order so it will assign just one value here. Says its 5. But this will be wrong if it appears in another category also. I won’t want it to appear in position 5. So the order will be wrong. I tried moving a product and then going into the database to check the menu_order. Maybe since other products have a menu_order of 0 is the cause.

I got it figured out and here is how I did it in case anyone needs it because I cannot a free plug in that allows you to add the notes. Its helpful to add the order log notes to emails because when you resend the receipt to the customer it informs them of any changes.

In my theme’s functions file. I added.

function wpsc_get_notes($purchase_id ) {//$purchase_id

$purchase_log_notes  = $wpdb->get_var( $wpdb->prepare( 'SELECT notes FROM ' . WPSC_TABLE_PURCHASE_LOGS . " WHERE id = %d", $purchase_id ) );
return $purchase_log_notes;

And then I created a class that I adapted from what I found here https://gist.github.com/webaware/4964078.

class WpscExtendCustEmailNotes {
/**
* add filter hooks
*/
public function __construct() {
add_filter('wpsc_purchase_log_customer_notification_raw_message', array($this, 'customerMessage'), 10, 2);
}

/**
* intercept filter hook for customer notification message
*/
public function customerMessage($msg, $log_notification) {

global $purid;
$order_notes = wpsc_get_notes($purid);
$msg .= "\n\n" .str_repeat('=', 85) . "\n";
$msg .= "\n\n<strong>Order notes:</strong>";
$msg .= "\n\n$order_notes\n";
return $msg;
}
}

new WpscExtendCustEmailNotes();

I found the solution. I created a new class to extend the customer email. Using filter “wpsc_purchase_log_customer_notification_raw_message”. I adapted what I found here https://gist.github.com/webaware/4964078 and was able to get the sales log notes and attach them to the emails.

I found this and its close to what I am trying to do. He gives a list of item array keys at the bottom and I assume I could retrieve the notes.

Scroll to the second to last block of code. Just not sure if I would put this in my theme’s functions file.Get purchase log data

Or the example from whitelamps’ plugin

function purchase_log_add_up_included_tax($pln)
{
    $pl = $pln->get_purchase_log();
    $gwdata = $pl->get_gateway_data();
    $tax_included = 0;
    foreach ($gwdata['items'] as $item) {
        if (isset($item['tax'])) {
            $tax_included += $item['tax'];
        }
    }
    return wpsc_currency_display( $tax_included, array( 'display_as_html' => false ) );
}

I was thinking something something like this:

function get_notes()
{

    $data = $wpdb->get_var( $wpdb->prepare( 'SELECT notes FROM ' . WPSC_TABLE_PURCHASE_LOGS . " WHERE id = %d", $purchase_id ) )

    foreach ($data['item'] as $notes) {
        if (isset($item['notes'])) {
            $tax_included += $item['tax'];
        }
    }

}