Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Paypal iPN not updating payment status to active


AsifKhan

Recommended Posts

Posted

Hello,

 

Sorry for bad english.

 

Some one help me plz

 

 

Actually i m using smarty, i am facing an issue with payment status. i use query to update the status of order id.

 

when i click on pay now button from paypal page, there are two cases now,

 

1. if i use hard coded order id like $_oid = '683-7048307-8132954';

 

it works fine.

 

2. if use $_SESSION['order_id'];

 

it does not work.

 

 

and both session order id and hard coded are same.

 

 

code is here in front of u

 

/********************************************/

 

 

$_oid = $_SESSION['order_id_string'];

 

 

// $_oid = '683-7048307-8132954';

 

 

$check = $db->executeScalar("Select status from table

 

where order_id = '".$_oid."'");

 

 

// var_dump($check);

 

// exit;

 

 

 

if ($check == 0){

 

 

 

$_memberid = $_SESSION['userid'];

 

 

 

 

$oname = $db->executeTwise("Select fname, lname from members where id= '".$_memberid."'");

 

 

 

// var_dump($oname);

// exit;

 

 

 

$update_trans = "Update orders set

 

status = '1',

 

standingstatus = '1'

 

where order_id = '".$_oid."'";

 

 

 

$db->execute($update_trans);

 

 

 

}

Posted

PayPal IPN should return the order number to process the order status. You can debug the PayPal IPN, using the PayPal INP log which available in PayPal account.

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...