You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Hi
I've received a notification from Paypal that an order has been processed on 21st April but I cannot find it anywhere on our system (I've searched Completed, Cancelled and Processing).
Any ideas as to where it might be or what might have happened?
Thanks
Terry
Caracamp
Offline
if you go here:
Location: System Dashboard > Store > Component > Settings > Cron Settings
have a look at how long you store the pending/cancelled orders.
I would guess your customer has left there machine on the paypal payment page for longer than 30 minutes(could be many days) before clicking the confirm button, meaning the order status will not be updated to Processing as the communication between Paypal and your site was broken. If the transaction was initiated longer than you store your pending/cancelled orders, the order would have been lost.
Does your order number on the paypal receipt indicate when the order was initiated??
Offline
The customer has forwarded a copy of his confirmation email (dated 21st April 2015). The online storage time for pending/cancelled orders is 10 days, completed/processing orders 1 year and shopping cart/wish list 6 months.
The customers copy of confirmation states that the order status is pending payment, so it is likely that the delay as you suggested is the problem.
I'm stumped at what to do next.
Terry
Last edited by tguswell (04-22-2015 10:21:14)
Offline
The customers confirmation email... do you mean a receipt from Paypal, or an confirmation generated by CCP??
If it is from Paypal it should include the CCP generated order number. Does the CCP order number indicate the date the order was initiated?
Offline
It includes the CCP generated order number and the email confirmation that he forwarded to me is also a CCP generated email. However, I cannot find any record of this transaction within my system.
Offline
If the customer was never returned to the site following their order confirmation at PayPal (ie, they closed their browser before returning to your site, there was a connectivity issue getting the IPN request, etc), the order would have remained in a pending payment state and would have been removed from the system after X number of days.
Offline
T Guswell - you are not alone. This happened to my client and customer was angry accusing my client of fraud. Neither the order number nor the customer's name was in db, in no table.
Customer did have a copy of the online CCP invoice, but client received nothing about the order being paid.
How can that happen?
Webmaster - perhaps you can supply a patch to record the process in the orders table before going to PP? Record the steps so at least billing info is recorded with an order number.
Offline
You should increase the number of days orders pending payment are stored for here:
Location: System Dashboard > Store > Component > Settings > Cron Settings
Change it to 30 days and your problems should be resolved.
The problem is due to the customer leaving there web browser on the payment page for very long periods before completing the transaction.
For example, if you store orders pending payment for 1 day.
Customer creates order on Monday and proceeds to Paypal.
CCP creates a pending payment order.
Customer leaves computer without confirming payment on paypal page.
Returns to computer on Wednesday and realises they never clicked confirm button.
They click the confirm button and think they have placed an order.
In the meantime Paypal has broken connection with your site so it cannot update the order status, which is irrelevant because the pending payment order has already been deleted due to your cron setting.
We used to have this issue, but resolved it by increading the storage time to 30 days.
If the customer does leave the browser on the paypal page for more than 30 minutes, the CCP order status will not be updated but the customers should be directed to a CCP page requesting they contact the store to confirm the order.
Offline
I've now changed my storage time to 30 days. Thanks to zanart for his suggestion.
Nick, would it be worth thinking about changing the default value for this for future releases?
Terry
Last edited by tguswell (04-27-2015 09:18:36)
Offline
This is a balance of storing too much recent garbage data in the database (old unfinished orders) versus storing them long enough to retrieve them. I believe the default setting is enough if you are verifying you're getting emails from both paypal and the store for each order.
Offline
Nick
webmaster wrote:
I believe the default setting is enough if you are verifying you're getting emails from both paypal and the store for each order.
Would the verifying be done manually or can the system handle the check? If the system, then how is done accomplished?
Terry
Offline
You would need to check each paypal payment you have received has a valid pending shipment order associated with it, manually.
It really depends how many orders you take and whether you have the time to check each payment.
We take a high number of orders and don't check each paypal payment.
For us, the onus is on the customer to realise there is a problem and contact us.
For this reason we store pending payment orders for 30 days to ensure the customer has plenty of time to realise they haven't got the order.
In reality we should be proactive and check each payment, but it is the customer that leaves their browser on the payment page for a few days before proceeding, and then opts to ignore the 'Contact us to confirm the order....' message.
It probably only happens once every 1000 orders. We can proof the time difference and explain the connection was broken for security purposes, normally customers don't mind. To proof the time difference you can check the ccp order time and the paypal payment time
Offline
We have also been having this problem for quite some time but it is intermittent. It happens with some orders but not others and the orders are usually no more than one day old. I have increased the cron settings for pending storage to 30 days and hopefully will resolve the issue.
Perhaps some kind of sync button or interval script within CCP to actively check Paypall for orphaned transactions containing the order number would be helpful.
Offline
Perhaps some kind of sync button or interval script within CCP to actively check Paypall for orphaned transactions containing the order number would be helpful.
Good idea. We'll look into this.
Offline
You will always get automatic confirmation from CCP when a successful paypal payment is made unless the user has left their browser on the paypal page for over 15 minutes(might be 30 minutes) before completing the transaction.
This assumes you have CCP and paypal set up correctly.
The only time you will not receive automatic confirmation is if the user leaves their browser on the payment page for hours/days before completing the transaction, or if they click the back button before the communication is complete.
Offline
Sure but I am finding currently if checking out via paypal standard, when it says congratulations and in small 'click here to return to xxx' - users are closing their browser then and no order confirmation is triggered - so should it be still in this instance?
Offline
In my paypal account Website Payment Preferences I have Auto Return for Website Payments set to On.
My customers are returned to the CCP order confirmation page automatically after a few seconds.
Have you tested the procedure yourself?
Offline
Not blank....
http://www.mydomain.co.uk/utilities/ecomrelay.php
Last edited by zanart (07-12-2015 09:36:00)
Offline
We use both PayPal Standard and Express checkouts and have Auto Return set to Off and Return URL empty. Is that the correct way to have them set up?
Offline
It depends. I've seen PayPal use it's settings when entered, and I've seen it use CCP settings when passed. I'd recommend turning on the auto-return and entering your return URL into that field for good measure, but it's likely not necessary.
Offline