Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore Tweaks › Manual checkout to send-out Purchase Email › Reply To: Manual checkout to send-out Purchase Email
Exact copy and paste is not going to work here as you will need to populate the values of the variable.
For example this piece of code inserts the data into the database but you will need to fill in the values (eg. $firstname, $lastname):
global $wpdb;
$customer_table_name = $wpdb->prefix . “wp_eStore_customer_tbl”;
$updatedb = “INSERT INTO $customer_table_name (first_name, last_name, email_address, purchased_product_id,txn_id,date,sale_amount) VALUES (‘$firstname’, ‘$lastname’,’$emailaddress’,’$current_product_id’,’$transaction_id’,’$clientdate’,’$sale_price’)”;
$results = $wpdb->query($updatedb);
So basically you need to see what that script does then use the same logic to achieve what you want in your scenario.