WordPress.org

Forums

WP eCommerce
Retrieve order details after transaction with mysql_query(); (2 posts)

  1. lsatdown
    Member
    Posted 1 year ago #

    WPSC Version : 3.8.14.1
    Theme - Custom

    Issue:

    After a transaction has been successfully placed on wpsc-transaction_results.php, i'm trying to retrieve the customers order details to carry out further calls to other API's. So I need to get all the order and customer details. I've scrambled the below together from various forums, however it's in-consistent and since upgrading from 3.8.14.0 to 3.8.14.1, the mysql_query() call isn't returning anything.

    If anyone has any better, more reliable solutions to getting a customers order after a successful transaction, please let me know!

    Thanks

    Code:

    // Get order id
    $billing_details = wpsc_get_customer_meta();
    $order_id = $billing_details['_wpsc_cart.log_id'][0];
    
    //Get product details
    $result_product_id = mysql_query("SELECT * FROM ". WPSC_TABLE_CART_CONTENTS ." WHERE purchaseid = '".$order_id."'");
    while($row_product_id = mysql_fetch_array($result_product_id)) {
    	$prodid = $row_product_id['prodid'];
    	$product_name = $row_product_id['name'];
    	$product_quantity = $row_product_id['quantity'];
    	$product_price = $row_product_id['price'];
    	$product_price_quantity = $product_price*$product_quantity;
    }
    
    $sessionid = $_GET['sessionid'];
    $purchase_log_object = new WPSC_Purchase_Log( $sessionid, 'sessionid' );
    $purchase_log = $purchase_log_object->get_data();
    
    echo 'Product ID: ' . $prodid;
    echo 'Product Name: ' . $product_name;
    echo 'Quantity: '  . $product_quantity;
    echo 'Product Price: ' . $product_price;
    echo 'Total Price: ' . $product_price_quantity;
    
    echo 'Customer details: ';
    print_r($billing_details);

    https://wordpress.org/plugins/wp-e-commerce/

  2. whitelamp
    Member
    Posted 1 year ago #

    Have a look at what's in display-sales-logs.php, may give you some pointers.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WP eCommerce
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic