"PayPal_Shopping_Cart_IPN 3.5" sore subject

[Irin]

Hello,

 

The question I'm going to address here has been asked at least 10 times all over oscommerce forum, but I never really found any answer to it. There is a topic addressed specifically to "PayPal_Shopping_Cart_IPN 3.5", but it seems that these questions just been ignored and never referred to. You won't believe me, but I looked all over 95+ pages of that topic but haven't seen any answer. May be I'm just blind or just not looking at the right place. I use "PayPal_Shopping_Cart_IPN 3.5". It worked fine but then, it suddenly stopped showing PayPal Transaction Activities. All I have right now is: No PayPal Transaction Information Available (), however payment has been submitted through PayPal and transaction appears to be completed in PayPal IPN. In addition, I have all the information listed in my database, it just seems not pulling that info from there. When I get an email with order details, it doesn't show neither Delivery nor Billing Addresses. All I have is:

Delivery Address

------------------------------------------------------

 

 

,

 

 

 

Billing Address

------------------------------------------------------

 

 

,

 

 

 

Payment Method

------------------------------------------------------

PayPal

I'm sure there are a lot of people who's having the same problems as I do. May be somebody has already solved them. Please share how you fixed it. My store is live so I'm really concerned about PayPal IPN functioning properly. Any help or tips would be greatly appreciated. Please point me to the right direction.

 

Thanks in advance.

Irin.

Edited January 4, 2006 by Irin

[Irin]

Ok, I found what caused my PayPal not showing details. In my case the problem was in admin/includes/classes/order.php.

However, PayPal popup window doesn't show Shipping Info, still ","

 

Regards.

[McFly04]

Ok, I found what caused my PayPal not showing details. In my case the problem was in admin/includes/classes/order.php.

However, PayPal popup window doesn't show Shipping Info, still ","

 

Regards.

 

 

Hi Irin,

 

Can you please share your findings? I am having the same problem, but I cannot find anything wrong in order.php.

 

Thanks very much!

[Irin]

Hi Irin,

 

Can you please share your findings? I am having the same problem, but I cannot find anything wrong in order.php.

 

Thanks very much!

Sorry for a late reply. In my case the problem was with repeated order_query because of some additional contibutions I've installed. So, I just combined all my contributions into one order_query in my admin/includes/classes/order.php. This is how my order_query looks now:

class order {

var $info, $totals, $products, $customer, $delivery;

 

//KGT - begin change

// add languages_id

 

function order($order_id) {

global $languages_id;

 

$this->info = array();

$this->totals = array();

$this->products = array();

$this->customer = array();

$this->delivery = array();

 

$this->query($order_id);

}

//KGT - end change

 

function query($order_id) {

global $languages_id;

//begin PayPal_Shopping_Cart_IPN

/*Tracking contribution begin*/

// Company PO Account start

// Added purchase_order_number to query

$order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_cvv2, cc_expires, comments, fedex_track_num, ups_track_num, usps_track_num, currency, currency_value, purchase_order_number, date_purchased, orders_status, ipaddy, ipisp, customers_referer_url, last_modified, customers_id, payment_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");

/*Tracking contribution end*/

//end PayPal_Shopping_Cart_IPN

// Company PO Account end

$order = tep_db_fetch_array($order_query);

I hope it helps.

 

Regards,

Irina.

Edited March 10, 2006 by Irin