Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by RobinSomes

  1. Thanks for your reply. He was a guest, not a registered customer, so the download wasn't available to him that way. We got round the problem by other means, but it would be useful in future if a workaround were available. Thanks again, Robin
  2. I have just had another PayPal transaction failure, as above. The order stuck at Pending, despite payment arriving in our PayPal account correctly. There was a digital item in the cart, and no other physical goods. Marking the order as Completed sends an "Order Complete" email to the customer, but no "Your Purchased Downloads" email. The Request Log contains 11 identical red entries, between 03:34 and 03:37 UTC, as follows: Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/***************[{"op":"replace","path":"/purchase_units/@reference_id=='*************'/amount","value":{"value":"18.00","currency_code":"GBP","breakdown":{"item_total":{"value":"18","currency_code":"GBP"},"shipping":{"value":"0","currency_code":"GBP"},"tax_total":{"value":"0","currency_code":"GBP"},"discount":{"value":"0","currency_code":"GBP"}}}}] Error:cURL Error (22): The requested URL returned error: 422 Unprocessable Entity Response received (422 - Unprocessable Entity) Apart from the use of the PayPal Commerce gateway, there's no obvious connection between the two customers in these stuck transactions (the first, on July 7th, was an unregistered customer in the UK, the second, this morning, was a registered customer in Chile). Each ordered a different downloadable item. The ability to send a "Your Purchased Downloads" email manually would go some way towards helping, but it's becoming frustrating and embarrassing to keep failing customers in this way. (Since my original query, the shop has been updated to the latest incarnations of CC and PayPal Commerce).
  3. Thank you; great response as ever, I appreciate it. Meanwhile, if I do see any other stuck orders I shall report their circumstances here. Thanks again, Robin
  4. Would it help to send you the full set of entries from the Request Log for the order? (I would post it here but there's sensitive bits of information, I guess). Perhaps one set for yesterday's stuck order, and another set from today's successful test order? Looking at the evidence available to me for one of the test orders I made this morning, it seems to be in this order; Request Log entries in italics: 09:16:17 (GMT) - Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/ Response received (201 - Created) 09:16:58 - Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/ Response received (201 - Created) 09:18 + some unknown seconds but record below suggests 09:18:21 - Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/************ Response received (200 - OK) 09:18 + unknown seconds - Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/****************** Response received (204 - No Content) 09:20 + unknown seconds - Request Sent (cURL) - https://www.google.com/recaptcha/api/siteverify?secret=****** Response received (200 - OK){ "success": true, "challenge_ts": "2021-07-08T09:18:21Z", "hostname": "******" } 09:20 + unknown - 4 identical Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/**************[SNIPPED FOR BREVITY]{"op":"add","path":"/purchase_units/@reference_id=='*************'/invoice_id","value":"210708-092019-****"},{"op":"add","path":"/purchase_units/@reference_id=='*************'/description","value":"Payment for order 210708-092019-****"}] Response received (204 - No Content) 09:20:19 - The order was placed (judging from the order reference number 210708-092019-XXXX) 09:20:21 - Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/***********/capture Response received (201 - Created) 09:20:22 - "Thank you for your payment!" email sent by the shop 09:20:25 - "Thank you for your payment!" email recorded in shop email log 09:20:25 - "Order Confirmation" email sent by the shop 09:20:27 - "Order Confirmation" email recorded in shop email log 09:20:27 - "New Order #210708-092019-****" email sent to my office 09:20:27 - "New Order #210708-092019-****" email recorded in shop email log 09:20:35 - "Your Purchased Downloads" email sent by the shop 09:20:37 - "Your Purchased Downloads" email recorded in shop email log
  5. I've just put through one order using Microsoft Edge, and PayPal Checkout as a guest. Order completed successfully and emails sent OK; Request Log has no red entries, but the following line with the total value truncated: Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/***********[{"op":"replace","path":"/purchase_units/@reference_id=='*************'/amount","value":{"value":"21.60","currency_code":"GBP","breakdown":{"item_total":{"value":"21.6","currency_code":"GBP"},"shipping":{"value":"0","currency_code":"GBP"},"tax_total":{"value":"0","currency_code":"GBP"},"discount":{"value":"0","currency_code":"GBP"}}}}] Response received (204 - No Content) Another order in the Chrome browser, PayPal Checkout as a guest. Order successful, emails OK; similar result in Request Log: Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/**************[{"op":"replace","path":"/purchase_units/@reference_id=='*******************'/amount","value":{"value":"15.60","currency_code":"GBP","breakdown":{"item_total":{"value":"15.6","currency_code":"GBP"},"shipping":{"value":"0","currency_code":"GBP"},"tax_total":{"value":"0","currency_code":"GBP"},"discount":{"value":"0","currency_code":"GBP"}}}}] Response received (204 - No Content) A third order, using Chrome, PayPal Checkout, using PayPal balance. Order successful, emails OK, similar Request Log entry: Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders************[{"op":"replace","path":"/purchase_units/@reference_id=='************'/amount","value":{"value":"10.80","currency_code":"GBP","breakdown":{"item_total":{"value":"10.8","currency_code":"GBP"},"shipping":{"value":"0","currency_code":"GBP"},"tax_total":{"value":"0","currency_code":"GBP"},"discount":{"value":"0","currency_code":"GBP"}}}}] Response received (204 - No Content) I'm not sure continuing with every possible combination of browser I have / PayPal as guest / PayPal as user would tell us much more, but it looks like the truncated total value, on its own, isn't the trigger for the failure.
  6. There are no other red entries in the Request Log, which dates back only as far as June 8th. However I can see one order on June 11th where the total price was truncated, as in our example above. That order went on to be completed successfully, and all the requisite emails were sent, so I'm not sure where that leaves us! Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/***************[{"op":"replace","path":"/purchase_units/@reference_id=='****************'/amount","value":{"value":"44.40","currency_code":"GBP","breakdown":{"item_total":{"value":"44.4","currency_code":"GBP"},"shipping":{"value":"0","currency_code":"GBP"},"tax_total":{"value":"0","currency_code":"GBP"},"discount":{"value":"0","currency_code":"GBP"}}}}] Response received (204 - No Content) I will put through some sample orders today, and see if I can reproduce the behaviour. Many thanks for your help. Robin
  7. At a rough guess, 10% of orders transacted through the PayPal Commerce Platform stick like this, We also use Sagepay; I'm not aware of any of those transactions sticking at Pending. That does indeed seem odd... That is correct, it's not checked.
  8. Site: piscesconservation.com/cube CC 6.4.2 / AllInOneShipping 10.0.21 / Facebook 1.0.1 / PayPal Commerce Platform 1.4.4 / PayPal Standard Gateway 1.0.8 (disabled) / ProductAddons 1.0.12 / SagePay 1.0.11 Sales of downloadable goods made using PayPal occasionally do not complete, so remain Pending. I can see in our PayPal a/c that the money has been received, and get an email to that effect. "Thank you for your payment" and "Order Confirmation #123456789XYZ" emails are sent to the customer, but no "Order Complete" or "Your Purchased Downloads" mails. The Request Log has a series of 5 identical errors in red, from the time of the order: Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/0S044361FS6103330[{"op":"replace","path":"/purchase_units/@reference_id=='***********'/amount","value":{"value":"21.60","currency_code":"GBP","breakdown":{"item_total":{"value":"21.6","currency_code":"GBP"},"shipping":{"value":"0","currency_code":"GBP"},"tax_total":{"value":"0","currency_code":"GBP"},"discount":{"value":"0","currency_code":"GBP"}}}}] Error:cURL Error (22): The requested URL returned error: 422 Unprocessable Entity Response received (422 - Unprocessable Entity) I can mark the order as Completed by hand, and this triggers an "Order Complete" email being sent, but no "Your Purchased Downloads". 1: I know that the 422 - Unprocessable Entity error has been mentioned here before (https://forums.cubecart.com/topic/56248-paypal-not-finalising/?tab=comments#comment-243761) but there didn't seem to be any resolution to it, other than "get your server admin to rattle a stick up the pipe and see what comes down". Is there any advance on that? 2: Having now marked the order as Complete, how can I trigger the sending of a "Your Purchased Downloads" email, so our customer can get what he's paid for? I know I can copy/paste the download link and email it in a separate message, but it would be great if the site could do it for me, like it should. TIA, Robin
  9. CC6.2.9 / All In One Shipping 1.0.19 / PayPal Commerce Platform 1.3.20 Site: shop.robinsomes.co.uk I've just had a sale this evening, where the customer used a discount code to get 15% off the order. In the shop, the order appears to have processed perfectly: Sub-total: £3.50 15.14% discount: -£0.53 Total: £2.98 - see the first image attached below. However, looking at the PayPal transaction, there's no discount amount applied (image in first reply). Looking at the request log, there are 5 entries in red which look to be the cause of the problem (image in 2nd reply). Previous discounted orders have gone through OK; I've not knowingly changed anything about the site. Inevitable question: what do I do to prevent this happening again? TIA, Robin
  10. OK, got that, thanks. As I said to Al elsewhere in this thread, it's causing me no real trouble, so I'm content to sit and wait. Thanks again for your help. Robin
  11. Yes, that's correct. See the image below; 4 plugins - AIOS 1.0.18, SagePay 1.0.11, Facebook 1.0.1 and paypal_commerce 1.3.20 OK, done... Yes, it got logged: Today, 23:23 Request Sent (cURL) - https://www.cubecart.com/version-check/6.2.9?version=6.2.9&extensions[44]=1596699083&extensions[80]=1548263568&extensions[108]=1551776120&extensions[452]=1597078286version=6.2.9&extensions%5B44%5D=1596699083&extensions%5B80%5D=1548263568&extensions%5B108%5D=1551776120&extensions%5B452%5D=1597078286 Response received (200 - OK){"version":"6.2.9"} I'm reluctant to revert to older versions of any of my extension (even if such were available), as the site is still live. Can you suggest another extension with older versions available that I could install, to test whether or not it works for me? Many thanks again for your help. Robin
  12. Al, it's absolutely no problem to me, in the main I'm just curious as to what might be going on and whether it has any other implications. Whenever you get the chance, no worries. Robin
  13. Many thanks for the explanation. Just to confirm, yes, I've logged out of admin probably a dozen times since August 6th; aside from processing sales, I'm not logged in at all as a matter of course. Will check the details on the other site when I return to work tomorrow.
  14. Incidentally, I have just checked my own shop site (shop.robinsomes.co.uk). This was a completely fresh installation of CC 6.2.9 in March 2020, with very little customisation. The database has the table Cubecart_extension_info, and that table has 3 rows corresponding to the 3 extensions I have installed (ByWeight, All In One Shipping, and PayPal Commerce). CubeCart_inventory has a new column: 'latest' - CORRECT CubeCart_order_history has a new column 'initiator' - CORRECT CubeCart_coupons has a new column 'free_shipping' - CORRECT CubeCart_email_log is a new table - CORRECT CubeCart_extension_info is a new table - CORRECT CubeCart_coupons has a new column 'email_sent' - CORRECT However, the site still did not notify me that the latest version of PayPal Commerce Platform (1.3.18 to 1.3.20) was available. Robin
  15. Sorry, I was mis-reading 6.1.0 for 6.0.10... I can't access phpMyAdmin for my work account from home (well I probably could, but it would probably take me the rest of the evening to track down the correct username/pwd combination), so will have to return to your questions tomorrow morning. Thanks for your help, I appreciate it. Robin
  16. Replying from my home a/c, rather than work, hopefully this is still followable. Here is the full upgrade history from Advanced: Maintenance: Upgrade. The upgrades in April 2018, September 2018 and March 2019 were done by Al; fairly sure I did the rest. While the version installed has gone *past* 6.1.0, it doesn't appear to have gone *through* it. Hope that helps, Robin Upgrade History CubeCart Version Date 6.2.9 Tuesday, 12 May 2020 6.2.8 Tuesday, 12 May 2020 6.2.7 Tuesday, 12 May 2020 6.2.6 Tuesday, 12 May 2020 6.2.5 Friday, 19 July 2019 6.2.4 Monday, 25 March 2019 6.2.3 Monday, 25 March 2019 6.2.2 Monday, 10 September 2018 6.2.1 Monday, 10 September 2018 6.2.0-b1 Monday, 10 September 2018 6.1.15 Tuesday, 24 April 2018 6.1.14 Tuesday, 24 April 2018 6.1.13 Tuesday, 24 April 2018 6.1.11 Tuesday, 24 April 2018 6.1.9 Tuesday, 24 April 2018 6.1.7 Tuesday, 24 April 2018 6.1.6 Tuesday, 24 April 2018 6.1.5 Tuesday, 24 April 2018 6.1.4 Tuesday, 24 April 2018 6.1.2 Tuesday, 24 April 2018 6.1.0 Tuesday, 24 April 2018 6.0.12 Tuesday, 24 April 2018 6.0.11 Tuesday, 24 April 2018 6.0.9 Tuesday, 24 April 2018 6.0.7 Tuesday, 24 April 2018 6.0.6 Wednesday, 24 June 2015 6.0.5 Thursday, 4 June 2015
  • Create New...