osCommerce Community Support Forums > Official PayPal IPN Support Thread

Full Version: Official PayPal IPN Support Thread

osCommerce Community Support Forums > osCommerce Online Merchant v2.x > Contributions / Add-Ons > Payment Modules > Other

Pages: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73

sparky

Dec 3 2004, 11:45 AM

This support thread is for the osCommerce PayPal IPN Module v1.0 For 2.2MS2

Which can be downloaded from http://www.oscommerce.com/community/contributions,2679

Please post any support questions on this module here.

Any questions relating to any other contribution will likely be removed to keep this thread specific to the module above.

RavenWulf

Dec 3 2004, 04:08 PM

Sparky,

1st let me say thank you for the great mod! I can't believe just how easy it was to install!

My only question is: is there anyway to change the look of the payment area to be more like that of the ipn 2.9 version? (with the credit card logos, and popup info page) I think it is more inviting for people to see that they can use their credit cards, etc. than just looking at the paypal option.

Also is there anyway to getting some of the admin functionality of 2.9 into v1.0? Like the options for store logos, transpher screen color (plus being able to select more than just black or white), etc..

I know this is a completly different contrib, done by different people and I am very very gratefull to see that you are continuing with it. I just would like some of the eyecandy, and functions I have gotten used too, and think others would also find useful.

again, thank you for the work.

RavenWulf

QUOTE (sparky @ Dec 3 2004, 11:45 AM)

kfresh

Dec 3 2004, 05:18 PM

Okay... i know installed it... and i have one question... is there a way to pass the shipping address to Paypal? Because the details of the transaction in Paypal say "No address provided" and nothing is sent in the Paypal email notification...

k

PandA.nl

Dec 3 2004, 06:41 PM

Thanks for the module and support!

Just installed the module but I do have a serious problem, if an order is made the total amount is without tax. (Using the "old" default osC paypal module the price still is including tax, as it should)

Not sure if it could make a difference but I tried both "Per Item" "Aggregate" and it does not seem te make any difference.

Harald Ponce de Leon

Dec 3 2004, 06:47 PM

QUOTE (RavenWulf)

My only question is: is there anyway to change the look of the payment area to be more like that of the ipn 2.9 version? (with the credit card logos, and popup info page) I think it is more inviting for people to see that they can use their credit cards, etc. than just looking at the paypal option.

That can be done - can you provide a screenshot of how you think it should look like?

QUOTE (RavenWulf)

Also is there anyway to getting some of the admin functionality of 2.9 into v1.0? Like the options for store logos, transpher screen color (plus being able to select more than just black or white), etc..

We found these parameters to be redundant and offered only the Page Style parameter. This gives you greater control of how the pages at PayPal should look like.

Harald Ponce de Leon

Dec 3 2004, 06:48 PM

QUOTE (PandA.nl)

Just installed the module but I do have a serious problem, if an order is made the total amount is without tax. (Using the "old" default osC paypal module the price still is including tax, as it should)

This is how PayPal displays their prices on the front PayPal page. After the customer has logged in with their PayPal account, the full price is then shown, showing the appropriate shipping and tax fees involved.

Harald Ponce de Leon

Dec 3 2004, 06:50 PM

QUOTE (kfresh)

This was taken out at the last minute due to the Encryption Website Payments feature. The invoice number is the same as the order ID, so a reference can be made by looking at the order via the Administration Tool.

kfresh

Dec 3 2004, 07:18 PM

QUOTE (hpdl @ Dec 3 2004, 06:50 PM)

QUOTE (kfresh)

damn...is there anyway i can add the address to appear in the Paypal notifications? i'm setting this up for real lazy people...

k

Harald Ponce de Leon

Dec 3 2004, 10:46 PM

What would you like to do with the shipping address coming from PayPal?

kfresh

Dec 3 2004, 11:01 PM

QUOTE (hpdl @ Dec 3 2004, 10:46 PM)

What would you like to do with the shipping address coming from PayPal?

i just want it to appear in the Paypal email notifications and details.... it comes up blank with a comma now

k

PandA.nl

Dec 3 2004, 11:12 PM

QUOTE (hpdl @ Dec 3 2004, 08:48 PM)

QUOTE (PandA.nl)

A bit confusing I think (but I do understand it's PayPal's "fault"), especially if one tries to pay using a creditcard (not having a PayPal account). At the moment the creditcard info has to be entered the amount still is without tax. I couldn't test paying this way, because PayPal detected an account already was assigned to my creditcard (and so I was redirected to my account).

Since all my current customers need to pay the tax, I decided to make an admin option to move the tax to the total amount. Which was quite easy since it's written so well

Maybe it's just me that likes it better including tax, but if anyone else is interested I''ll post the easy changes to make.

toyicebear

Dec 4 2004, 02:05 AM

[quote=PandA.nl,Dec 3 2004, 11:12 PM]
This is how PayPal displays their prices on the front PayPal page. After the customer has logged in with their PayPal account, the full price is then shown, showing the appropriate shipping and tax fees involved.

[/quote]A bit confusing I think (but I do understand it's PayPal's "fault"), especially if one tries to pay using a creditcard (not having a PayPal account). At the moment the creditcard info has to be entered the amount still is without tax. I couldn't test paying this way, because PayPal detected an account already was assigned to my creditcard (and so I was redirected to my account).

Since all my current customers need to pay the tax, I decided to make an admin option to move the tax to the total amount. Which was quite easy since it's written so well

Maybe it's just me that likes it better including tax, but if anyone else is interested I''ll post the easy changes to make.

[/quote]

Please post it and/or pm it to me... ;-)

jonathn

Dec 4 2004, 08:25 AM

QUOTE (hpdl @ Dec 3 2004, 10:46 PM)

What would you like to do with the shipping address coming from PayPal?

This is confusing... Having two different areas discussing the same topic.

Just to point out what was said in the other forum:

"There's a problem with this contribution.... although it installs very fast... and it's great... it doesn't require an address to be chosen, nor can you verify the address where you're shipping your products.

If you don't mind losing anything... that's fine... just know this will show up on all your orders at paypal.

Seller Protection Policy:
Ineligible

That alone renders this module useless for those that sell anything of value.

Anyone working on a mod to verify addresses??"

I might add... you're going to drive my accountant crazy creating 2 different orders... what am I supposed to say?? well this one is valid... but this one is not?

jonathn

Dec 4 2004, 08:29 AM

QUOTE (hpdl @ Dec 3 2004, 10:46 PM)

What would you like to do with the shipping address coming from PayPal?

This other post might be informative seeing how you're trying to reinvent something someone has already created: Pay particular attention to the last paragraph.

devosc Today, 03:27 AM Post #1155
Gregory Baboolal

Group: Community Member
Posts: 959
Joined: 1-July 03
Member No.: 10,814

'popup_paypal.php' is the public catalog page for the popup info page shown (available) during checkout, it's name, e.g. 'popup_' is specifically chosen so as to be compatible for use with STS and not requiring any modifications of STS itself. It also serves up the css used on the catalog side, but this could also be achieved by specifying the explicit path to the css files used (templates/css).

In regard to the order status, or lack of, first look for the debug email and see what info is being shown.

For this module, v2.9, no settings need to made in your PayPal account profile, other than having a PayPal account, and possibly enabling Auto-Return, see the config and faqs.

Verifying addresses, PayPal will include info as to whether the address is confirmed. It is possible to do a cross tabulation to determine whether the order would be eligible for buyer protection but PayPal have advised against doing this at this time (or a while ago atleast).

In regard to some of the above posts, it should be noted that the other module is currently not suitable for downloadable media, the problem about changing the url to checkout_process.php without actually paying at PayPal still exists, so downloads still become immediately available. Also if using that module, one must ensure that Encryption is enabled in the PayPal IPN config otherwise the payment information is not obfuscated and from reading it's code it seems like that it is possible to send PayPal a payment for that order for only $0.01 and the module will accept the payment regardless of the expected actual order amount. Another aspect is that since that module prestores the order prior to the customer actually clicking the 'osCommerce Order Confirmation Button' the storeowner cannot determine whether the customer actually confirmed that they wanted to make the order, which prevents the storeowner from potentially following up the sale/order without any clear indication that the customer wanted to make the purchase.

korsh

Dec 4 2004, 08:38 AM

So far I have installed the new IPN from the OsCommerce team (easy) and tested (easy) and modified the look of it and the email sent out. Great simple solution. thank you.

but I do have another query. When I attempt to activate the IPN on my Pay Pal account it is asking for the URL at which I will receive the payment notifications. (see screenshot).

What is or where would I look for this URL address?

Am I correct in using the notify URL address line 330 catalog/includes/modules/payment/paypal_ipn.php as the URL requested in the PayPal activation in my PayPal account? (see screenshot).

CODE

$parameters['notify_url'] = tep_href_link('ext/modules/payment/paypal_ipn/ipn.php', '', 'SSL', false, false);

so the address to enter would be

CODE

www.mydomain.com/catalog/ext/modules/payment/paypal_ipn/ipn.php

I placed this query in the wrong area and have added it here.

James

korsh

Dec 4 2004, 09:13 AM

QUOTE (RavenWulf @ Dec 3 2004, 12:08 PM)

Sparky,

1st let me say thank you for the great mod! I can't believe just how easy it was to install!

My only question is:� is there anyway to change the look of the payment area to be more like that of the ipn 2.9 version? (with the credit card logos, and popup info page)� I think it is more inviting for people to see that they can use their credit cards, etc. than just looking at the paypal option.

Also is there anyway to getting some of the admin functionality of 2.9 into v1.0? Like the options for store logos, transpher screen color (plus being able to select more than just black or white), etc..

I know this is a completly different contrib, done by different people and I am very very gratefull to see that you are continuing with it.� I just would like some of the eyecandy, and functions I have gotten used too, and think others would also find useful.

again, thank you for the work.

RavenWulf

Yes, I modified the look tyo be comparable to v2.9 adding the following code to checkout_payment.php at line 252

CODE

<td class="main" colspan="3" nowrap><?php
� � � � � � � � � � if ($selection[$i]['module'] == 'PayPal IPN') {
� � � � � � � � � � � ?>
� � � � � � � � � � � � <big><b>
� � � � � � � � � � � � � Credit Card
� � � � � � � � � � � � � � <img src="images/logo_ccVisa.gif" � � � � � � alt="Visa" width="37" height="21" � � border="0" � � � � � �align="bottom" title=" Visa ">
� � � � � � � � � � � � � � <img src="/images/logo_ccMC.gif" � � � alt="MasterCard" width="37" height="21" � � � border="0" � � �align="bottom" title=" MasterCard ">
� � � � � � � � � � � � � � <img src="/images/logo_ccDiscover.gif" � � � � alt="Discover" width="37" height="21" border="0" � � � �align="bottom" title=" Discover ">
� � � � � � � � � � � � � � <img src="/images/logo_ccAmex.gif" alt="American Express" width="37" height="21" � � border="0"align="bottom" title=" American Express ">
� � � � � � � � � � � � � or
� � � � � � � � � � � � � � <img src="/images/banner_intl.gif" � � � � � alt="PayPal" width="88" height="33" � � �border="0" � � � � �align="bottom" title=" PayPal ">
� � � � � � � � � � � � </b></big>
� � � � � � � � � � � � � <br>
� � � � � � � � � � � � � You do not need to be a PayPal member to pay by credit card.
� � � � � � � � � � � � � <script>
� � � � � � � � � � � � � � document.writeln('<a style="cursor:hand" onclick="javascript:popup=window.open('
� � � � � � � � � � � � � � � � � � � � � �+ '\'http://www.mydomain.com/catalog/CreditCardExplain.htm\',\'popup\','
� � � � � � � � � � � � � � � � � � � � � �+ '\'scrollbars,resizable,width=625,height=800,left=50,top=50\'); popup.focus(); return false;">'
� � � � � � � � � � � � � � � � � � � � � �+ '<font color="blue"><u>[info]</u></font></a>');
� � � � � � � � � � � � � </script><noscript>
� � � � � � � � � � � � � � <a href="CreditCardExplain.html" target="_blank"><font color="blue"><u>[info]</u></font></a>
� � � � � � � � � � � � � </noscript>
� � � � � � � � � � � <?php
� � � � � � � � � � } else if ($selection[$i]['module'] == 'Check/Money Order') {
� � � � � � � � � � � ?><big><b>Check or Money Order </b></big>
� � � � � � � � � � � � <img src="/check.gif" border=0 alt=" Send Us a Check " align="absmiddle">
� � � � � � � � � � � <?php
� � � � � � � � � � } else {
� � � � � � � � � � � echo '<big><b>' . $selection[$i]['module'] . '</b></big>';
� � � � � � � � � � }
� � � � � � � � � ?></td>

and using CreditCardExplain.html from the contributions for a start I also changed the email notification in paypal_ipn.php

hth James

sparky

Dec 4 2004, 01:31 PM

QUOTE (korsh @ Dec 4 2004, 08:38 AM)

but I do have another query. When I attempt to activate the IPN on my Pay Pal account it is asking for the URL at which I will receive the payment notifications. (see screenshot).

What is or where would I look for this URL address?

You dont need to activate IPN on your account, by sending the notify_url with the payment IPN is automatically configured for your store.

From the paypal dev guide

QUOTE

Specifying Your Notification URL

If you only need to receive your IPNs at a single URL, you can enter that URL in the
Preferences section of your Profile.

If you would like to receive payment notifications for different payments at different
URLs (i.e. if you need to separate payments made to different websites you run), you
can manually pass the IPN URL with each payment by including it in that payment�s
HTML code. Use the notify_url field to pass this information.

The notify_url for a specific payment will be saved, and any subsequent updates to
that payment (e.g. cleared eCheck) will be sent to that notify_url. When you pass a
notify_url in your HTML code, it will override any preferences you set in your Profile.

sparky

Dec 4 2004, 01:34 PM

QUOTE (jonathn @ Dec 4 2004, 08:29 AM)

This other post might be informative seeing how you're trying to reinvent something someone has already created: Pay particular attention to the last paragraph.

This isnt a new problem regarding downloads

The point of this IPN module is to make it very easy to install so that you dont spend forever editing core files. There is an ease of use v's flexability trade off however.

jonathn

Dec 4 2004, 03:27 PM

QUOTE (sparky @ Dec 4 2004, 01:34 PM)

This isnt a new problem regarding downloads

The point of this IPN module is to make it very easy to install so that you dont spend forever editing core files. There is an ease of use v's flexability trade off however.

tradeoff??

You're trading off security without shipping to an address that's unverified.

The Sellers Protection Policy is there to protect us, the business owners. Ship something for $1000 to a fradulent address and then try to collect.... or for that matter, get your item back.

Personally, or any business owner I know wouldn't ship anything to an unverified address.

Ever wonder why the credit card companies insist you ship to the same address that the credit card sends the customers statement??

This module has serious "security" shortcomings.... no matter how simplistic it is to install.

korsh

Dec 4 2004, 07:04 PM

QUOTE (sparky @ Dec 4 2004, 09:31 AM)

You dont need to activate IPN on your account, by sending the notify_url with the payment IPN is automatically configured for your store.

From the paypal dev guide

Thank you, I am glad that is cleared up.

korsh

Dec 4 2004, 09:25 PM

I would like to change the PayPal payment details showing using this contribution

Sales tax to GST (the Australian taxation)
and one instance of the total amount
which appears twice see screenshot
Does any one know where I can make these changes?

James

verbalkent

Dec 4 2004, 10:43 PM

I just installed it, I have a test sandbox acct set up, downloaded the test cert, and uploaded it to my server, on a test purchase, i get this on the "checkout_configuration" page

Warning: fopen(/ipn_tmp/732583-2-data.txt): failed to open stream: No such file or directory in /home/virtual/site243/fst/var/www/html/includes/modules/payment/paypal_ipn.php on line 349

Warning: fwrite(): supplied argument is not a valid stream resource in /home/virtual/site243/fst/var/www/html/includes/modules/payment/paypal_ipn.php on line 350

Warning: fclose(): supplied argument is not a valid stream resource in /home/virtual/site243/fst/var/www/html/includes/modules/payment/paypal_ipn.php on line 351

any help?

sparky

Dec 5 2004, 02:11 PM

QUOTE (jonathn @ Dec 4 2004, 03:27 PM)

This module has serious "security" shortcomings.... no matter how simplistic it is to install.

Then dont use it.... The beauty of free software is you have a choice

Mibble

Dec 5 2004, 02:18 PM

this error is telling you that you dont have a directory at /ipn_tmp, thus just as in the store configuration, for logging, cache, sessions, where you NEED to create a tmp directory, you do the same here, however I would point it to the same directory you created in the above items (you did do that?) with 700 permissions, if 700 doesnt work then 777. and this needs to be above the document root, ie /home/username/tmp.
it is alwo trying to write, and it cant do that, and then close and it cant do that as it doesnt exist.
thus, if you are going to specify a working directory, then create it.

QUOTE (verbalkent @ Dec 4 2004, 05:43 PM)

Harald Ponce de Leon

Dec 5 2004, 02:36 PM

QUOTE (sparky @ Dec 5 2004, 03:11 PM)

Then dont use it.... The beauty of free software is you have a choice

Yep - next time we have to make sure that the first v1.0 release of anything also automatically polishes shoes too

The feedback provided will indeed influence the next v1.1 release of the module - but if you're only going to criticize, then please do so outside in the middle of the fields somewhere.

Thanks,

Harald Ponce de Leon

Dec 5 2004, 02:41 PM

QUOTE (korsh)

Can you post the form parameters used on the checkout confirmation page from viewing the HTML source? (please just the form parameters and not the whole checkout confirmation page -thanks)

rgloverd

Dec 5 2004, 03:00 PM

Hi, I was having a problem with 2.9 (the update order status problem) so I have now just installed the new 1.0 version from oscommerce but im still having the same problem. COuld someone post example config of what should be in each box when you eidt the config for this payment module. Also what needs to be done in the paypal account if it is a new paypal account?
Thanks,
Richard

Harald Ponce de Leon

Dec 5 2004, 03:42 PM

What problem are you having?

Did you read through the included documentation?

Are you using the right gateway server? By default the module is using the Sandbox/Testing server PayPal provides, and is independent from the Live server.

devosc

Dec 5 2004, 04:24 PM

QUOTE (rgloverd @ Dec 5 2004, 10:00 AM)

If you have not enabled encryption in the PayPal IPN config, then try out a test purchase and on the osCommerce order confirmation page, view the source and scroll or search for 'notify_url', the value of this form field should be 'qualified', e.g. a full URL path to the ipn script, so if you can't see 'http://www.yourdomain.com/.......' then check your catalog/includes/configure.php and make sure that:

CODE

define('HTTP_SERVER', 'https://'.$_SERVER['SERVER_ADDR']); // eg, http://localhost - should not be empty for productive servers
define('HTTPS_SERVER', 'https://'.$_SERVER['SERVER_ADDR']); // eg, https://localhost - should not be empty for productive servers
define('ENABLE_SSL', true); // secure webserver for checkout procedure?

is correct, in the above replace "'https://'.$_SERVER['SERVER_ADDR']" with the URL of your domain ('http://www.mydomain.com'), and if you don't have SSL then set 'ENABLE_SSL' to false.

In regard to feedback, it should be noted that PayPal themselves sometimes return an 'INVALID' response even though the transaction is authentic and qualified, a workaround suggested by PayPal is to return a 500 Server Error response which will cause PayPal to resend the IPN so that it maybe successfully processed on the following attempts etc...

korsh

Dec 5 2004, 07:11 PM

QUOTE (hpdl @ Dec 5 2004, 10:41 AM)

Can you post the form parameters used on the checkout confirmation page from viewing the HTML source? (please just the form parameters and not the whole checkout confirmation page -thanks)

CODE

Harald Ponce de Leon

Dec 5 2004, 07:56 PM

James, does it also occur on the PayPal login page (the first page at PayPal once submiting the form) or anywhere else?

korsh

Dec 6 2004, 03:35 AM

QUOTE (hpdl @ Dec 5 2004, 03:56 PM)

James, does it also occur on the PayPal login page (the first page at PayPal once submiting the form) or anywhere else?

Harald, thanks for your prompt reply.

No it occurs only on the second page.

see screenshots

rgloverd

Dec 6 2004, 11:48 AM

Hi,
Just worked out what the problem was, as the shop I am creating is not live yet, I had protected the shop with a password and obviously paypal didnt have the password, doh!!! One of those stupid simple mistakes that you just dont think of :-)
But thanks for the help,
Richard

RavenWulf

Dec 6 2004, 03:56 PM

Howdy!

ok here are 2 screen shots. The 1st shows both paypal contribs for comparison. You will notice that the 2.9 version shows credit card icons, a short discription and also a link to a popup info page (this is the second screen shot). I really like how it is visible to the customer that even though they are using paypal they can use their creditcards, etc.

Hope this helps.

(and thanks for the hard work!)

On Page Style..is this just a "link" to the paypal style? so if I set things up on the paypal end everything goes well? sorry I really don't understand how all the options from 2.9 can be summed up in one option.

RW

QUOTE (hpdl @ Dec 3 2004, 06:47 PM)

We found these parameters to be redundant and offered only the Page Style parameter. This gives you greater control of how the pages at PayPal should look like.

Harald Ponce de Leon

Dec 6 2004, 11:21 PM

QUOTE (RavenWulf)

The following can be defined in a Page Style:

Header Image URL; Maximum size 750x90)
Header Background Color
Header Border Color
Background Color

Page Styles can be defined at the Profile->Selling Preferences->Customer Payment Pages page.

Harald Ponce de Leon

Dec 6 2004, 11:41 PM

QUOTE (korsh)

Harald, thanks for your prompt reply.

No it occurs only on the second page.

Confirmed. It appears to only happen when the shipping and tax values are being passed to PayPal.

I've contacted Patrick about this and will reply back once the problem is known.

Harald Ponce de Leon

Dec 7 2004, 12:30 AM

QUOTE (jonathn)

Also if using that module, one must ensure that Encryption is enabled in the PayPal IPN config otherwise the payment information is not obfuscated and from reading it's code it seems like that it is possible to send PayPal a payment for that order for only $0.01 and the module will accept the payment regardless of the expected actual order amount.

Confirming the order total value will be done in the next v1.1 contribution release.

QUOTE (jonathn)

Another aspect is that since that module prestores the order prior to the customer actually clicking the 'osCommerce Order Confirmation Button' the storeowner cannot determine whether the customer actually confirmed that they wanted to make the order, which prevents the storeowner from potentially following up the sale/order without any clear indication that the customer wanted to make the purchase.

Actually, store owners can. The order is finally updated when the IPN notification is received - regardless if the customer returns back to the store or not after payment has been made.

Harald Ponce de Leon

Dec 7 2004, 12:38 AM

QUOTE (jonathn)

You're trading off security without shipping to an address that's unverified.
The Sellers Protection Policy is there to protect us, the business owners. Ship something for $1000 to a fradulent address and then try to collect.... or for that matter, get your item back.

Personally, or any business owner I know wouldn't ship anything to an unverified address.

Ever wonder why the credit card companies insist you ship to the same address that the credit card sends the customers statement??

You hit the nail on the head with the "Ever wonder why..." statement, because PayPal does not accept a shipping address to be passed when passing the order parameters to their gateway.

The address that can be passed is only used for prepopulating the address fields when the customer wishes to create a PayPal account.

The PayPal IPN module disables the option for the customer to define a shipping address at the PayPal gateway due to the inconsistencies it can create with the order (the shipping address is already defined at the catalog/shopping-cart).

It is possible to determine whether or not a PayPal account has been verified by looking at the transaction details at your PayPal account/profile for the order made.

zzfritz

Dec 7 2004, 05:57 AM

I had an opportunity to install and test the prerelease version from 11/26, and found it worked fine.

Today I noticed the official contribution had been made, so I replaced all the files and installed it (after removing the old one, of course). Then I had someone test it, and the order went okay including the confirmation email, being listed in admin, and PayPal had the money. But she did not get returned to the confirmation success page, getting instead the error message:

Fatal error: Cannot redeclare class order_total in /home/sonnybar/public_html/osc/includes/classes/order_total.php on line 13

While I sleuth this myself, I am posting hoping perhaps someone else will recognize the symptom more readily and save me some time/frustration. I really don't believe there had been any other relevant changes to the site. But I don't see any differences between the old and new scripts that appear likely to generate an extra class declaration ... hmm ...

Mibble

Dec 7 2004, 06:05 AM

means the class order_total is being declared twice, so you need to search your code to find it. this happens with an older version of IPN being installed, you will most likely need to go thru all your code and find references to where it is calling paypal (not an easy chore) and then try again. if not many contributions, may be better off starting with a clean install, put in the new paypal mod and the other contributions and then the language files and the stylesheet, images and it will work. in a nutshell anyway

zzfritz

Dec 7 2004, 06:44 AM

you state the obvious, mibble ... I guess that's how you racked up so many posts

Inspecting the code, this appears to be a clash between Authorizenet Consolidated 1.7 and PayPal IPN. The authorizenet mod to checkout_process.php has its own 'new order_total' embedded inline, before the standard code calls all the payment modules' before_process(), which in the case of PayPal IPN includes another 'new order_total' instance.

Can someone suggest a workaround? [specifics, not generalities]

devosc

Dec 7 2004, 11:04 AM

QUOTE (zzfritz @ Dec 7 2004, 01:44 AM)

Lines 384 to 387 of paypal_ipn.php should read:

CODE

�if(!class_exists('order_total')) {
� �include_once(DIR_WS_CLASSES . 'order_total.php');
� �$order_total_modules = new order_total;
�}
$order_totals = $order_total_modules->process();

Edit: moved $order_totals outside clause.

Mibble

Dec 7 2004, 12:58 PM

which paypal_ipn.php are you talking about Greg? i cound not find that in the current, unless there are new files again . .

thefoxrox

Dec 7 2004, 01:18 PM

Hello, I am new to osCommerce, have set up my cart to download products and am going to use paypal for payment. Couldn't get total to pass to paypal and was lead to believe paypal ipn might be solution to my problems so have installed it but not sure how to configure. I have pasted my current settings below. Am not sure about whole private key, public cert thing, can someone please explain this to me as this is last thing I need to do before cart is operational. All help appreciated...

PayPal IPN

Enable PayPal IPN Module
True

E-Mail Address
my paypal account email address

Transaction Currency
Only GBP

Payment Zone
--none--

Set Preparing Order Status
default

Set PayPal Acknowledged Order Status
default

Gateway Server
Live

Transaction Type
Aggregate

Page Style

Debug E-Mail Address

Sort order of display.
0

Enable Encrypted Web Payments
False

Your Private Key

Your Public Certificate

PayPals Public Certificate

Your PayPal Public Certificate ID

Working Directory

OpenSSL Location
/usr/bin/openssl

cwispy

Dec 7 2004, 04:17 PM

QUOTE (devosc @ Dec 7 2004, 07:04 PM)

Lines 384 to 387 of paypal_ipn.php should read:

CODE

�if(!class_exists('order_total')) {
� �include_once(DIR_WS_CLASSES . 'order_total.php');
� �$order_total_modules = new order_total;
�}
� �$order_totals = $order_total_modules->process();

Edit: moved $order_totals outside clause.

I tried editing the file as you stated above, but it still gives the total twice on testing it with sandbox. Any other ideas on how or why it is sending amount and amount_1 to paypal?

cwispy

devosc

Dec 7 2004, 09:36 PM

QUOTE (cwispy @ Dec 7 2004, 11:17 AM)

I tried editing the file as you stated above, but it still gives the total twice on testing it with sandbox. Any other ideas on how or why it is sending amount and amount_1 to paypal?

cwispy

This problem is not related to the edit mentioned above, I also checked paypal's sandbox using the other contrib and saw the discrepency also, so it seems to be a PayPal problem, harald already mentioned that this has been raised with them.

In regard to the $order_totals edit above, $order_totals would also need to be added to the list of global vars above so this part of the script should now look like:

QUOTE

function before_process() {
global $customer_id, $order, $sendto, $billto, $payment, $currencies, $cart, $cart_PayPal_IPN_ID, $order_totals;
global $$payment;

if(!class_exists('order_total')) {
include_once(DIR_WS_CLASSES . 'order_total.php');
$order_total_modules = new order_total;
$order_totals = $order_total_modules->process();
}

Note I moved $order_totals back into the clause (per other contrib), this is because if using CCGV then that contrib moves $order_totals before the default osCommerce checkout process method call to $payment_modules->before_process();

mtblair

Dec 8 2004, 12:43 AM

I've installed the osCommerce Paypal IPN contrib and it works fine in the sandbox. When I switch to the production Paypal server and issue a transaction:

1. the user returns after making a payment,
2. the order confirmation email is sent and
3. the stock is updated appropriately (problems I had with the other Paypal IPN contrib),

but the status is not set to "Pending". The status remains at "Preparing Paypal IPN" and an order history record is created, which the user can see.

From the install doc, I gathered that if the transaction came back VERIFIED, the status was changed and a history record created. Otherwise, nothing changes (status or stock) and a history record is not created.

Any clues or have I misinterpreted the doc?

zzfritz

Dec 8 2004, 01:05 AM

I found that order status was not being updated because the query string in ipn.php searched on both the order number and the customer id, and the latter was not in the POST vars as apparently expected. I edited the query, and the order status is being updated now.

It is also important to note that IPN is not instantaneous: the status did not change from the interim 'Preparing [PayPal IPN]' for a few minutes and in one case it took 18 minutes before the verification was received and the order status updated.

devosc

Dec 8 2004, 02:15 AM

QUOTE (zzfritz @ Dec 7 2004, 08:05 PM)

If your saying you removed the customer_id from the query (it should be the $_POST['custom'] field), then you've just removed any form of security currently available, the encryption of the form fields only serves as a mask, and the customer_id is the only value that can not be readily determined, one can determine the expected order_id from the customer's account history and the contribution does not currently implement any additional checks as suggested by paypal, receiver id and payment amount, need to put it back....

Harald Ponce de Leon

Dec 8 2004, 02:26 AM

QUOTE (mtblair)

but the status is not set to "Pending".� The status remains at "Preparing Paypal IPN" and an order history record is created, which the user can see.

From the install doc, I gathered that if the transaction came back VERIFIED, the status was changed and a history record created.� Otherwise, nothing changes (status or stock) and a history record is not created.

That is partly correct. An order status history entry is made regardless if the transaction came back as VERIFIED or not, and stores the appropriate transaction status information along with the order status string.

If the order status is only the Preparing status, then the IPN notification was more than likely not received, or malformed as Fritz describes with the customer ID not existing in the "custom" parameter value.

QUOTE (zzfritz)

Do you have any contributions installed that affect the checkout procedure? The customer ID is passed to PayPal as the "custom" parameter, and the IPN notification should contain it.

QUOTE (zzfritz)

It is also important to note that IPN is not instantaneous: the status did not change from the interim 'Preparing [PayPal IPN]' for a few minutes and in one case it took 18 minutes before the verification was received and the order status updated.

I haven't experienced such long delays during development on the Sandbox server - it is something that the module has no influence over though.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.

OSCOMMERCE SUPPORT CALL 702-453-3332