Urgent: Paypal Issue

salmoon wrote: Well Gary, i find all that a bit confusing. I tried what you suggested with taking password off the directory and using SSL but this didn't work for me.

I've tried so many things now. I've tried taking ssl:// from the fsockopen lines.. and just using www. I've tried using http:// because someone said if you're coming from a http:// you need to set the url in fsock to the same. Made no difference.

I've even added the lines:

mail('myemail@mail.com', "INVALID IPN", "$res\n $req");
mail('myemail@mail.com', "VALID IPN", "$res\n $req");

to try and get some email notification if the IPN was returning valid / invalid but i didn't even get those emails. So it seems paypal just isn't communicating back to the shopping cart at all..

You are receiving 401 for the reply, which is 'file
not found'. Please check the 'notify_url' variable in your button code to
make sure that the URL that is included is the exact path to the IPN
script. The problem is that we cannot find your IPN script to post to.

$ouput .= 'url->ssl('checkout_process', 'callback', array('payment' => 'paypal')) . '" />' . "\n";

salmoon wrote: I've spoke to Paypal tech support about it and they said this:

You are receiving 401 for the reply, which is 'file
not found'. Please check the 'notify_url' variable in your button code to
make sure that the URL that is included is the exact path to the IPN
script. The problem is that we cannot find your IPN script to post to.

salmoon wrote: So then, without doing this should the cart update the db with the order regardless of whether the user clicks 'return to merchant' ? Is that the way it's supposed to work?

salmoon wrote: Gary i just tried your suggestion and it frikken works! There's a way round the whole getting the customer to click on the return to merchant link and thats to set up "auto return" in paypal to "index.php?controller=checkout_success" so it happens automatically.

My only concern now is that this IPN stuff might suddenly start working later down the line - what will happen if it does and the function "process" is still in there. Would there be an error or a duplicate order or something?

Or is this actually safe enough to use?

Hmm - "auto return" sounds good. Have to read about it. Do you have any details?

salmoon wrote: Goto your paypal account > profile > "Website Payment Preferences". Auto return's at the top of the page.

Work's really nicely now. I hope we can fix the problem however so we don't have to depend on the customer coming back to the site.

Thanks so much for sharing your findings Gary.

tchemis wrote: Are you guys using the current version 0.7.7? I had all the same problems with paypal you guys have been mentioning above but they were fixed when I upgraded to 0.7.7 with out any code changes.

As a side note you should setup the paypal redirect to the confirmation page in opencart on the paypal side, else paypal does not know where to send the user back to. This was also the case long ago when I messed with osCommerce.

$ouput .= 'url->ssl('checkout_process') . '" />' . "\n";

gary wrote:

function process_paid($order_status_id){
if ($this->data) {

//get order id 
$sql  = "select order_id from `order` where reference = '?'";
$order_id = $this->database->getRow($this->database->parse($sql, $this->reference));

$sql = "update `order` set order_status_id = '?' where order_id = '?'";
$this->database->query($this->database->parse($sql, $order_status_id, $order_id));

$sql = "update order_history set order_status_id = '?' where order_id = '?'";
$this->database->query($this->database->parse($sql, $order_status_id, $order_id));

//kill order_data
$sql = "delete from order_data where reference = '?'";
$this->database->query($this->database->parse($sql, $this->reference));
}
}

bruce wrote: You might like to look at this. The work flow suggested does not rely on the callback.

http://www.opencart.com/contribution/in ... tion_id/33

$sql = "update `order` set `order_status_id` = '?' where `reference` = '?' and `order_status_id` = '?'";
$parsed = $this->database->parse($sql, $paidUnconfirmedStatus, $reference, $pendingStatus);

$sql = "update `order` set `order_status_id` = '?' where `reference` = '?' and `order_status_id` = '?'";
$parsed = $this->database->parse($sql, $pendingStatus, $reference, $paidUnconfirmedStatus);