hyepo 1 Posted August 20, 2018 Using os Commerce Online Merchant v2.3.4 BS with latest PayPal module.. All worked remarkedly well until last week. Two customers who checked out with PayPal standard (only running standard) had orders that they paid for though PayPal but on the orders page (admin) showed all their info and items but failed to show payment processed.. i.e. no history for the order. Still had an order number... everything worked fine except order history was blank.. when looking at “orders”, the status shows Preparing [Paypal standard] and when we click on the order, everything is there (i.e. what the customer ordered) but no history, no record of order being paid via paypal... two days earlier, another customer via paypal worked fine, Showing the paypal transaction in history and status was “pending” is it should be. I have changed NOTHING since installing this app prior to spring.... it worked great and does still when it works... but lately i have had a few orders not record the paypal transaction even though I received payment... and one order went through without even creating an order number and if not for paypal i would have never known the order was placed or paid for. I have not changed a single thing since this newer paypal module was installed.. i am only running paypal standard (which does a great job in listing items bought on the paypal side) but like i said, lately it is not sending the info back to osC and that, although seems to create the order, does not record the payment success in history. Images below: first is the orders page showing the status of the order, the second shows what does get recorded.. but no history... Any thoughts? Share this post Link to post Share on other sites
tgely 262 Posted August 20, 2018 Well mostly Preparing [Paypal Standard] status means that the checkout was canceled by the customer. Do you have incomes in PP account? If yes then may be call back url was missed or orders_id destroyed in orders_status_history data table. Check you PP incomes and orders_status_history table if are there any rows with null orders_id. This issue could be happen by admin side too when admin edit orders. This could be a session regeneration problem at admin side. osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Share this post Link to post Share on other sites
hyepo 1 Posted August 20, 2018 Yes.. payment received in PP... also shows order number in paypal... like i said, most of the time it works... once in awhile it does not record history.. i have never edited an order that I am aware of.... when it works, it works great.. but sometimes it just does not record the history... Share this post Link to post Share on other sites
♥14steve14 625 Posted August 21, 2018 I had this just the other day. Everything was working fine up to a few weekends ago. Then two orders were paid for but not recorded. Order numbers were passed to PayPal and in the orders list these numbers were missing. No emails were sent to either the store owner or the buyer. The items were still in the customers basket, as I was asking for help in emptying these baskets and completing the sale. It hasn't happened since, so I am assuming that it was either a website or PayPal glitch. Luckily the items purchased were saved at PayPal. REMEMBER BACKUP, BACKUP AND BACKUP Get the latest Responsive osCommerce CE (community edition) here It's very easy to over complicate what are simple things in life Share this post Link to post Share on other sites
hyepo 1 Posted August 21, 2018 Exactly... I believe it is a PayPal issue (although they feel otherwise) because I also use authorize.net and never have an issue there... all recorded sales show as expected .. only now with paypal do there seem to be issues of sales not being recorded.. the one thing here is the orders to show but do not show as being paid for in the history but do show method as being paypal... very odd indeed. Share this post Link to post Share on other sites
hyepo 1 Posted August 22, 2018 Today it worked perfectly ... no a darn thing has changed.... recorded sale, recorded on paypal and recorded transaction in history... order properly shows pending after accepting PayPal standard payment... doh! I think the program has gremlins.. Share this post Link to post Share on other sites
hyepo 1 Posted September 16, 2018 It’s been nearly a month and again, the same error occurs....in that PayPay charges and credits the customer and my paypal account respectfully, correctly OSCommerce only shows, in orders, the customer’s name and that “NO HISTORY” about the order is displayed ... the itemization of teh order is there, thankfully, and since paypal successfully paid me for the customer’s purchase, i can manually change status to pending (which is what it should have automatically been on its own)... but does not show the paypal standard as the first line of history (as it normally would). Has anyone else continued to see this error, and /or found a reliable solution.. need things like this to work without fail... 😞 Share this post Link to post Share on other sites
♥14steve14 625 Posted September 17, 2018 As it works for most of the time i wuld startlking outside of oscmmerce. Ask your hosts to find what happened at that time. Speak to paypal and get them to check their logs. Also speak to the customer as it may be something they use or did. REMEMBER BACKUP, BACKUP AND BACKUP Get the latest Responsive osCommerce CE (community edition) here It's very easy to over complicate what are simple things in life Share this post Link to post Share on other sites
astecme 15 Posted February 23, 2019 I have this as well. I have resent the ipn from PayPal to no avail. I sometimes also get payment and no order but the basket remains. Share this post Link to post Share on other sites
cyford33 0 Posted May 21, 2019 hello, Has this issue been fixed.. as we are still experiencing some orders not being updated after successful checkout. i read this forum i didnt see a fix however we see no rows with null order id.in orders_status_history table Share this post Link to post Share on other sites
peterbuzzin 34 Posted May 22, 2019 Does any of the affected sites and orders use any sort of discount module/functionality? i.e discount codes/coupons? I've seen this happen before due to the way tax is calculated and rounding in the store versus how PayPal calculates tax and discounts. When the two figures don't match up during the callback (usually 1pence/1cents difference) the store will not accept the result and the process fails, no emails sent, baskets not cleared etc. If it still don't work, hit it again! Senior PHP Dev with 18+ years of commercial experience for hire, all requirements considered, see profile for more information. Is your version of osC up to date? You'll find the latest osC version (the community-supported responsive version) here. Share this post Link to post Share on other sites
MrPhil 648 Posted May 22, 2019 If it's just some orders, and it's fairly old osC code, I've seen this problem with customers failing to properly return to the store after completing payment. That is, they "back" up or otherwise go off someplace else from the PayPal site, and never return to the store to complete the transaction. This assumes it's a PayPal mode that takes the customer offsite (to paypal.com). I think that some of the more recent osC versions may have code to successfully complete the transaction even if the customer never returns (but PayPal signals that it completed). You might look around at that (and discussion on this forum). Otherwise, it's operator error. About the best you could do is to put in a BIG REMINDER before they're sent off to the PayPal site that they need to come back to your store in a certain way, for the transaction to complete. Share this post Link to post Share on other sites
Cary 7 Posted February 17, 2020 Anyone ever discover the solution to this issue? Just stated happening on our site on Saturday night. I tested the process and "clicking" the return to merchant gives an Error: "Could not verify the PayPal transaction. Please try again." Nothing changed on the site and more than 24 hrs have passed since this began. All standard credit card pay work fine. Share this post Link to post Share on other sites
Mac Fly 30 Posted February 17, 2020 This has also started happening to me since Saturday night. Tested it myself and got the same result with the error message but received payment to our merchant Paypal account. I've Raised a ticket with Paypal support but haven't heard anything back yet Share this post Link to post Share on other sites
burt 5,421 Posted February 17, 2020 23 minutes ago, Cary said: Anyone ever discover the solution to this issue? Just stated happening on our site on Saturday night. I tested the process and "clicking" the return to merchant gives an Error: "Could not verify the PayPal transaction. Please try again." Nothing changed on the site and more than 24 hrs have passed since this began. All standard credit card pay work fine. Please also (as @Mac Fly has done) raise a support ticket with Paypal. Let's see what they have to say (to both)... Help shape the future of Phoenix; join the Phoenix Club Share this post Link to post Share on other sites
mfleeson 55 Posted February 18, 2020 I'm having the same issue, i receive a payment email from paypal but it doesn't call back to the website. Share this post Link to post Share on other sites
mhsuffolk 58 Posted February 18, 2020 38 minutes ago, mfleeson said: I'm having the same issue, i receive a payment email from paypal but it doesn't call back to the website. Replace your copy of ext/modules/payment/paypal/paypal.com.crt with this one paypal.com.crt 2 fiodh and mfleeson reacted to this Live Phoenix 1.0.5.0 on PHP 7.3 Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix 1.0.7.9) here. Share this post Link to post Share on other sites
mfleeson 55 Posted February 18, 2020 I found it on the other forum. Many thanks for the file. All ipn's are now working. Cheers. M Share this post Link to post Share on other sites
Tiff13 1 Posted March 14, 2020 THANK YOU all for this thread and special thanks to @mhsuffolk for posting the replacement cert with the additional certificate info - that fixed it for me too! Share this post Link to post Share on other sites
YsaacDLCX 0 Posted March 15, 2020 That fixed it for me too. Thank you very much! Share this post Link to post Share on other sites
fiodh 3 Posted May 18, 2020 Have installled but not tested it yet but thanks very much to mhsuffolk for posting the solution! Thanks all for the forum! Share this post Link to post Share on other sites
alexiscruz007 0 Posted October 20, 2020 I have the same problem but is in osco 2.2, and need fix. Share this post Link to post Share on other sites
Jack_mcs 1,020 Posted October 20, 2020 1 hour ago, alexiscruz007 said: I have the same problem but is in osco 2.2, and need fix. The fix is the same. The exception is if you have such an old version of paypal that it doesn't use the cert. In that case you need to install the Paypal App (found in the addons section). Support Links: Need Help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC version (the community-supported responsive version) here. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
alexiscruz007 0 Posted October 27, 2020 On 10/20/2020 at 11:24 AM, Jack_mcs said: The fix is the same. The exception is if you have such an old version of paypal that it doesn't use the cert. In that case you need to install the Paypal App (found in the addons section). thanks i wil trie. Share this post Link to post Share on other sites