order email not sent when customer doesnt click paypal link

[chandrika]

Hi

Most of the time, customers are automatically returned to my site after payment and an order process email is automatically sent to them and to me.

 

However at times (I think it is when customer doesnt have a paypal account) they are not automatically returned and have to click a link to return and of course they dont always remember to do it and so although I know i have an order in the admin section, and get an email from paypal, they dont get an order processing email and their shopping cart is not emptied.

 

has anyone else had this problem and solved it?

[Guest]

@@chandrika

 

If a customer uses PayPal, whether they have a PayPal account or not they are returned to your site if you have the Auto - Return enabled. The issue must reside somewhere else.

 

 

 

Chris

[chandrika]

I do have auto return switched on in Paypal settings.

 

the return url is

https : //www. mysite .co.uk/checkout_process.php

 

i am using paypal payments standard module with the opion not to have a paypal account.

 

I got a little confused during set up six months back, with it not being clear what the return url should be. Different people seemd to say different return urls. I settled for this one which does usually work fine, the majority of people get returned to my site and the order process gets completed ok.

[krokus]

Paypal : Note: If you have turned on Auto Return and have chosen to turn on PayPal Account Optional for new users, a new user will not be automatically directed back to your website, but will be given the option to return.

So no return, no update of stock, no email for most of client

[chandrika]

Ah yes, I remember that now from when I was setting it up.

 

When I started and orders were thin it wasnt a big problem, bit now more orders are coming in it became a bit of a problem trying to see which had been notfied and not.

 

Since I posted I have made a page that makes it easier for me to see which need manually confirming. The order status in my setup is "4" Processing, once the IPN is received, so I know they have paid, it looks same as those who have been notified in admin however, so unless i click each order individually i cant see if they have been notified.

 

This little php script that I put in the admin folder, shows a list of which orders that are processing have had customers notified. So I can see which havent and have a link to edit that order next to it, just to speed things up a bit. It is a bit of a sketchy workaround that will have to do for now, it is making my life easier, although it is not ideal. Only thing I want to do is also clear their session and empty their cart, so that when they return the cart doesnt still show the ordered goods in it.Currently I login as them and empty their cart manually. I can work out how to empty the cart of specific customer id, but not how to delete the session of that customners id...so even if i empty the shopping cart fields for that customer, their session still shows the items in the cart unless I do it manually.

 

<?php
require('includes/application_top.php');
require(DIR_WS_CLASSES . 'currencies.php');
include(DIR_WS_CLASSES . 'order.php');
//this is just the text I copy and paste into comments for the manual order confirmation
echo "Thankyou for your order at XXXX, to view your order details please visit
https : //www.xxxxx.co.uk/account_history.php<br /><br />You will be notified when your goods are shipped.<br /><a href='http:// www. xxxxxs.co.uk/admin/orders.php'>Orders</a><br /><hr /><br />";
//check for orders processing 4
$check_status_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_status = '4'");
 while($check_status = tep_db_fetch_array($check_status_query)) {

$myoid=$check_status['orders_id'];
echo $myoid." is processing. <a href='http :// www.xxxx.co.uk/admin/orders.php?page=1&oID=".$myoid."&action=edit'>Order</a>  <a href='http:// www .xxxxxx.co.uk/'>Website</a><br />";

//check whether the customer has been notified
$check_cust_notified_query = tep_db_query("select customer_notified, orders_status_id, comments from orders_status_history where orders_id = '".$myoid."'");
while($check_cust_notified = tep_db_fetch_array($check_cust_notified_query)) {

$notified=$check_cust_notified['customer_notified'];
$order_status_id=$check_cust_notified['orders_status_id'];
$comments=$check_cust_notified['comments'];
 $pos = strpos($comments,"PayPal IPN Verified [Completed");
 if($pos === false) {
 //check if notified
 if ($notified=="1")
 echo "<font color='#FF0000'>".$myoid." customer notified</font><br />";
 }
 else {
 // string needle found in haystack

 }
}//end while check_cust_notified_query
echo "<hr />";
}//end while check_status_query
require(DIR_WS_INCLUDES . 'application_bottom.php');
?>

 

From this I get a list of the orders that are processing, in red below each order it says if it has been notfied, those that havet do not have that, so can be picked out easily and have a link next to them to edit that orer and send a manual order confirmation in comments, that can be copy and pasted from top of the page.