Hi,
VM1.1.3 with Joomla 1.0.15
I'm testing with PayPal sandbox and am struggling to resolve this issue.
I've processed several test transactions, all of which were successful - i'm directed to the paylPal sandbox site, payment processed successfully, confirmation order emails generated - but with status: PENDING. I don't understand why the status remains as pending even though the transactions were successful.
In both the payPal buyer and seller test accounts the transactions appear as payment status: COMPLETED.
I've checked that in the payPal config in VM admin that "order status for successful transactions" is set to CONFIRMED.
Have I missed something somewhere ?
Grateful for any assistance.
Thanks in advance
Q.
Different version of Joomla here but I imagine this bit it the same.
I read somewhere that paypal often returns a pending message for completed transactions.
The workaround is in your paypal config set the "Order Status for Pending Payments" to "Confirmed."
If paypal sends notify.php a message, most of the time it means everything worked fine.
I might be wrong, but if a payment fails I don't think paypal sends the message (IPN) to notify.php.
Is the code in your "payment extra" info section standard?
Because that didn't work for me, it needs a bit of tweaking.
There are a couple of good threads around here with updated code for that, Ill dig them out if you want.
Hi there hellodave, and thanks for the response.
First of all, I would have thought that if payPal is processing the payments and indeed shows them as successful in both the buyer and seller accounts, then this means that the message being sent should be "successful" rather than "pending", or are you saying, yes that's how it should be but in fact it doesn't happen that way and I should do as you suggested, set the "Order Status for Pending Payments" to "Confirmed." ? I am just a little worried about doing this if somehow it leads my client to ship stock which is not paid for. I guess maybe we need to confirm as you say, whether a message is indeed sent to notify.php if the payment fails.
My payment extra info is (I think) standard:-
<?php
$db1 = new ps_DB();
$q = "SELECT country_2_code FROM #__vm_country WHERE country_3_code='".$user->country."' ORDER BY country_2_code ASC";
$db1->query($q);
$url = "https://www.sandbox.paypal.com/cgi-bin/webscr";
$tax_total = $db->f("order_tax") + $db->f("order_shipping_tax");
$discount_total = $db->f("coupon_discount") + $db->f("order_discount");
$post_variables = Array(
"cmd" => "_ext-enter",
"redirect_cmd" => "_xclick",
"upload" => "1",
"business" => PAYPAL_EMAIL,
"receiver_email" => PAYPAL_EMAIL,
"item_name" => $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_NUMBER').": ". $db->f("order_id"),
"order_id" => $db->f("order_id"),
"invoice" => $db->f("order_number"),
"amount" => round( $db->f("order_subtotal")+$tax_total-$discount_total, 2),
"shipping" => sprintf("%.2f", $db->f("order_shipping")),
"currency_code" => $_SESSION['vendor_currency'],
"address_override" => "1",
"first_name" => $dbbt->f('first_name'),
"last_name" => $dbbt->f('last_name'),
"address1" => $dbbt->f('address_1'),
"address2" => $dbbt->f('address_2'),
"zip" => $dbbt->f('zip'),
"city" => $dbbt->f('city'),
"state" => $dbbt->f('state'),
"country" => $db1->f('country_2_code'),
"email" => $dbbt->f('user_email'),
"night_phone_b" => $dbbt->f('phone_1'),
"cpp_header_image" => $vendor_image_url,
"return" => SECUREURL ."index.php?option=com_virtuemart&page=checkout.result&order_id=".$db->f("order_id"),
"notify_url" => SECUREURL ."administrator/components/com_virtuemart/notify.php",
"cancel_return" => SECUREURL ."index.php",
"undefined_quantity" => "0",
"test_ipn" => PAYPAL_DEBUG,
"pal" => "NRUBJXESJTY24",
"no_shipping" => "1",
"no_note" => "1"
);
if( $page == "checkout.thankyou" ) {
$query_string = "?";
foreach( $post_variables as $name => $value ) {
$query_string .= $name. "=" . urlencode($value) ."&";
}
vmRedirect( $url . $query_string );
} else {
echo '<form action="'.$url.'" method="post" target="_blank">';
echo '<input type="image" name="submit" src="https://www.paypal.com/en_US/i/btn/x-click-but6.gif" alt="Click to pay with PayPal - it is fast, free and secure!" />';
foreach( $post_variables as $name => $value ) {
echo '<input type="hidden" name="'.$name.'" value="'.htmlspecialchars($value).'" />';
}
echo '</form>';
}
?>
I would be grateful if you had the time to dig out your payment info extra code if in fact you are using something different. If you are using something different, could i ask you to explain why you ended up changing from the standard ?
Thanks again.
Q.
Quote from: qme1ster on June 02, 2009, 13:38:15 PM
First of all, I would have thought that if payPal is processing the payments and indeed shows them as successful in both the buyer and seller accounts, then this means that the message being sent should be "successful" rather than "pending", or are you saying, yes that's how it should be but in fact it doesn't happen that way and I should do as you suggested, set the "Order Status for Pending Payments" to "Confirmed." ? I am just a little worried about doing this if somehow it leads my client to ship stock which is not paid for. I guess maybe we need to confirm as you say, whether a message is indeed sent to notify.php if the payment fails.
Yes, that is how it should be, but I believe this to be an error on paypal.
But, I only worked this stuff out a week ago so I could be wrong :)
Paypal sends you an email when successful payment is received, I would always check this has arrived before shipping stock.
Obviously this is a small business solution, not practical if you're selling by the lorry load.
I know it feels like a hack just to get it to work, but hey, if it works it works :)
I had a few problems with the standard paypal setup, product details not being sent to paypal, stock reduced and confirmation email sent before payment received, etc.
After reading a lot on the forum, particularly this thread -
Send Product Name and Attributes to Paypal (http://forum.virtuemart.net/index.php?topic=49535.0)
I ended up with this code -
-----WARNING-------WARNING-------WARNING-------WARNING-------
Do not use this code unedited, please try to understand the changes I have made.
They are probably not exactly what you want and may break paypal for you if used on its own.
-----WARNING-------WARNING-------WARNING-------WARNING-------
<?php
$url = "https://www.paypal.com/cgi-bin/webscr";
$order_id = $db->f("order_id");
$tax_total = $db->f("order_tax") + $db->f("order_shipping_tax");
$discount_total = $db->f("coupon_discount") + $db->f("order_discount");
// Query for Order Items
$dboi = new ps_DB;
$q_oi = "SELECT * FROM #__vm_order_item ";
$q_oi .= "WHERE #__vm_order_item.order_id='$order_id'";
$dboi->query($q_oi);
$row_num = $dboi->num_rows();
//New code Getting Cart Items
$auth = $_SESSION['auth'];
$cart = $_SESSION['cart'];
$t_quantity = 0;
$disc_perItem = 0;
$i=1;
// Query to get User Info
$dbb = new ps_DB;
$q = "SELECT * FROM #__vm_user_info ";
$q .= "WHERE user_id ='".$my->id."' ";
$dbb->setQuery($q);
$dbb->query();
// Handle discounts and attributes
$discount_totalCP = $db->f("coupon_discount") + $db->f("order_discount");
while($dboi->next_record()) {
$t_quantity = $t_quantity + intval($dboi->f("product_quantity"));
}
$dboi = null;
$dboi = new ps_DB;
$dboi->query($q_oi);
if($t_quantity > 0)
{
if($discount_totalCP > 0) {
$disc_perItem = round($discount_totalCP / $t_quantity, 2);
}
else {
$disc_perItem = 0;
}
}
else {
$disc_perItem = 0;
}
while($dboi->next_record()) {
$prod_attrib = $dboi->f("product_attribute");
$supp_var['item_name_' . $i] = strip_tags("Order #". $db->f("order_id").": ". $dboi->f("order_item_name"));
if($prod_attrib > ''){
$attributes_array = explode('<br/>',$prod_attrib);
$v = 0;
$z = 1;
foreach ( $attributes_array as $attributes_value){
$attrib_name = trim(substr($attributes_value, 0, strpos($attributes_value, ':')), " ");
$supp_var['on' . $z . '_' . $i] = $attrib_name;
// $attrib_sel = trim(substr_replace(substr_replace($attributes_value, "", 0, strrpos($attributes_value, ':')), //"", 0, 2)); I do not want to strip all colons
$attrib_sel = trim(substr($attributes_value, strpos($attributes_value, ':')+1));
$supp_var['os' . $z . '_' . $i] = $attrib_sel;
$v++;
$z++;
unset($attributes_value);
}
}
$supp_var['item_number_' . $i] = $dboi->f("order_item_sku");
$supp_var['quantity_' . $i] = $dboi->f("product_quantity");
$supp_var['amount_' . $i] = round(($dboi->f("product_item_price") - $disc_perItem),2);
$i++;
}
//Ship to Address Versus Bill To Address
//Query used to compare Bill to versus Shipp to address
$dboui = new ps_DB;
$q_oui = "SELECT * FROM #__vm_order_user_info ";
$q_oui .= "WHERE #__vm_order_user_info.order_id='$order_id' ORDER BY #__vm_order_user_info.order_info_id DESC";
$dboui->query($q_oui);
$oui_id = $dboui->f("order_info_id");
if($oui_id == $order_id){
$first_name = $dbb->f("first_name");
$last_name = $dbb->f("last_name");
$address1 = $dbb->f("address_1");
$address2 = $dbb->f("address_2");
$city = $dbb->f("city");
$state = $dbb->f("state");
$address_country = $dbbt->f("country");
$zip = $dbb->f("zip");
$H_PhoneNumber = $dbb->f("phone_1");
}
else {
$first_name = $dboui->f("first_name");
$last_name = $dboui->f("last_name");
$address1 = $dboui->f("address_1");
$address2 = $dboui->f("address_2");
$city = $dboui->f("city");
$state = $dboui->f("state");
$address_country = $dboui->f("country");
$zip = $dboui->f("zip");
$H_PhoneNumber = $dboui->f("phone_1");
}
// Builds array for the form
$post_variables = Array(
"cmd" => "_cart", //does not pass variables with return
//"cmd" => "_ext-enter", //will pass variables with return
"redirect_cmd" => "_xclick",
"upload" => "1",
//"page_style" => "paypal",
"business" => PAYPAL_EMAIL,
"currency_code" => $_SESSION['vendor_currency'],
"amount" => round( $db->f("order_subtotal")+$tax_total-$discount_total, 2),
"handling_cart" => "5.00",
"tax" => $tax_total,
"tax_cart" => $tax_total,
"invoice" => $db->f("order_number"),
//"myvar" => 'hello', paypal does not pass odd variables just custom
//"order_id" => $db->f("order_id"), order_id seems to be reserved in paypal
"image_url" => $vendor_image_url,
"return" => SECUREURL ."index.php?option=com_virtuemart&page=checkout.result&order_id=".$db->f("order_id"),
//"return" => SECUREURL ."paypal-return.html",
//"custom" => "option=com_virtuemart,page=checkout.result,order_id=".$order_id,
//you don't need to pass the option or page variables here use a menu link instead
"notify_url" => SECUREURL ."notify.php",
"cancel_return" => SECUREURL ."index.php",
"no_shipping" => "1",
"no_note" => "1",
"email" => $dbb->f("user_email"),
"address_override" => "1",
"first_name" => $first_name,
"last_name" => $last_name,
"address1" => $address1,
"address2" => $address2,
"city" => $city,
"state" => $state,
"country" => $address_country,
"zip" => $zip,
"night_phone_b" => $H_PhoneNumber,
"test_ipn" => PAYPAL_DEBUG,
"pal" => "NRUBJXESJTY24"
);
if( $page == "checkout.thankyou" ) {
$query_string = "?";
foreach( $post_variables as $name => $value ) {
$query_string .= $name. "=" . urlencode($value) ."&";
}
if(is_array($supp_var) && count($supp_var)) {
foreach($supp_var as $name => $value) {
$query_string .= $name. "=" . urlencode($value) ."&";
}
}
vmRedirect( $url . $query_string );
}
else {
echo '<form action="'.$url.'" method="post" target="_blank">';
foreach( $post_variables as $name => $value ) {
echo '<input type="hidden" name="'.$name.'" value="'.$value.'" />';
}
if(is_array($supp_var) && count($supp_var)) {
foreach($supp_var as $name => $value) {
echo '<input type="hidden" name="'.$name.'" value="'.$value.'" />';
}
}
echo '<input type="image" name="submit" src="https://www.paypal.com/en_GB/i/btn/x-click-but6.gif" border="0" alt="Make payments with PayPal, it is fast, free, and secure!">';
echo '</form>';
}
?>A couple of things to note about this -
Most of the changes you will find in the thread above.
I have hard coded my shipping value to get it to paypal.
I use a flat rate so this is ok for me, for the moment....
I have added a new notify.php in the root of my website, hence the location in the code above.
The new notify.php contains this code -
<?php
include('administrator/components/com_virtuemart/notify.php');
?>That's from another thread in this forum that I can't find at the moment.
It allows you to password protect your admin folder with .htaccess without affecting paypal.
One final tip, if you use the notify.php from the 1.1.4 RC you can use the paypal debug setting in the config.
It replaces the obsolete eliteweaver thingy with the proper paypal sandbox.
Sorry this is so rambling, and doesn't even offer a full solution.
I have not gone into all the issues here, there are too many.
I managed to get it working well enough for me, hopefully you will to.
All credit to the people that originally posted this stuff in other threads 8)
Even though my site is live and working, I would like to keep working on this.
It would be good if we could produce a formal solution.
There has already been a lot of discussion on this here, would be great to pull it all together and update the stickied paypal guide (http://forum.virtuemart.net/index.php?topic=39584.0).
Which I've just realised is where I read about the pending thing -
QuoteIMPORTANT: PayPal seems to return "Pending" very often, although the payment will be no problem. A further investigation, why the payment is still pending is not made at this time (we'll have to improve the paypal notify script to check that).
That's why you see "An error occured while processing your transaction. The status of your order could not be updated": You obviously haven't set the Order Status for pending payments to "confirmed".
Thanks again for taking the time to help out, and for sharing your code etc....but having considered it all, I think I might be muddying the waters if I were to implement your changes, especially as the changes you made weren't specifically to address the issue I'm having.
I found this other post here regarding the order status http://forum.virtuemart.net/index.php?topic=52872.msg174360#msg174360 but once again there was no definitive explanation/ answer. I tried the changes suggested there but without luck.
I'm really just trying to get down to the bottom of why the order status does not change. It was said in the post from the link above:-
QuoteIn my many hours in developing custom code for the paypal module I found that the "notify.php" code will reject the IPN from the sandbox because it's not from an approved paypal server.
What is the reason for this and how do we resolve ? The solution put forward in that post doesn't help me as the suggested code matches what I already had as default.
I think you're correct - we do need a definitive guide for this topic area. Too many people are experiencing these issues it seems but there's a distinct lack of official instruction.
I'd be grateful for more opinions and input from all who've had experience with this issue. Maybe then we can compile a tried and tested solution to make all of our lives easier ! Please help if you can...
Many many thanks
Q.
Quote from: qme1ster on June 02, 2009, 18:05:50 PM
I'm really just trying to get down to the bottom of why the order status does not change.
My understanding is that the order status does not change because paypal is returning a pending status even when payment is complete.
If this is true then do we need to complain to paypal about it?
Quote from: qme1ster on June 02, 2009, 18:05:50 PM
QuoteIn my many hours in developing custom code for the paypal module I found that the "notify.php" code will reject the IPN from the sandbox because it's not from an approved paypal server.
What is the reason for this and how do we resolve ? The solution put forward in that post doesn't help me as the suggested code matches what I already had as default.
Yeah, the code ajredding posted looks the same as default to me.
I did not have a problem with rejected IPNs from the sandbox, it worked just fine apart from this pending thing.
I would love to work all this out, really do some proper research, but my time is limited at the moment.
I'm posting here when I should be doing something else ::)
hellodave, you are one of the good guys 8) I really appreciate your efforts to help.
So just out of curiosity, I tried changing the payPal configuration options, this time I set "Order Status for Pending Payments" as CONFIRMED. Then I processed another order. The PayPal transaction was successful - both the buyer and seller accounts confirm this, the status on each account was "Completed". BUT this time when directed back to the store there's an error message which states "An error occured while processing your transaction. The status of your order could not be updated". Now I'm really starting to pull my hair out !
The email went out exactly as previously, with status PENDING.
I'm glad to help where I can, you get out what you put in :)
We are all in the same boat really.
Very odd, that error message is called on checkout.result.php when the status is not pending or confirmed.
I assume the order is in your database, what is the status set to?
hi hellodave,
I was having problems with the status not updating to Confirmed in the live mode even when the payments were successful, and I tried replacing the "Payment extra info" in the PayPal method form and now PayPal is not catching the right the right amount to pay (Example, in the checkout you see you have to pay $20 and when you click on Confirm Order and it takes you to PayPal it says you have to pay $15) Why does this happen???
Do you have any clue?
Did you use the code I posted above unedited?
Because that's probably not a good idea :)
If not, post your code.
what shoul I edit in that code? I just copied and pasted it, it didn't look like I had to change much...
Quote from: hellodave on June 02, 2009, 14:43:35 PM
I have hard coded my shipping value to get it to paypal.
I use a flat rate so this is ok for me, for the moment....
I have added a new notify.php in the root of my website, hence the location in the code above.
The new notify.php contains this code -
<?php
include('administrator/components/com_virtuemart/notify.php');
?>
These 2 points, that code has a handling charge of 5.00 hard coded into it.
You might want to put the original line back in and see if that works for you.
So where I have -
"handling_cart" => "5.00",I think the original is -
"shipping_1" => sprintf("%.2f", $db->f("order_shipping")),But I have seen this used by some people -
"handling_cart" => sprintf("%.2f", $db->f("order_shipping")),The other point is about moving notify.php, if you have not done that you need to change that back.
Where I have -
"notify_url" => SECUREURL ."notify.php",Change it to -
"notify_url" => SECUREURL ."administrator/components/com_virtuemart/notify.php",Oh, and change the url at the top to the sandbox version while you are testing.
Sorry for the confusion, hope I didn't miss anything.
I just noticed another problem with the code I posted.
For some reason in the sql I had changed the original table names to the prefixed ones.
Where I had put -
$q_oi = "SELECT * FROM jos_vm_order_item ";
It should of been -
$q_oi = "SELECT * FROM #__vm_order_item ";
The original post has been modified with this changed back.
I'm pretty sure that with a default installation this would be no problem, but it's probably a bad thing to do :)
Thankyou very much. I actually did create a new notify.php under the root folder. But I'm still having one problem: I added a discount/fee to the PayPal payment method that is not being sent to PayPal when you confirm your order. Is any code missing or wrong?
By the way, do you know why the payment method fee/discount does not include the shipping fee? It only calculates the percentage, in my case, to the subtotal (products order) but does not add the percentage of the shipping fee to the total. I've seen this issue in many forum topics but nobody seems to have a reply to fix it.
Well, at least I want the subtotal fee to be included in the amount when you are sent to PayPal.
Thanks in advance.
Ill have a look into this tomorrow, I really must do other stuff today.
For some reason, my brain is stuck on this paypal thing, I so want to get it nailed I struggle to think about anything else! I think I need help.
In the mean time, you might want to have a close look at the variables paypal accepts.
Are we sending the appropriate ones for what we want to do?
HTML Variables for Website Payments Standard (https://cms.paypal.com/us/cgi-bin/?cmd=_render-content&content_ID=developer/e_howto_html_Appx_websitestandard_htmlvariables)
I am currently having the same issue. I am going to try the switch on pending to confirmed. I will tell the business owner to not update the status to shipped until she has seen the Paypal transaction to be confirmed.
currently working with -
Joomla 1.5.10
VM 1.1.3
No matter what I try I still can't seem to shift the order status from pending to confirmed. As mentioned at the start of this thread (now heading in other directions) the transactions are showing up as successful in the buyer and seller payPal accounts, however the emails which are sent out state the order is pending, as does the database.
I've checked my ps_paypal.cfg.php file which is as follows:-
<?php
if( !defined( '_VALID_MOS' ) && !defined( '_JEXEC' ) ) die( 'Direct Access to '.basename(__FILE__).' is not allowed.' );
define ('PAYPAL_DEBUG', '1');
define ('PAYPAL_EMAIL', 'shopowner@domain.com');
define ('PAYPAL_VERIFIED_ONLY', '0');
define ('PAYPAL_VERIFIED_STATUS', 'C');
define ('PAYPAL_PENDING_STATUS', 'P');
define ('PAYPAL_INVALID_STATUS', 'X');
?>I believe this is as it should be when in test mode.
I've also just tried the Instant Payment Notification (IPN) simulator in the payPal sandbox. I tested for transaction type "cart checkout" and received the result: "IPN successfully sent. ". But then I thought - well how can we confirm what is actually being sent and received by VM ??
So I found this post http://forum.virtuemart.net/index.php?topic=48421.0 which suggested the following:-
Quoteare you also able to confirm that the post back from paypal actually includes the correct order_status? In your paypal configuration you should have a notify_uri which points to notify.php it is this file that handles the response from paypal.
A simple way to verify this is to create a file called ipntest.php (or whatever you like) and upload it to the root directory of your joomla installation. This file should contain the following:
<?php
$fromname= "Your name here";
$from_email = "your email here";
$recipient_email = "recipients email here";
$subject = "Paypal IPN Test";
$body = null;
$header = "From: ".$fromname. " <".$from_email.">\r\n";
foreach($_POST as $var=>$val){
$body .= $var.":".$val."/n";
}
mail($recipient_email, $subject, $body, $header);
?>
Then update your paypal configuration and modify the notify_uri to point to this newly created file. Now make a purchase (I'm assuming you have set everything to test mode Smiley ).
You should receive an email with the info that PayPal returns to your site after the purchase.
Take a look at this email and confirm that the order_status is "Confirmed".
I gave this a try - The email which came through as a result of the above test with ipntest.php contains the following:-
mc_gross:6.97/ninvoice:71_c2f3f218636faa98c574ed16500c8/nprotection_eligibility:Ineligible/naddress_status:unconfirmed/npayer_id:5SANZVPRSZ69U/ntax:0.00/naddress_street:Old Town Road/npayment_date:14:43:21 Jun 16, 2009 PDT/
npayment_status:Completed/ncharset:windows-1252/naddress_zip:Bantry 1/nfirst_name:Test/nmc_fee:0.59/naddress_country_code:IE/naddress_name:John Banter/nnotify_version:2.8/ncustom:/npayer_status:verified/nbusiness:shopowner@domain.com/naddress_country:Ireland/naddress_city:Bantry/nquantity:1/nverify_sign:AFcWxV21C7fd0v3bYYYRCpSSRl31AAM4-.ksto8kS7IQpPXS0wxePHiU/npayer_email:info_1237914324_per@domain.com/ntxn_id:04191951KV711614W/npayment_type:instant/nlast_name:User/naddress_state:CO/nreceiver_email:shopowner@domain.com/npayment_fee:/nreceiver_id:XE6F7G235AEQ6/ntxn_type:web_accept/nitem_name:Order Number: 11/nmc_currency:EUR/nitem_number:/nresidence_country:GB/ntest_ipn:1/nhandling_amount:0.00/ntransaction_subject:Order Number: 11/npayment_gross:/nshipping:0.00/n
I'm not 100% sure of the various values contained within the email. There is no mention of "order_status" anywhere. However you can see within this email there is a "npayment_status:Completed", and this seems to tie in with this code snippet in my notify.php file around line 384:-
// UPDATE THE ORDER STATUS to 'Completed'
if(eregi ("Completed", $payment_status)) {
$d['order_status'] = PAYPAL_VERIFIED_STATUS; So my interpretation is that yet again the payPal transaction was successful, but still the order status remains stuck at "pending".
Can anyone shed light on what the problem might be- why the order status will not change - even though the IPN is communicating a successful i.e. COMPLETED transaction ??
There seems to be an enormous amount of angst out there with this particular issue - it really would be great if we could solve this once and for all.
In earnest....
Q.
Joomla 1.5.9, vm1.1.2 stable.
I'm testing with Test mode=No, and making $1 purchases. My netbank shows my credit card is being billed. Paypal says transaction successful, and return to merchant site says successful, BUT like everyone else order_status in db and email is Pending.
So, for testing, in administrator/components/com_virtuemart/notify.php, after:
// remove post headers if present.
$res = preg_replace("'Content-type: text/plain'si","",$res);
I put this code:
## kas debug 22/07/2009
$docroot=$_SERVER['DOCUMENT_ROOT'];
$filedescriptor="$docroot"."/"."tmp/paypal.txt";
if ($filehandle=fopen($filedescriptor, "w"))
{
$filedata="order_id=$order_id\n\nres=$res\n\npayment_status=$payment_status\n\n";
fwrite($filehandle,$filedata);
fclose($filehandle);
}
######
File paypal.txt is created and I grab it with FTP. This is what it says:
######################################
order_id=25
res=HTTP/1.1 200 OK Date: Thu, 23 Jul 2009 03:42:47 GMT Server: Apache Set-Cookie: "i removed the cookie"; domain=.paypal.com; path=/ Set-Cookie: cookie_check=yes; expires=Sun, 21-Jul-2019 03:42:48 GMT; domain=.paypal.com; path=/ Set-Cookie: navcmd=_notify-validate; domain=.paypal.com; path=/ Set-Cookie: navlns=0; expires=Wed, 18-Jul-2029 03:42:48 GMT; domain=.paypal.com; path=/ Vary: Accept-Encoding Connection: close Content-Type: text/html; charset=UTF-8 VERIFIED
payment_status=Pending
###################################
NOTE WELL that payment_status=Pending, so that's it. It seems to me that Paypal is returning incorrect POST data.
$payment_status = trim(stripslashes($_POST['payment_status']));
Can someone else repeat my test and report the results please??
More Research: just found this Paypal Developer forum topic:
http://paypaldev.org/topic.asp?TOPIC_ID=80
###############################################################
Bruce
16 Posts
Posted - 11/01/2002 : 09:27:00
Another basic question from me!!!
If $payment_status is Pending, shouild my script do nothing and wait for the $payment_status="Completed" to be returned from the paypal server.
I am only wanting to process an order when I know that it is verified and payment_staus="completed".
Apologies if this seems a simple question.
Thanx
Bruce
paypal_pb
3472 Posts
Posted - 11/01/2002 : 09:49:16
Yes, you can disregard when payment_status=Pending and just wait for the Completed IPN. In general, you should only fulfill Completed payments.
Patrick Breitenbach
PayPal, Inc.
Dev Net: https://www.paypal.com/pdn
Go to Top of Page
paypal_pb
3472 Posts
Posted - 11/01/2002 : 17:26:17
It depends on the situation. A Pending echeck has a very high probability of completing. While you may not want to ship a physical good based on a Pending payment, you might be comfortable granting access to an online service or delivering a digital good.
But if you completely ignore Pending payments, the subsequent IPN with payment_status=Completed resembles a buyer doing an instant payment at that time.
Patrick Breitenbach
PayPal, Inc.
Dev Net: https://www.paypal.com/pdn
################################################################
I've also googled to try to find all possible values for payment_status. Zen-cart identifies these:
payment_status_id: 1
payment_status_name: Completed
payment_status_id: 2
payment_status_name: Pending
payment_status_id: 3
payment_status_name: Failed
payment_status_id: 4
payment_status_name: Denied
payment_status_id: 5
payment_status_name: Refunded
payment_status_id: 6
payment_status_name: Canceled_Reversal
payment_status_id: 7
payment_status_name: Reversed
So, based on the Paypal Dev Topic, and the probable values for payment_status returned, I'm inclined to hack notify.php to force payment_status="Confirmed" if it is returned as Pending.
I'll advise my client to always logon to their Paypal acct and check before shipping.
Would love to see this resolved elegantly.
Rather than hacking notify, I'd suggest just changing the Paypal config in VM.
As I posted in a different thread, http://forum.virtuemart.net/index.php?topic=48421.30, I am curious as to the settings of people that get confirmed and those that don't. I have seen sites with my own eyes receive 'confirmed' and at least one of these is using just the default setup (no custom Paypal mods).
I have posted the rest in the other thread as it was the original and has a lot of interest: http://forum.virtuemart.net/index.php?topic=48421.30 (http://forum.virtuemart.net/index.php?topic=48421.30)
I too am also struggling with this issue. Running VM1.1.3 and J!1.5.14.
I created a testipn.php script using this code.
<?php
$fromname= "Shop name";
$from_email = "sender@email.com.au";
$recipient_email = "recipient@email.com.au";
$subject = "Paypal IPN Test";
$body = null;
$header = "From: ".$fromname. " <".$from_email.">\r\n";
foreach($_POST as $var=>$val){
$body .= $var.":".$val."/n";
}
mail($recipient_email, $subject, $body, $header);
?>
And this the result.
mc_gross:900.00/ninvoice:65_6705ff25ec262dc5c3bf7ade399db/nprotection_eligibility:Ineligible/naddress_status:unconfirmed/npayer_id:JHGHY6RQFT5DE/ntax:0.00/naddress_street:PO BOx slkdjfl/npayment_date:01:04:47 Nov 26, 2009 PST/npayment_status:Completed/ncharset:windows-1252/naddress_zip:6666/nfirst_name:Test/nmc_fee:21.90/naddress_country_code:AU/naddress_name:John P/nnotify_version:2.8/ncustom:/npayer_status:unverified/nbusiness:seller_1259222635_biz@viperfish.com.au/naddress_country:Australia/naddress_city:sldkfho/nquantity:1/nverify_sign:AXgu3byOTxDEQDNKtOr0pNXGGAFIAIZkb8Ym-6Yj-BWEHD3XSMDo2IHZ/npayer_email:buyer_1259222398_per@viperfish.com.au/ntxn_id:7M9930572K2703636/npayment_type:instant/nlast_name:User/naddress_state:WA/nreceiver_email:seller_1259222635_biz@viperfish.com.au/npayment_fee:/nreceiver_id:A6WQJHA62WRFG/ntxn_type:web_accept/nitem_name:Order Number: 6/nmc_currency:AUD/nitem_number:/nresidence_country:AU/ntest_ipn:1/nhandling_amount:0.00/ntransaction_subject:Order Number: 6/npayment_gross:/nshipping:0.00/n
The payment status is completed. But, looking through the notify.php script I can't find any reference to "Order Number". In this case order number 6. The notify script retrieves the invoice number but not the order number. Here's the code from line 181;
// The Order Number (not order_id !)
$invoice = trim(stripslashes($_POST['invoice']));
Also it looks like values for "item_name" and "transaction_subject" are missing from the output. Coincidentally(?) these appear immediately before the order number. They also don't appear anywhere in the notify.php script.
So how does the notify script know which order to update?