Jump to content


Corporate Sponsors


Latest News: (loading..)

* * * * * 3 votes

Official PayPal IPN Support Thread


4127 replies to this topic

#341 Maquar

  • Community Member
  • 61 posts
  • Real Name:Mark

Posted 18 March 2005, 00:27

Hello everyone,

I've just installed PayPal IPN v1.1 but am kind of lost on a few things. I'm hoping one of you will help me out here. My hosting uses a shared SSL, I have read the instructions given with the PP IPN and have searched the forums but haven't had any luck. With that said heres what I'm lost on:

Gateway Server
Live (I'm assuming this needs to be live?)

Enable Encrypted Web Payments
True (I'm assuming this needs to be set to true to use the SSL?)

Your Private Key
(Where in My PayPal account do I obtain this if needed?)

Your Public Certificate
(Where in My PayPal account do I obtain this if needed?)

PayPals Public Certificate
(Where in My PayPal account do I obtain this if needed?)

Your PayPal Public Certificate ID
(Where in My PayPal account do I obtain this if needed?)

Working Directory
(Where in My PayPal account do I obtain this if needed?)

OpenSSL Location
/usr/bin/openssl (Should this be set to the shared SSL location that I used for the set up of the shop? For example..https//mydomain.com/~name)

Can someone please help me out?

Thanks,

Mark

#342 wheeloftime

  • Community Member
  • 2,338 posts
  • Real Name:Howard
  • Gender:Male
  • Location:Universe

Posted 18 March 2005, 02:31

Maquar, on Mar 18 2005, 01:27 AM, said:

Hello everyone,

I've just installed PayPal IPN v1.1 but am kind of lost on a few things. I'm hoping one of you will help me out here. My hosting uses a shared SSL, I have read the instructions given with the PP IPN and have searched the forums but haven't had any luck. With that said heres what I'm lost on:

Gateway Server
Live (I'm assuming this needs to be live?)

Enable Encrypted Web Payments
True (I'm assuming this needs to be set to true to use the SSL?)

Your Private Key
(Where in My PayPal account do I obtain this if needed?)

Your Public Certificate
(Where in My PayPal account do I obtain this if needed?)

PayPals Public Certificate
(Where in My PayPal account do I obtain this if needed?)

Your PayPal Public Certificate ID
(Where in My PayPal account do I obtain this if needed?)

Working Directory
(Where in My PayPal account do I obtain this if needed?)

OpenSSL Location
/usr/bin/openssl (Should this be set to the shared SSL location that I used for the set up of the shop? For example..https//mydomain.com/~name)

Can someone please help me out?

Thanks,

Mark

<{POST_SNAPBACK}>


Go to page 7 from this thread and most of your questions will be answered and a few others are clearly explained inside the installation file with this contribution !

As for a few of your questions:

Quote

Gateway Server
Live (I'm assuming this needs to be live?)
This needs to be Live when you have it all working properly and are using it in your live shop. Before that leave it at Testing so you can test it through the Paypal Sandbox server.

Quote

Working Directory
(Where in My PayPal account do I obtain this if needed?)
This has nothing to do with Paypal. It is a directory on your own server where temporary files can be stored (just like you use for the osC caching/session temporary directory).

Quote

OpenSSL Location
/usr/bin/openssl (Should this be set to the shared SSL location that I used for the set up of the shop? For example..https//mydomain.com/~name)
Normally you can leave this as it is. It is an application provided by your host and has nothing to do with your shared SSL. If your host has installed this to another location you will have to ask them what the location is. If they haven't installed it at all you have a problem (this you can check through Admin->Tools->Server Info).

Be aware that the osC Paypal IPN encrypted web payments option stands seperate from your own (shared) SSL. It is meant to encrypt your osC order details during the 1 second or less when the customer leaves your site (with your SSL protection) and going to the Paypal payment pages (protected by the Paypal SSL). During that short moment the order details from your shop are vulnerable and that's where the osC Paypal IPN encrypted web payments option comes into play.

HTH

#343 MountainMan

  • Community Member
  • 46 posts
  • Real Name:SteveW
  • Gender:Male

Posted 18 March 2005, 16:45

My volume discounts are lost when the user winds up at the PayPal site to make the payment. What shows is the order total before discounts.

I am using the Price Sensitive Discount V2.3 contribution from Ian Wilson.

The discount does appear on the Order Confirmation page (checkout_confirmation.php) and the discount does work for my other payment option (2Checkout) and previously worked for PayPal via an earlier IPN contribution whcih has been removed.

This discount module was an incredibly easy install with no hacking and just two added files, and the discount kind of appeared automatically during the Order Confirmation which I understand is as designed, so I am puzzled why it is not appearing for the new PayPal IPN module.

#344 bettysue

  • Community Member
  • 29 posts
  • Real Name:Betty

Posted 18 March 2005, 19:56

Please don't slam me for this question, but could someone tell me which of the files I download to install this mod on a US based store?

So far I've downloaded most of them, yet each is named differently so it really is hard for a newbie who hasn't worked with OSC in over a year to figure out.

Thank You,

Betty

#345 dragonfoundry

  • Community Member
  • 22 posts
  • Real Name:Paul Howard

Posted 21 March 2005, 19:41

dragonfoundry, on Mar 17 2005, 08:09 PM, said:

Right i have the situation where the cart contents, total, postage are passed to paypal sandbox and the order progresses nicely however when it is completed and i click "return to Merchant" i get the following error

Fatal error: Cannot redeclare tep_db_connect() (previously declared in /home/********/public_html/gallery/includes/functions/database.php:13) in /home/********/public_html/gallery/includes/functions/database.php on line 13
The order goes through and the admin section is updated once the payment goes through but no stock its deducted.

Anyone got any ideas where i am going wrong?  :(

<{POST_SNAPBACK}>



Is it that im dont have a SSL certificate? :blink:

#346 OPAL829

  • Community Member
  • 6 posts
  • Real Name:Opal

Posted 21 March 2005, 20:56

I just installed this contrib and am getting these errors when I go to Admin > Configuration > Modules > Payments

Quote

Warning: main(/home/lupid/public_html/marketplace/includes/languages/english/modules/payment/paypal_ipn.php): failed to open stream: No such file or directory in /home/lupid/public_html/marketplace/admin/modules.php on line 128

Warning: main(/home/lupid/public_html/marketplace/includes/languages/english/modules/payment/paypal_ipn.php): failed to open stream: No such file or directory in /home/lupid/public_html/marketplace/admin/modules.php on line 128

Warning: main(): Failed opening '/home/lupid/public_html/marketplace/includes/languages/english/modules/payment/paypal_ipn.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/lupid/public_html/marketplace/admin/modules.php on line 128

I followed the instructions in the contrib zipped file and placed all the php files in the directory structure in my oscommerce catalog.

PLEASE someone help. :'(

#347 jeffk

  • Community Member
  • 13 posts
  • Real Name:jeff.keeling

Posted 22 March 2005, 14:15

hi

upgraded to this module from a previous version by a diffrent author , its working fine . the only thing i miss is the order number in the email from the store

it used to send an email with the - subject NEW - Order Process #894

now all i get is - Order Process

as i drop shipp all my orders having the order number in the email makes it easy to track the orders

can any1 post the code and where i need to put it

thx

#348 PandA.nl

  • Community Member
  • 323 posts
  • Real Name:Paul
  • Location:Haarlem, Netherlands

Posted 23 March 2005, 09:16

jeffk, on Mar 22 2005, 04:15 PM, said:

i miss is the order number in the email from the store

it used to send an email with the - subject NEW - Order Process #894

now all i get is  - Order Process

<{POST_SNAPBACK}>

same problem here, I took a quick look at the code, but i haven't found out how to fix this yet :(
Please do not PM me for support, I will not respond anyway.

#349 WebPixie

  • Community Member
  • 138 posts
  • Real Name:Andrea

Posted 23 March 2005, 14:55

jeffk, on Mar 22 2005, 10:15 AM, said:

hi

upgraded to this module from a previous version by a diffrent author , its working fine . the only thing i miss is the order number in the email from the store

it used to send an email with the - subject NEW - Order Process #894

now all i get is  - Order Process 

as i drop shipp all my orders having the order number in the email makes it easy to track the orders

can any1 post the code and where i need to put it

thx

<{POST_SNAPBACK}>


In the contribution section there is a mod for adding order number to emails. Just apply this to the paypal_ipn file and you're golden. You may need to adjust slightly for the paypal mod, but if you know a bit of php you should be fine.

Good luck.

#350 PandA.nl

  • Community Member
  • 323 posts
  • Real Name:Paul
  • Location:Haarlem, Netherlands

Posted 23 March 2005, 16:02

:blush: I didn't read well, was looking for something different than jeff.keeling after all

I was hoping it was possible to ad the order nr to the PayPal e-mails, currently I get "Item # - Notification of Payment Received from ..." in the subject or just "Notification of payment received".

It seems that at least the the e-mails with the "Item #" could have the order number included in the subject.?
:huh:
Please do not PM me for support, I will not respond anyway.

#351 cirieh

  • Community Member
  • 14 posts
  • Real Name:ciriu

Posted 24 March 2005, 22:45

Hi all!
I have same problems with the contrib margin report 2.56 both paypal IPN 3.0a.
The contrib work perfect with all kind of payment modules excluding Paypal.
For all orders made via paypal the "cost" of the products ordered will not be pass in the table:
Example


Order ID Items Tot sells Cost Income
1647 1 35.90EUR 0.00EUR 35.90EUR Paid via Paypal
1648 2 122.70EUR 0.00EUR 122.70EUR Paid via Paypal
1649 22 297.05EUR 114.60EUR 182.45EUR Not Paid via Paypal
1650 2 20.99EUR 10.00EUR 10.99EUR Not Paid via Paypal



Can you help me?


Thank You ,Marco

#352 shaunam

  • Community Member
  • 20 posts
  • Real Name:shauna

Posted 27 March 2005, 03:00

I'm getting this same error. Did you solve the problem?

WVSailor, on Mar 9 2005, 10:07 PM, said:

:'(

Warning: openssl_pkcs7_sign(): error creating PKCS7 structure! in /home/nownthen/public_html/includes/modules/payment/paypal_ipn.php on line 369

Ok, corrected all the other errors.  Does anyone know what this one means??
Thanks for everyones help!

<{POST_SNAPBACK}>



#353 aanavb

  • Community Member
  • 8 posts
  • Real Name:Afe Ana

Posted 27 March 2005, 03:11

shaunam, on Mar 26 2005, 10:00 PM, said:

I'm getting this same error.  Did you solve the problem?

<{POST_SNAPBACK}>



No I was not able to resolved it. I decided to let it go for now.

#354 surfnbeauty

  • Community Member
  • 13 posts
  • Real Name:Surf'n Beauty

Posted 27 March 2005, 07:09

Hi 2 issues on the OsCommerce PayPal IPN Module 1.1.

1. checkout_confirmation.php is not generated by the order number sometimes. This cause the IPN.php script fail to correlate the IPN with the order in the database.

How to solve this intermittent issue of not having the order id or invoice #?

This the code of the button,

<input type="hidden" name="invoice">

2. I am using HKD to in the catalog and paypal mandate the use of USD for settlement. From payment perpsective, it is working fine. But when it comes to IPN, the current IPN 1.1 module is trying to compare USD amount received from the IPN, to compare with the HKD amount stored in the database, obviusly, it is causing undeisred behavior in the script.

Anyone have solved it before?

The related code in IPN script is

if ($_POST['mc_gross'] == number_format($total['value'] * $order['currency_value'], $currencies->get_decimal_places($order['currency']))) {
if (MODULE_PAYMENT_PAYPAL_IPN_ORDER_STATUS_ID > 0) {
$order_status_id = MODULE_PAYMENT_PAYPAL_IPN_ORDER_STATUS_ID;
}
}

Surf'n Beauty - Your Online Beauty Store
http://www.surfnbeauty.com

#355 shaunam

  • Community Member
  • 20 posts
  • Real Name:shauna

Posted 27 March 2005, 20:29

Hi,

I'm having this same problem. In the configuration on osc of PayPal IPN, I use an email address of sales@halloweenplayground.com. This is also the email address of the business account setup on the sandbox.

I created a personal account on the sandbox which has the same email address as the user I created on my osc to test an order - the personal account has a different email address.

What else should I be checking? The first error I get from osc is:

Warning: openssl_pkcs7_sign(): error creating PKCS7 structure! in /home/hsphere/local/home/scavenge/halloweenplayground.com/includes/modules/payment/paypal_ipn.php on line 356


Then, when I click confirm order, I get this error from Paypal:

Error Detected


--------------------------------------------------------------------------------



The email address for the business is not present in the encrypted blob. Please contact your merchant.

Continue



Any ideas on how to solve either error?
Many Thanks!


RikR, on Mar 6 2005, 03:41 PM, said:

Either email address should work.

Shop around for the SSL. You probably do not need the most expensive.

Places like GoDaddy run about $55.00 (might have been for two years, I forget) for a "turbo" level. That is what I have and it works fine.

Just copied this from my receipt:

QTY ITEM PRICE 1 Turbo SSL (2 Years) 55.90

<{POST_SNAPBACK}>



#356 surfnbeauty

  • Community Member
  • 13 posts
  • Real Name:Surf'n Beauty

Posted 28 March 2005, 15:50

Anyone can help? I found $cart_PayPal_IPN_ID variable is empty and causing lost of "invoice" field in the checkout_confirmation page.

surfnbeauty
http://www.surfnbeauty.com

===

surfnbeauty, on Mar 27 2005, 03:09 PM, said:

Hi 2 issues on the OsCommerce PayPal IPN Module 1.1.

1. checkout_confirmation.php is not generated by the order number sometimes. This cause the IPN.php script fail to correlate the IPN with the order in the database.

How to solve this intermittent issue of not having the order id or invoice #?

This the code of the button,

<input type="hidden" name="invoice"> 2. I am using HKD to in the catalog and paypal mandate the use of USD for settlement. From payment perpsective, it is working fine. But when it comes to IPN, the current IPN 1.1 module is trying to compare USD amount received from the IPN, to compare with the HKD amount stored in the database, obviusly, it is causing undeisred behavior in the script. Anyone have solved it before? The related code in IPN script is         if ($_POST['mc_gros"] == number_format($total['value'] * $order['currency_value'], $currencies->get_decimal_places($order['currency']))) {
          if (MODULE_PAYMENT_PAYPAL_IPN_ORDER_STATUS_ID > 0) {
            $order_status_id = MODULE_PAYMENT_PAYPAL_IPN_ORDER_STATUS_ID;
          }
        }

Surf'n Beauty - Your Online Beauty Store
http://www.surfnbeauty.com

<{POST_SNAPBACK}>



#357 shaunam

  • Community Member
  • 20 posts
  • Real Name:shauna

Posted 30 March 2005, 00:56

got it to work. do not use paypal's pub cert - generate your own.

aanavb, on Mar 26 2005, 08:11 PM, said:

No I was not able to resolved it. I decided to let it go for now.

<{POST_SNAPBACK}>



#358 aanavb

  • Community Member
  • 8 posts
  • Real Name:Afe Ana

Posted 30 March 2005, 01:05

shaunam, on Mar 29 2005, 07:56 PM, said:

got it to work. do not use paypal's pub cert - generate your own.

<{POST_SNAPBACK}>



Thank you I will try it then.

#359 Desertsky

  • Community Member
  • 120 posts
  • Real Name:Paul Mcintosh

Posted 31 March 2005, 14:29

Hi all! I am having a problem with the PayPal IPN not passing the shipping costs to PayPal consistently. It is only doing it right about every 20 orders. I have a $2.00 handling charge and then a table rate based on weight. The correct shipping charge shows up in the orders admin area but the shipping charge is missing from PayPal.

Here is the info:

Enable Table Method
True

Shipping Table
1.0:3.00,2.0:4.00,3.0:5.00,5.0:6.00,7.0:7.50,10.0:10.00

Table Method
weight

Handling Fee
2.00

Tax Class
--none--

Shipping Zone
--none--

Sort Order



I used to have PayPal set with a shipping table in their admin area with the override box checked. I had assumed (incorrectly) that everything was working right. I used to get a double shipping charge about every 20 orders. After I removed the PayPal side of the shipping charges, none of my orders show the shhipping charge even though the charge shows in the order admin in oscommerce.

Anyone have any clues with this? :'(

#360 Soundloop

  • Community Member
  • 7 posts
  • Real Name:TC

Posted 01 April 2005, 02:14

PAYPAL IPN Canadian Currency Code Problem

Hi there,

I've installed the Paypal IPN module, but am having some issues with the transaction currency code symbol for Canadian $$.

The problem is this: The standard symbol code shound be CDN, which is what the Canada Post Shipping module uses, as well as all financial institutions etc.

When this is used in OSC and the Paypal IPN module, the total will not transmit to the Paypal page. If this is changed to CAD, it works, but the shipping amount cannot be retrieved from the Canada Post servers for the Canada Post shipping module... :'(

since CAD is technically not correct, is there a way to change this in the Paypal IPN module and have it calculate, or is this an issue with PayPal?

Any suggestions are much appreciated!

Cheers,

TC