Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

Reply To: Manual checkout to send-out Purchase Email

by

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

January 22, 2010 at 2:36 am #17364
amin007
Participant

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.

Forum Related

  • Forum Home
  • Forum Search
  • Forum Registration
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2025 | Tips and Tricks HQ