OSCOMMERCE SUPPORT CALL 702-453-3332

oupons by Ingo with PayPal IPN

Hi, ,

I using Paypal_IPN in my site, looks it does not work with 'Coupons By Ingo' contribution.

everything looks fine until click 'confirm order' button and goes to Paypal site, coupon parts not deducted at paypal site. that is 'coupon' works in last page in my site which looks like

Sub-Total: $168.00
Coupon (XSrHKccN): $-5.00
Total: $163.00

but after click 'confirm order' button, the page goes to paypal.com and the payment still be 168$ but not 163$

many appreciate if you can help us work out.

ray.

Thank you mmph very much for your response. That makes perfect sense. I would like to add one more question if you would not mind. It's about the order information between OS Commerce and PayPal. I see that OS C provides an invoice number (i.e. invoice #17), but that number does not appear in PayPal anywhere. PayPal gives it a completely new number on their site and does not even send that number back to OS C. Sos, is the e-mail the only way to find out what that number is? Is there no way to get that order number (or some type of corresponding number) passed to PayPal from OS C or Vice Versa? Thanks again.

I have been wrestling with this module for a week and have finally got the upper hand.

Tried everything including searching this forum which aint easy as it's been going for quite a while. And you don't know what to search for til you find your solution!

Everything works great if I set the permissions on the ext folder to 755

(And stick a php.ini file in ext/modules/payment with register globals = on)

If I set permissions to 644 as suggested in the installation guide then order status never gets past "preparing IPN"

Is 755 a security issue?

Good Module, aint complaining, just learning!

A:)

I'm not sure why you don't get the invoice number in your email from paypal; you might need to re-install the IPN. Make sure you read the instructions fully, there is a lot of information in them. You also need to un-install and re-install the module from your admin panel if you update the files on your server.

Here is an example email I received from PayPal today for an order where you can see the invoice number posted, none of my IPN post backs have been making it through my Godaddy proxy recently so I have to manually process them all as described in my post before.

my host refuses to give the location of Your Private Key and Your Public Certificate. he says that i have to use the ipn method to receive payment. is that ok?

Yeah, you get those from Paypal, I don't think you use the ipn though. I believe you get it when you sign up as a paypal developer. I remember having problems finding it.

lildog

@mmph

Okay. So that's weird. I don't get this section of the e-mail at all:



That is why I am getting no corresponding information between PayPal and the OS C store. The weird thing is that I just upgraded the IPN and I get the same omission. I guess I will back track again and see if I am missing a setting or something. Thanks.

So, I guess I have one more question before I go snooping through the documentation again. Are there any other fields in the IPN payment setup that you changed that might be affecting it? The only fields I edited were obviously the "Enable PayPal IPN Module" (set to true) and "Gateway Server" (set to Testing) and E-Mail Address (set to test e-mail address.) Did you change any of the other settings in the module? When I initially read through the instructions I did not see that any other fields needed to be changed from their default status unless you were using encrypted web payments. Thanks again.

Does anyone know why the OS Commerce order number would not be passed to PayPal during a transaction? It does not show up anywhere in the transactions that are being processed, and as a result I have no real way to do any verification between PayPal's notification of payment e-mail and the order in OS C beyond trying to compare day and time of the order (which is a pain.)

I have re-installed the IPN twice, but I'm not getting any changes. I'm also only receiving a response from the IPN about 10-20% of the time.

Thanks.

Hello, I've installed PayPal IPN Module on osComemrce 2.2-MS2. The site is running on PHP Version 5.2.5 and MySQL 5.0.45.
The problem is that after successful insterting of the order data in 'orders_products' table tep_db_insert_id(); returns no value.

includes/modules/payment/paypal_ipn.php row 186:


This cause subsequent inserts into orders_products and orders_total to have no value for order_id. I have Authorize.net AIM and Check/Money Order payment modules installed as well and don't have such a problem.

I will appreciate any help. Thanks.

Hello,
I've noticed a number of users of this contribution are have problems with the order or invoice number not showing up on the PayPal transaction. Then, there also is no successful IPN to indicate a VERIFIED transaction of osCommerce to reduce stock and signify its completed transaction.

I too am having this problem. The IPN contribution works about 10 - 15 percent of the time. I found out that every time I am not recieving a VERIFIED IPN, there also is no Invoice Number with the PayPal transaction when I check the Details section of the transaction when I go to PayPal. When I get a completed IPN there is always an invoice number.

Now I read a post, on OSC forums about 1 week ago that PayPal is experiencing technical problems with their IPN service in which they are working on it. Does anyone in this thread know about this?
Can anyone help me with my particular problem?

Alan

I can only say that I too am having the IPN trouble. I have not received any post-back information from PayPal in the past week although I can see PayPal's postback hitting my IPN.php file when I watch "who's online" so I would assume my problems are compatibility of my godaddy hosting account and the IPN.

The missing invoice id issue is caused by the code introduced in v1.4 trying to fix the register globals off issue. That fix was working fine so I didn't touch it in my updates.

I fixed this 'missing invoice id' problem recently in a few cases, on php5 mysql5 servers with osCommerce 2.2RC2a. I need to gather more info about this problem before I can release a fix or update. Please let me know which php version you have and the osComerce version if it's not 2.2RC2a.

There are known bugs in PHP-5.2.5, and security issues with PHP < 5.2.6

If it's possible, can you upgrade to php 5.2.6 and let me know if this missing invoice id issue happens with php 5.2.6?

Hello,

I am using:
osCommerce V2.2 RC2a
PHP Version 5.1.6, register_globals Off
MySQL Version 5.0.27
I am with 1and1, running a VPS box in which osCommerce is hosted.

Sorry, I cannot make any changes at this time with PHP
Also, I've noticed that I had safe mode on with PHP, I just turned it off. I don't know if this has anything to do with my problem, we'll see.

Alan

Please try turning register globals on, safe mode off and see what you get.

Off topic, is it a Virtuozzo+Plesk8 VPS box on CentOS4 or 5?

Virtuozzo+Plesk8 on fedora-core-6-x86_64

I'll try working on turning register_globals On. I don't know how to do this part so may take some time. If you have any ideas, please let me know.

Alan

SSH to your VPS or use your Virtuozzo control panel -> File manager to modify /etc/php.ini if you have only 1 vhost, or set this per vhost by creating
/real path to domain home/domain.com/conf/vhost.conf
and/or /real path to domain home/domain.com/conf/vhost_ssl.conf
and then run this command at SSH:

This is what I did at my Plesk8 VPS on CentOS4.6, should be the same. If not, ask 1and1 for help.

Alex,
I did what you suggested; I turned on register_globals.
I did this by editing my /etc/php.ini file to read: register_globals = On (This is the only change in this file, changed Off to On)
Then, I uncommented the line #php_value register_globals 1 in .htaccess

The PayPal IPN is still not passing the Invoice number, therefore I do not get a notification back of a VERIFIED transaction.

Alan

Hello,

I am using Oscommerce Paypal_IPN V 2.2 and on some orders I get 2 - 3 extra "IPN Notices in the order section". The notices are all the same status and usually are in a couple seconds from each other.

Example -



This only happens on some orders not all. I get about 150 orders a day. I also get duplicate emails every time this happens.

Its not a duplicate order its the same order but with multiple notices.

Does anyone know how to prevent "duplicate" notices from being entered or how to correct this? I have tried to duplicate this problem using sandbox, but haven't been able to.

Any help on how to possibly debug this would be great.

Is it possible to record the refund ID?

For instance:
Refund (ID #4K9691586B871041P)
In reference to:5HQ67146384423037
...appears on the order details page on paypal.com after a refund.

Can this be posted back to the oscommerce admin panel where it says [refund] in the order comments?

i contacted paypal developer support about this and didn't get anything i could comprehend on my own.

Quick question, I have a customer who just installed RC2a on her web server and has enabled Paypal Website Payments Standard. Would she still need to install this mod or another one for received payments to registar on the site?

It appears that you are asking if osCommerce PayPal IPN module should be installed in order to be notified from PayPal on the sellers site that they have received a payment. I have not installed PayPal WPS on my RC2a installation, but I believe it also has an IPN feature. Therefore, if it is a matter of being notified about receiving a payment. you should not have to. Read the Readme document for PayPal WPS on page 6, it mentions having an IPN feature.

I hope it works. Sometimes these features do not work like they should. I installed this osCommerce PayPal IPN rather than the stock module and it notifies me about 5 - 10 percent of the time. You can read my previous posts just a few before yours.

Alan

Alex[or anyone else],

I have installed "osCommerce_PayPal_IPN_v2.3.4", however when customers use PayPal to pay, the amount to be paid is always shown as 0 (zero). Hence, I end up with one of two potential problems:

1) The customer did not make note of how much to pay, and hits a back button only to get a Page has Expired - they might give up at this point.
2) The customer enters the wrong amount to pay.


Is there a known fix for this?

Thanks.

Nevermind, I'm a dummy, it WAS the nonmatching currency values in paypal/oscommerce admin causing my issue

Hi all,

I'm afraid that I may well be asking an answered question but I'm in a bit of a panic! Sorry if that is the case. In fact, I think it could be solved by the last update on the contributions page (about the php.ini file)

I just received an order from my shop and didn't receive the confirmation email and the order doesn't show up in admin. I assume that the customer didn't receive the email confirmation either. The order is saved in the database though.

I believe that I read somewhere that the email wouldn't get sent if the customer didn't get redirected back to the site and that, in this case, the order wouldn't be saved in the database. It's weird that the order would be in the database but not show up in admin.

I tested using the sandbox server during development but I have made quite a lot of changes since and, obviously, the site is now live!

Any help would be greatly appreciated. Luckily I can get to all the information through the database but my other half, who runs the shop, doesn't know how to do that!

Cheers,

Joseph

PS. If I never said thank you for the contribution ---> THANK YOU!!!!

I figured out that /catalog/includes/modules/payment/paypal_ipn.php is called by /catalog/shopping_cart.php but where and when does /catalog/ext/modules/payment/paypal_ipn/ipn.php get called?

Alex - if you're still watching this thread ....

I've noticed that customer addresses have stopped being passed to PayPal - everything else is working as it should, including full per-item order details going into PayPal and being sent on PayPal's payment received emails etc etc etc

The BIG issue with addresses not going to PayPal is that it then invalidates any form of PayPal Seller Protection Policy coverage and the seller is exposed to the risk of fraud by the buyer (or chargebacks after delivery).

System is osC 2.2 RC1 with PayPal IPN 2.3.2 on a php 4.2 box

It was working, but in the last month or so, the few orders received have all had this same issue. I waited to see if it was a PayPal glitch, but it's continuing.

Any clues?

Gaz

If it doesn't send addresses to PayPal at all, then it probably is your settings.

If you're concerning about seller protection and/or chargebacks, don't use this module. As I posted before, I've given it up and switched to express checkout.

Hi Alex - thanks for the reply

I have to ask though - which Express checkout module?

I really don't understand the install instructions in the official osC version on that docs .... 1699 page (or whatever its reference is) - simply providing a diff report doesn't cut it for me when my site is already so heavily modified and laden with contribs - that's why I prefer the basic module methodology for payment and shipping options.

Anything that starts messing with the orders and checkout files is highly likely to break the site now, and the reason why I'd like this IPN working.

Regards
Gaz

I can't tell you which express checkout module suits best to your store, you have to find out yourself.

For payments to be eligible of PayPal's seller protection policy, the shipping addresses have to be confirmed by PayPal. Only those addresses registered with payers' PayPal accounts which are exact the same as their credit card billing addresses from countries currently supported can be confirmed. When sending the shipping address along with the order detail to PayPal, PayPal tends to switch the shipping address with one in their record, so the chance to be eligible for the seller protection is increased. The problem is, this PayPal IPN module can not handle the replaced shipping address at all. Currently only Express Checkout provides the solution for this problem. If the address is not confirmed, you don't have any chance to fight against charge backs, you'll lose your money and your products for sure.

Why paypal notify me tooooooo many time?
I also receive NINE order confirmation emails for one order. This begins today. before was OK. I did not touch anything.


Date Added Customer Notified Status Comments
06/09/2008 14:23:09 Preparing [PayPal IPN]
06/09/2008 14:26:38 Processing PayPal IPN Verified [Completed (Unverified; GBP27.21)]
06/09/2008 14:27:14 Processing PayPal IPN Verified [Completed (Unverified; GBP27.21)]
06/09/2008 14:28:07 Processing PayPal IPN Verified [Completed (Unverified; GBP27.21)]
06/09/2008 14:29:40 Processing PayPal IPN Verified [Completed (Unverified; GBP27.21)]
06/09/2008 14:32:00 Processing PayPal IPN Verified [Completed (Unverified; GBP27.21)]
06/09/2008 14:35:54 Processing PayPal IPN Verified [Completed (Unverified; GBP27.21)]
06/09/2008 14:42:11 Processing PayPal IPN Verified [Completed (Unverified; GBP27.21)]
06/09/2008 14:53:58 Processing PayPal IPN Verified [Completed (Unverified; GBP27.21)]
06/09/2008 15:17:00 Processing PayPal IPN Verified [Completed (Unverified; GBP27.21)]

Just to ask again...

Is it possible to send customers to the PayPal page where they can enter their credit card deatils rather than my website send them to the page that says "PayPal securely processes payments for..." and then they click pay by credit card?

Hello.

I have upgraded my site to the latest OSC version 2.2 RC2a and I have also upgraded to PayPal IPN 2.3.3. I have one little issue that I'd like to see if anyone has encountered or if anyone have a fix.

When a customer places an order and pays via PayPal my order number is not passed on to PayPal correctly. I have made the modification suggested by Terra on a previous PayPal version and when I upgraded to the current 2.3.3 version I merged that modification to reflect in the new PayPal 2.3.3 version. So when PayPal sends me a notification, instead of having my order number listed in the "Invoice ID" all I get is the Unique Letter suggested by Terra's modification.

The order number appears fine in the OSC admin side, but not in PayPal thus I believe that perhaps the IPN is not passing the entire information (at least the number portion of the order). I did not have this problem in the previous version, so I am a bit lost here.

Could someone please help me solve this issue?

Thank you!

ski

I have installed version 2.3.4 but the total payment that shows up for the customer at Paypal is zero dollars. Did anybody run into the same problem? Any ideas of what this could be?

I am using Aggregate. Everything else looks right. When the customer comes to the confirmation page, the order is entered correctly into the order table. But then when he clicks 'confirm order' on the first Paypal page the total is zero. Any help would be appreciated.

Hello, everybody!

Anyone installed osCommerce2.2rc1? I found a problem of original Paypal_ipn of osCommerce2.2rc1, when post
amount/shipping/tax to Paypal, it couldn't support the other Currencies, I set USD as the default Currency, and when
you buy with other Currencise, it couldn't exchange the rate from USD when post amount/shipping/tax to Paypal. I want
to know anybody who also had this problem?

Today, I change the code in includes/modules/payment/paypal_ipn.php :
line 325:
$parameters['shipping'] = number_format($order->info['shipping_cost'], $currencies->get_decimal_places($currency));
to
$parameters['shipping'] = number_format(($order->info['shipping_cost'] * $currencies->get_value($currency)),
$currencies->get_decimal_places($currency));

line 326:
$parameters['tax'] = number_format($order->info['tax'], $currencies->get_decimal_places($currency));
to
$parameters['tax'] = number_format(($order->info['tax'] * $currencies->get_value($currency)), $currencies-
>get_decimal_places($currency));

line 330:
$parameters['amount'] = number_format($order->info['total'] - $order->info['shipping_cost'] - $order->info['tax'],
$currencies->get_decimal_places($currency));
to
$parameters['amount'] = number_format((($order->info['total'] - $order->info['shipping_cost'] - $order->info['tax'])
* $currencies->get_value($currency)), $currencies->get_decimal_places($currency));

I test it in Paypal Developer test site, and the value is correct! But I'm very confused with it, why the osCommerce
team could not think about the exchange rate of Paypal_ipn. They are a so good team! And I couldn't make sure my code is correct! I need some advice...

Thank you very much!

ski,

It appears we are having the same problem. The invoice number is not shown on PayPal's transaction Details except for a small percentage of transactions. You can read my posts (about 1 page before this one) and Alex's advice regarding it. I did turn register globals on, but I had the same problem. I did also restart my server to make sure register globals was on, even checked server info in admin. Since I had the same problem, I went to the php.ini file and turned register globals off, since as a matter of security it is supposed to be off.
I am not a programmer, so I hope that someone can fix this.

Alan

I'm having the same problem - multiple IPN notices.. I posted earlier here, but no solution.. http://forums.oscommerce.com/index.php?s=&...t&p=1256597