how to get extra info from checkout in wp-ecommerce

Managed to figure it out. The pdf output code has this to get the normal field values: $form_sql = “SELECT * FROM `”.$wpdb->prefix.”wpsc_submited_form_data` LEFT JOIN `”.$wpdb->prefix.”wpsc_checkout_forms` ON “.$wpdb->prefix.”wpsc_submited_form_data.form_id = “.$wpdb->prefix.”wpsc_checkout_forms.id WHERE `log_id` = ‘”.(int)$purchase_id.”‘ AND `active` = ‘1’”; $input_data = $wpdb->get_results($form_sql,ARRAY_A); The there is a switch statement based ont he unique_name but as this is … Read more

insert order number into wp ecommerce order confirmation email

In the wp-e-commerce admin, Settings -> Store -> Admin, you can customise the Customer Purchase Receipt (confirmation email) template to add this, e.g. Please quote %purchase_id% as reference when paying by EFT. There are a couple of hooks in wp-e-commerce that let you insert other data into the confirmation emails: wpsc_transaction_result_cart_item — this is called … Read more