Database management of WP E-Commerce Purchase order and Admin order
I now have several WP E-Commerce stores and with each new site the settings, notices, e-mail addreses and purchase e-mails need to be customised to suit the new site’s branding.
Recently I noticed the admin and purchase orders that WP E-Commerce generates are partially stored in the database whereas others are stored in language file. My audience are predominantly English-speakers so out goes the need for language support and roll on the database management and slick custom Page Template to manage WP E-Commerce purchase order and admin order settings.
Instructions
- Open up phpMyAdmin and create the following new records in wp_options:
- wpsc_new_pending_order_fail = “We\’re Sorry, your order has not been accepted, the most likely reason is that you have insufficient funds.”
- wpsc_new_pending_order_success = “There is a new order awaiting processing: \n\r”
- wpsc_new_pending_order_subject = “New pending order”
- wpsc_new_pending_order_body = “Thank you, your purchase is pending, you will be sent an email once the order clears.”
- wpsc_new_order_pending_payment_subject = “Order Pending: Payment Required”
- wpsc_new_purchase_receipt_subject = “Purchase Receipt”
- wpsc_new_purchase_report_subject = “Purchase Report”
- Replace line #33 (starting with
if($purchase_log == null) {) through #47 with the contents ofpending-purchase-wp-e-commerce.txt - Replace line #221 (starting with
if($purchase_log['processed'] { < 2) {) through #227 with the contents ofpurchase-receipt-wp-e-commerce.txt - Replace line #270 (starting with
if((get_option('purch_log_email')...) through #274 with the contents ofpurchase-report-wp-e-commerce.txt
Generate several test purchases to ensure the database records match up in the e-mails and on the Transaction Results page then customise them to your needs.
Download
- Pending purchase e-mail for WP E-Commerce
- Purchase receipt e-mail for WP E-Commerce
- Purchase report for WP E-Commerce
- Custom Page Template coming soon…







hi, great idea. i wonder do you provide custom development service for this plugin. can we talk about what is the cost and time frame? waiting for your reply. thank you.
Hi Derrick,
I’ve sent an e-mail to you.