Guest Posted February 25, 2006 Share Posted February 25, 2006 My website is quite new, but has been working ok for the first 10 or so orders, but today I had an apparent order as I received a payment confirmation from Paypal, but no order confirmation from OsCommerce and, neither can I see the order in admin. I have read about missing orders somewhere else, but cannot find in search. Is this a problem with OsCommerce, or simply a user fault (not pressing confirm etc)? I do not run SSL as PayPal does this. We only use paypal to process payment, not the checkout. /Tom Link to comment Share on other sites More sharing options...
rabbitseffort Posted February 25, 2006 Share Posted February 25, 2006 set the redirect in your paypal account under profile I think it to checkout_process.php you must not have a redirect set up there yet, hope this helps "I must admit that I personally measure success in terms of the contributions an individual makes to her or his fellow human beings." ---Margaret Mead--- "The answer is never the answer. What's really interesting is the mystery. If you seek the mystery instead of the answer, you'll always be seeking. I've never seen anybody really find the answer -- they think they have, so they stop thinking. But the job is to seek mystery, evoke mystery, plant a garden in which strange plants grow and mysteries bloom. The need for mystery is greater than the need for an answer. --Ken Kesey" Link to comment Share on other sites More sharing options...
OSCnewbie Posted February 26, 2006 Share Posted February 26, 2006 My website is quite new, but has been working ok for the first 10 or so orders, but today I had an apparent order as I received a payment confirmation from Paypal, but no order confirmation from OsCommerce and, neither can I see the order in admin.I have read about missing orders somewhere else, but cannot find in search. Is this a problem with OsCommerce, or simply a user fault (not pressing confirm etc)? I do not run SSL as PayPal does this. We only use paypal to process payment, not the checkout. /Tom Hi, and Om'gosh! The exact same thing happened to me yesterday! Mine is new also, I have fulfilled about 6-7 orders during the past 30 days or so, but yesterday the order did not get added to the database, although the customer account was set up ok. I only knew about it because PayPal informed me of a new payment received. I'm supposed to get copies of the order details, but nothing came through. I contacted the customer and gathered all the necessary details from him to fulfill the service order, but never did the order get placed into my osC db. I checked with my web host, they think the user may have input some characters that the script read as invalid and so it didn't complete itself. I don't see how a person could have gone through the entire process all the way to PayPal and have the whole thing simply vanish! I noticed the problem occurring almost immediately after it happened and so entered a sale myself (charging my own credit card), but all went as expected normally and without glitch! Any thoughts from the osc wise ones? Link to comment Share on other sites More sharing options...
rabbitseffort Posted February 26, 2006 Share Posted February 26, 2006 in case you didnt see the post above: set the redirect in your paypal account under profile I think it to checkout_process.php you must not have a redirect set up there yet, this si the cause of this--there are paypal contributions you can use also--but this simple solution solved it for me "I must admit that I personally measure success in terms of the contributions an individual makes to her or his fellow human beings." ---Margaret Mead--- "The answer is never the answer. What's really interesting is the mystery. If you seek the mystery instead of the answer, you'll always be seeking. I've never seen anybody really find the answer -- they think they have, so they stop thinking. But the job is to seek mystery, evoke mystery, plant a garden in which strange plants grow and mysteries bloom. The need for mystery is greater than the need for an answer. --Ken Kesey" Link to comment Share on other sites More sharing options...
OSCnewbie Posted February 26, 2006 Share Posted February 26, 2006 in case you didnt see the post above: set the redirect in your paypal account under profile I think it to checkout_process.php you must not have a redirect set up there yet, this si the cause of this--there are paypal contributions you can use also--but this simple solution solved it for me Thank you for your response...however, I have more than one site sending payments to the same PayPal account, so all must be set through the respective sites' scripts (each is set to send through differing email addresses in my PayPal account). If I do it in PayPal (as I understand it, maybe erroneously), all my payments would redirect to the one site--that would be way bad. I think that's a good solution for some, though. ;) Link to comment Share on other sites More sharing options...
omytfineo1 Posted February 26, 2006 Share Posted February 26, 2006 Hi, and Om'gosh! The exact same thing happened to me yesterday! Mine is new also, I have fulfilled about 6-7 orders during the past 30 days or so, but yesterday the order did not get added to the database, although the customer account was set up ok. I only knew about it because PayPal informed me of a new payment received. I'm supposed to get copies of the order details, but nothing came through. I contacted the customer and gathered all the necessary details from him to fulfill the service order, but never did the order get placed into my osC db. I checked with my web host, they think the user may have input some characters that the script read as invalid and so it didn't complete itself. I don't see how a person could have gone through the entire process all the way to PayPal and have the whole thing simply vanish! I noticed the problem occurring almost immediately after it happened and so entered a sale myself (charging my own credit card), but all went as expected normally and without glitch! Any thoughts from the osc wise ones? Link to comment Share on other sites More sharing options...
OSCnewbie Posted February 26, 2006 Share Posted February 26, 2006 omytfineo1, Did you have a thought? Link to comment Share on other sites More sharing options...
omytfineo1 Posted February 26, 2006 Share Posted February 26, 2006 omytfineo1, Did you have a thought? Hi, and Om'gosh! The exact same thing happened to me yesterday! Mine is new also, I have fulfilled about 6-7 orders during the past 30 days or so, but yesterday the order did not get added to the database, although the customer account was set up ok. I only knew about it because PayPal informed me of a new payment received. I'm supposed to get copies of the order details, but nothing came through. I contacted the customer and gathered all the necessary details from him to fulfill the service order, but never did the order get placed into my osC db. I checked with my web host, they think the user may have input some characters that the script read as invalid and so it didn't complete itself. I don't see how a person could have gone through the entire process all the way to PayPal and have the whole thing simply vanish! I noticed the problem occurring almost immediately after it happened and so entered a sale myself (charging my own credit card), but all went as expected normally and without glitch! Any thoughts from the osc wise ones? Hi, This just happened to me at my store (www.thekindredhomestead.com) where orders would be placed, payed successfully at paypal and absolutely no data transferred to my database for that order. So, I went and bought something myself from my store and payed with paypal. The last page on paypal there is a button called 'return to merchant'. When the customer does not click this button, for some reason the data does not get returned to the store. SO... I downloaded this contribution (http://www.oscommerce.com/community/contributions,2679/category,all/search,IPN) and things are working great!! Let me know if this helps you out.... Link to comment Share on other sites More sharing options...
OSCnewbie Posted February 26, 2006 Share Posted February 26, 2006 EUREKA!!!!!! I think I found a permanent fix, but please note that I haven't tried this myself yet. It is a contribution for PayPal, to prevent customers from going away from PayPal without their order being completed by the osc script. It can be found here: "MAKING PAYPAL RETURN ORDER DATA" http://www.oscommerce.com/community/contri...arch,Paypal+IPN In reading as much as available in the contribution, it appears to be the exact problem I'm experiencing. Would love to know what others have to say about it. I'm going to try it myself...'course, if it's working, we'll only know it because we never "see" another missing order (sorry for the oxymoron there :P ). And that could take weeks or months to realize. But, will post here again if I get another glitch someday after I install it... any comments, thoughts, or experience with it are certainly welcome. :) Link to comment Share on other sites More sharing options...
OSCnewbie Posted February 26, 2006 Share Posted February 26, 2006 Well, heck, jeez, sh*t, d*mn... the fix I thought would work, didn't do anthing to help. If a customer goes through PayPal to the screen that gives them a choice of (a) sign up with a PayPal account; or Return To Merchant, if the customer chooses (a), they are directed to a PayPal sign up page, but even though they have the option on that page to "Cancel and Return to Merchant," if they click it, they are not returned to the right place (I think checkout_confirmation.php??), but instead end up right back at the login screen, but NOT logged in. That's when their details get stuck in the customer basket. If they log in at that screen, they will see their order still in the basket as though they never checked out. I will now attempt the fix suggested by omytfineo1, above. Link to comment Share on other sites More sharing options...
rabbitseffort Posted February 26, 2006 Share Posted February 26, 2006 using paypal for more than one site will be difficult to make work out well I think--but if only using one site then the redirect url is checkout_process.php which stores the data then that goes right to checkout_success.php to let the customer know their order was successful. I was going to use paypal for more than one site but their user agreement says not to plus I didnt see how it would work with only one redirect option available. Maybe one of you will figure it out--I say easiest way may be to open another paypal account "I must admit that I personally measure success in terms of the contributions an individual makes to her or his fellow human beings." ---Margaret Mead--- "The answer is never the answer. What's really interesting is the mystery. If you seek the mystery instead of the answer, you'll always be seeking. I've never seen anybody really find the answer -- they think they have, so they stop thinking. But the job is to seek mystery, evoke mystery, plant a garden in which strange plants grow and mysteries bloom. The need for mystery is greater than the need for an answer. --Ken Kesey" Link to comment Share on other sites More sharing options...
maniac101 Posted February 26, 2006 Share Posted February 26, 2006 Just though I would chip in my 2 pence worth.. I run a site which very very occasionally has orders showing in paypal only - never shows in osc admin area as an order. I have put this down to the user actually clicking the wrong buttons on the site, rather then a redirect bug. In our case I imagine the user adds an item into the cart (or not) but then (incorrectly) clicks on the paypal / credit card images in our 'paypal infobox' - which we have under the shopping cart - this provides a link to paypal for direct payments ( not that anyone would/should use this). The user then manually puts in the amount and product info and checks out through paypal. I think on our site this is what they do as the odd 'paypal only'orders also sometimes contain no postage amount. Possibly you have the same issue ?? ie user error... ? I also have the 'recover carts' contrib so i can look in the users account cart and see the item they actually did end up ordering manually too so that confirms it a bit more. Mark Regards Mark Brindle Link to comment Share on other sites More sharing options...
Guest Posted February 26, 2006 Share Posted February 26, 2006 I had this problem too. I fixed it and have not had a single problem since. Basically you have a couple of options: 1-Install an alternative PayPal IPN which logs the order before the customer gets to PayPal. 2-Install the contribution called Better PayPal Description which sends the item names to PayPal. 3-Turn on auto return at PayPal, but this does not solve everything as PayPal has a policy where certain (new) customers can opt to not return to your site. 4-The worst option I think is to do none of this and e-mail the customer asking them what they purchased, totally unprofessional. I used a combination of #2 and #3 above along with text on my payment option page urging the customer to return to my site after the transaction is completed. I figure between these 3 measures I will all but eliminate this problem. It has proven to be very effective. Link to comment Share on other sites More sharing options...
Guest Posted February 27, 2006 Share Posted February 27, 2006 Great contribs. I think I must agree it seems like a user fault, or possibly a design error on my behalf for not making absolutely clear the navigation route, especially since I checked the redirect and it was already turned on. So, better try installing some contrib (Better PayPal Description?) here to make paypal confirm the product description as well and look to design pages better. Link to comment Share on other sites More sharing options...
OSCnewbie Posted February 28, 2006 Share Posted February 28, 2006 "... I downloaded this contribution (http://www.oscommerce.com/community/contributions,2679/category,all/search,IPN) and things are working great!! Let me know if this helps you out...." Hi, omytfineo1, Okay, so, with the PayPal IPN contrib, do you think that my multiple payment streams that I currently have with PayPal will still work correctly? If you're not familiar with what I mean, PayPal allows up to 7 email addresses in one account, each of which can receive money. I receive payments through a donation email address, my osc script email address, corporate work I do through my personal email address, and I think one more (can't remember). I'm hoping the contribution wouldn't affect anything on PayPal's website like the "auto-return" feature (which I don't have turned on for obvious reasons), is that a good assumption? For instance, the IPN contrib script wouldn't somehow tell PayPal to use its "auto-return" feature on payments I process, right? Thanks for your help! Link to comment Share on other sites More sharing options...
OSCnewbie Posted February 28, 2006 Share Posted February 28, 2006 "... I was going to use paypal for more than one site but their user agreement says not to plus I didnt see how it would work with only one redirect option available. ..." PayPal allows an accountholder to utilize up to 7 different email addresses to receive money. As long as you have the script set up on your website(s) to tell PayPal how to process and where to return visitors to, there isn't a conflict among the different email addresses (even from different websites). It's only when you want to use PayPal's own auto-return feature that you would run into problems using more than one email address to process your sales. As far as "more than one site," I haven't read that in the PayPal user agreement, can you point me to where that information shows? Thanks! Link to comment Share on other sites More sharing options...
thugpolice Posted July 12, 2006 Share Posted July 12, 2006 thank you all for this thread. it fixed my problem with missing orders and payments received. I used the redirect option and the contrib "Better PayPal Description_1_2_3". Thank again. :-) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.