I was able to do this…in the end I used I used category descriptions and it was really easy to add custom content to an email by product.

For example I have a parent cat Events…and then I use sub cats for each event. So Events->Event 1. Then I added the content I needed sent with Event 1 as the description.

In your plugin I added 2 lines of code to class-haetshopstyling.php right after the below line of code (line 608 in my editor):

$params[]= array('unique_name'=>'#productstable#','value'=>$products_table);

My 2 new lines:


$params[]= array('unique_name'=>'catdesc','value'=>(get_term_by('slug', 'event-one', 'wpsc_product_category')->description));


This allows for me to add {catdesc} to my “Email Content – Payment Successful” template and it will display my description…html formatting and all.

I will need to add a line for each subcat, but this fits my needs for the moment. Obviously this could be improved upon with short code type functionality i.e {catdesc term=1}. Anyway hope this helps someone or gives you a cool idea on how to add a similar feature to your plugin.

No problem!

One additional note…while this will work for one cat description if you are trying to display multiple it will not…so I did have to write some additional code, including a select statement from the taxonomy relationships table so I could tell which category a product belongs to. Again, not every one will need something like this, but it is an easy ay to add additional content to an email. I am sure there is a more elegant way to code this, but I will put my additions here as well…Update the type-custom-taxonomy-name-here to be the product category name and the number ids to the ones that match for each cat.


$myprodid = $item['prodid'];
$mysql = "SELECT term_taxonomy_id
FROM ".$wpdb->prefix."term_relationships
WHERE object_id = ".$myprodid;
$mysql2 = $wpdb->get_results($mysql, ARRAY_A);
$mycatid = $mysql2[0]['term_taxonomy_id'];

if ($mycatid == 19) {
$params[]= array('unique_name'=>'my_catdesc','value'=>(get_term_by('slug', 'type-custom-taxonomy-name-here', 'wpsc_product_category')->description));
}
if ($mycatid == 16) {
$params[]= array('unique_name'=>'my_catdesc','value'=>(get_term_by('slug', 'type-custom-taxonomy-name-here', 'wpsc_product_category')->description));
}
if ($mycatid == 20) {
$params[]= array('unique_name'=>'my_catdesc','value'=>(get_term_by('slug', 'type-custom-taxonomy-name-here', 'wpsc_product_category')->description));
}