Official PayPal IPN Support Thread
#341
Posted 18 March 2005, 00:27
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
Posted 18 March 2005, 02:31
Maquar, on Mar 18 2005, 01:27 AM, said:
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
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
Live (I'm assuming this needs to be live?)
Quote
(Where in My PayPal account do I obtain this if needed?)
Quote
/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)
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
Posted 18 March 2005, 16:45
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
Posted 18 March 2005, 19:56
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
Posted 21 March 2005, 19:41
dragonfoundry, on Mar 17 2005, 08:09 PM, said:
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?
Is it that im dont have a SSL certificate?
#346
Posted 21 March 2005, 20:56
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(): 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
Posted 22 March 2005, 14:15
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
Posted 23 March 2005, 09:16
jeffk, on Mar 22 2005, 04:15 PM, said:
it used to send an email with the - subject NEW - Order Process #894
now all i get is - Order Process
#349
Posted 23 March 2005, 14:55
jeffk, on Mar 22 2005, 10:15 AM, said:
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
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
Posted 23 March 2005, 16:02
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.?
#351
Posted 24 March 2005, 22:45
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
Posted 27 March 2005, 03:00
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!
#353
Posted 27 March 2005, 03:11
shaunam, on Mar 26 2005, 10:00 PM, said:
No I was not able to resolved it. I decided to let it go for now.
#354
Posted 27 March 2005, 07:09
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
Posted 27 March 2005, 20:29
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:
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
#356
Posted 28 March 2005, 15:50
surfnbeauty
http://www.surfnbeauty.com
===
surfnbeauty, on Mar 27 2005, 03:09 PM, said:
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
#357
Posted 30 March 2005, 00:56
aanavb, on Mar 26 2005, 08:11 PM, said:
#358
Posted 30 March 2005, 01:05
shaunam, on Mar 29 2005, 07:56 PM, said:
Thank you I will try it then.
#359
Posted 31 March 2005, 14:29
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
Posted 01 April 2005, 02:14
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














