PayPal payments go through... But orders don't show in OsCommerce??

[W?LD0]

Hi guys :)

 

I'm pretty new to using osCommerce so I apologise if I miss any info here. Just let me know of any other specifics I need to add about this problem and I'll post them up asap.

 

This is an assignment, but also for a real client so it's twice as important I work this out soon!

 

At the moment I'm running osCommerce on localhost and testing payments on PayPal Sandbox. Processing payments using "cash on delivery" etc work fine and customer orders show up in the osc database and admin.

 

However the payments I've been testing using PayPal don't process properly. Payments work right up until the end where I click on the "Return to Merchants" button and I get sent back to my website's Customer login page and I've been logged out (in other words I don't recieve the "checkout_success.php" page which says, "Thanks for shopping with us online!").

 

All payments in my PayPal Sandbox account have registered that a payment has been made - it works fine. The osc db thinks otherwise... The problem is that after payment I don't get sent to the "Checkout Success" page and, according to my database, the order hasn't been processed in osCommerce. I do however find that when I log back into my site as a customer the product is still sitting in my cart.

 

Has anyone had a problem like this before? Probably... I just couldn't find it. :huh:

 

I did a test where I viewed the source on the "Confirmation" page just before I make the payment in PayPal, and took the link:

"https://localhost/storename/catalog/checkout_process.php?osCsid=5cbff7693eb9e90a9512eb6996adaf54"

and pasted it into a new window... THAT WORKED and osCommerce registered that as a customer order. Payments just aren't picked up when coming back from a PayPal payment.

 

Sorry I know this is long but an help would be great.

 

Cheers

[MSP]

try using paypal ipn and see how you go

 

http://www.oscommerce.com/community/contributions,2679

[W?LD0]

Gday Mark, cheers for your help.

 

Another bloke in my class was having the same problem and landed on a forum with another solution - probably one which I would have never guessed!

 

I needed to go into the Website Payment Preferences of my business' Sandbox account and set Auto Return to "On".

 

I also needed to set the Return URL to: http://www.domainname.com/catalog/checkout_success.php

then saved it.

 

* The domainname did not need to be my own but still needed to be one which exists because PayPal checks for it...

 

Also, because I'm still running on a localhost I needed to go into c:\windows\system32\drivers\etc\host and add the same domain name after localhost

 

eg. 127.0.0.1 localhost domainname

 

 

I also setup PayPal IPN and that worked as well, so thanks for your help.

 

Hope this helps anyone else wth the same problem... I also hope this wasn't just common sense! :blink:

[ahaynes106]

Gday Mark, cheers for your help.

 

Another bloke in my class was having the same problem and landed on a forum with another solution - probably one which I would have never guessed!

 

I needed to go into the Website Payment Preferences of my business' Sandbox account and set Auto Return to "On".

 

I also needed to set the Return URL to: http://www.domainname.com/catalog/checkout_success.php

then saved it.

 

* The domainname did not need to be my own but still needed to be one which exists because PayPal checks for it...

 

Also, because I'm still running on a localhost I needed to go into c:\windows\system32\drivers\etc\host and add the same domain name after localhost

 

eg. 127.0.0.1 localhost domainname

I also setup PayPal IPN and that worked as well, so thanks for your help.

 

Hope this helps anyone else wth the same problem... I also hope this wasn't just common sense! :blink:

 

 

I noticed on PayPal's site it says "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." That sucks. Unfortunately the "Return to Merchant" link is not very obvious and I do not want to force customers to sign up with paypal. Is there a workaround for the standard paypal module?

 

Also, most threads and contributions I have searched deal with paypal IPN. What's the benefit of using that over the standard paypal?

 

Thanks!

[gameyeeeah]

I got the same problem, some buyer have pay the order, but cann't see in Oscommerce, about 10%,, and there have one order, the buyer didn't pay it, but success show on the oscommerce, i don't know why does this happen?

[MSP]

the benefit is that the order is written to the osc system before the customer is taken over to paypal. if you use the normal paypal module, then after the customer pays, they need to return to your store for the order to be written to the system. if they don't (which is common!) then you get paid, but no order written to your system which means you don't know what the customer ordered - big problem! (unless you only sell 1 item).

[bill110]

the benefit is that the order is written to the osc system before the customer is taken over to paypal. if you use the normal paypal module, then after the customer pays, they need to return to your store for the order to be written to the system. if they don't (which is common!) then you get paid, but no order written to your system which means you don't know what the customer ordered - big problem! (unless you only sell 1 item).

If you use the official paypal ipn module your return url at paypal is yourdomain/checkout_process.php.

isnt this other one the same way so the order is processed correctly?

 

this is from the installation text of oscommerce 2.2 milestone2 paypal ipn module

 

 

PayPal Account Configuration

AutoReturn

To minimise problems, enable the PayPal Auto Return in your PayPal account. Go to "Profile", click on "Website Payment Preferences". Set to "ON" and enter return path to the checkout_process.php file. Sample pathways are:

 

for sites with full SSL: https://yourdomain.com/checkout_process.php

for sites with shared SSL: https://yourserver.xssl.net/yourdomain.com/...ut_proccess.php

Customers will now be returned to your website automatically and unless the customers interrupts this process, the order process will be completed.

 

Note: Only enable AutoReturn if you have only shop linked to your PayPal account!

 

IPN

You do NOT need to enable the IPN in your PayPal account as all the required information is sent by the module. If you do wish to activate it, then the notify URL is the pathway to the /ext/modules/payment/paypal/ipn.php file.

 

 

and the link to the contribution

http://www.oscommerce.com/community/contributions,2679/

[Sanguinarius]

So, I'm confused. Do we point the url to *checkout process.php or *checkout_success.php?

 

I have the same problem the first fellow is having only I have the AUto Return set to "On" and my return url set to http://www.sanguinarius.org/store/checkout_success.php

 

It's been that way for a long time, and things were working as they should but recently (and I haven't changed anything), people are not getting their orders logged into my store's database.

 

Also, I can't very well print out PayPal's packing slip to use in lieu of my store's since the variables of the item are not being passed on to PayPal.

[ahaynes106]

Mine use to work as well until sometime in October. That's when I found this statementI alerady mentioned above, on PayPal's site in reference to Auto Return...

 

"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 basically it only auto returns paypal members who are paying with paypal.

 

IPN seemed kind of confusing to me and with so many contributions related to it, I was hoping to find a workaround for the basic module rather than trying to switch to IPN. May have to bite the bullet.

[ahaynes106]

IPN

You do NOT need to enable the IPN in your PayPal account as all the required information is sent by the module. If you do wish to activate it, then the notify URL is the pathway to the /ext/modules/payment/paypal/ipn.php file.

and the link to the contribution

http://www.oscommerce.com/community/contributions,2679/

 

so v1.4 at the link you provided above is all I need to convert over to IPN? I assume you are using this contribution and having no issues. If so, i will give it a go.

 

Thanks