OSCOMMERCE SUPPORT CALL 702-453-3332

Hi Guys... I have a question that may have been asked vefore but I couldnt find any answer to...

when a user selects paypal ipn as his payment option.. an order is created on orders table.. this or has ... say... id 90..... then when the user is at the checkout processing page just about to go into paypal... I see some records are also created on the orders_products, orders_status_history and orders_total tables.. but there is problem... the order_id thats inserted into those records is something like 65445.. not 90 as it was used on the orders table... so when the user goes into paypal.. the info looks ok, they make their payment, go back to the website and go to the checkout success screen... everything looks fine... except that on the store admin orders screen... you cant find the new order, the info IS on the DB but since all the tables have the 65445 as order_id when they should've had 90, the admin orders screen cant show them..

what wrong?

I'm getting these errors after I installed the paypal IPN. I changed the permissions to 777, and still got an error.

Warning: fopen(/908510-2-data.txt) [function.fopen]: failed to open stream: Permission denied in /home/flybetty/public_html/store/includes/modules/payment/paypal_ipn.php on line 535

Warning: fwrite(): supplied argument is not a valid stream resource in /home/flybetty/public_html/store/includes/modules/payment/paypal_ipn.php on line 536

Warning: fclose(): supplied argument is not a valid stream resource in /home/flybetty/public_html/store/includes/modules/payment/paypal_ipn.php on line 537


Also, the new ext folder is to be placed in the root of the store correct?

I'm getting these errors after I installed the paypal IPN. I changed the permissions to 777, and still got an error.

Warning: fopen(/908510-2-data.txt) [function.fopen]: failed to open stream: Permission denied in /home/flybetty/public_html/store/includes/modules/payment/paypal_ipn.php on line 535

Warning: fwrite(): supplied argument is not a valid stream resource in /home/flybetty/public_html/store/includes/modules/payment/paypal_ipn.php on line 536

Warning: fclose(): supplied argument is not a valid stream resource in /home/flybetty/public_html/store/includes/modules/payment/paypal_ipn.php on line 537


Also, the new ext folder is to be placed in the root of the store correct?

Hi Guys,
not sure if this has been fixed but my client does not like the fact that the customer has to click a button on the very last page after payment has been received in order for osC to know that the order is complete.

A customer called the store saying that he had payed for his items weeks ago yet had not received his order. When they checked his status was still set to Preparing [PayPal IPN] even though his payment had gone through.

I know some sites that take PP that after the payment has been completed automatically redirect you back to the shop, has this been implemented in PayPal IPN or something to that effect?

Thanks

Well this is odd. I've run several test of the above statement and every time the status in osCommerce always goes from Preparing to Pending without having to click on the button on the last PayPal page. This means a customer would not have to click that button in order for my client to know that the PP payment has gone through. Why then did this one customers payment not change the status? Is it a fluke? I hate this.

Hello,

i have installed the version 2.2 but when i configure it does not update my configuration. keeps the defult configuration.
I am new and speak spanish. what can i do???

Thanks in advanced.

that normally means the customer has not paid.

its meant to change from preparing to pending when its paid for, i have set auto return on paypal profile. Best way to findout if customer has paid is to check paypal.

It just means that for one reason or another the IPN (instant payment notification) from PayPal did not get back to your clients server when the payment was completed. Remember this is the Internet and stuff vanishes all the time. That's why most systems have a verification process to be sure a message was sent and received. In this particular case that doesn't happen. I see this occasionally in my store. As previously stated your client should be comparing his PayPal account with his orders just to make sure things are not missed.

I have a question to do with the product inventory update portion of this module.

As I understood Terra to say, and someone correct me if I'm wrong, this PayPal IPN Module does NOT update the product inventory or products sold list until after the payment is completed.

I remember reading that when deleting unpaid orders showing "Preparing [PayPal IPN]", after waiting a day or so, not to check the box that says "Restock product quantity" because the product was never actualy removed from the inventory count.

So my Question is:
If a customer places an order and for what ever reason he cant get PayPal to process the payment, then calls me with a credit card number and pays for the order; If I go to the order details and update it's status from "Preparing [PayPal IPN]" to Pending, Processing, or any other status, is the inventory count updated for the products? Or will I need to manualy update the inventory count?

using the newest version from alex for this contribution.

i just came across an order for $41.00

but i happened to peek at the order comments and notice paypal only processed $23.00. i logged into paypal to confirm, that was correct.

i am suspecting the buyer downloaded the form values from checkout_confirmation.php and then passed the data to paypal that way.. i can't think of any other way this would have occurred.

the order / invoice # were spot on, as well as the customer #.
is there any way to prevent this? if not, is there a way to post a warning in the order comments if the order total on the osc admin panel don't match the amount paypal processed?

Which version are you using? The amount checking is there since v2.2. If you're using v2.3.x make sure it is v2.3.3. To eliminate the possibility of users' modifying the button code, you need to setup EWP.

i am using:
osCommerce PayPal IPN Module v2.3.3 For 2.2MS2

what is EWP and how can i set it up?

Encrypted Web Payments. When using EWP, the button code sent to PayPal can be encrypted so the customers have no chance to modify it. Please check the install guide about setting up EWP. Notice that Terra stated in the install guide "If you have SSL enabled, then you won't need to set up encrypted web payments as the payment module automatically uses SSL if available." which I don't agree. The SSL for the web pages is only protecting the customers' personal info, not the store owners. I know exactly how to generate false button code no matter if there is SSL or not, so be warned.

thanks.

in the instructions, i'm at a loss at what to do here:


is that ssh? if so, i haven't the slightest clue as how to execute this. any tips?
or can this be done in an easier way via cpanel?

PS: I just noticed, the order i initially posted about was placed before i upgraded ipn. i was using v1.3 until the other night. my bad

Yes that requires shell access and openSSL on your server. If you don't have SSH, you still can generate your self-signed certificates by softwares on PC. Please check this post about PayPal IPN, SSLs & Encrypted Web Payments.

anybody use the low order fee (which is a stock feature of oscommerce)

i seem to have encountered a bug.
- if a logged in customer purchases something, then comes back under the same session to buy something else via paypal.. the low order fee farts and charges some peculiar charge like $0.15 where they're supposed to be charged $8.13

the same also happens for points & rewards (contribution, which previously worked with additional hacks to ipn.php..those hacks don't seem to work properly anymore)

i'm not sure what files i'd need to be open to see what the problem is.. is the problem stemming from the order total class or ipn?


just disabled my modified ipn.php file (which had the edits from points & rewards) to see if those edits caused this bug... still the same result. this error is occuring on the original file of ipn.php file from v2.3.3

Low order fee should work with v2.3.3. Since v2.x there are some tasks moved to ipn.php to complete the order processing without customers returning, there for most coupon contributions will not work. Please consider other payment modules when applying coupons.

low order fee works during the initial checkout.. but say if i paid, got my success message in the shop... clicked around some more and then ended up with another fee, it doesn't get applied and the overall total is messed.

points & rewards definitely doesn't work on this version. a similar reaction happens when i try to redeem my credit, as does with the second checkout using paypal ipn.

what do i need to look at to make the points & rewards contribution work? is there a way to fix the problem with returning to the shop & doing a second cart, aside from forcing a log out upon checkout success?

I can't reproduce the low order fee issue on both of my test and live stores. Regarding the coupons, it's been discussed in this thread. Since this module requires payers leaving the store to make payments at PayPal, chances are customers don't return. If you managed to use this module with some coupon contribution, people would be able to reuse their coupon credits forever, simply don't return to store at all after payment. The credits will never get deducted.

i did a test using an older version of this ipn and my credits are deducted on checkout_confirmation.php, before being sent to paypal.

so if they head to paypal the total is correct.. coupons deducted.

but if they click off paypal and head back to the site, they lose the credits. i'm not sure if this is something i did on my own, or was a default feature (it's been a while since i initially installed).. but i've not ever had 1 complaint about it

so far, the newest version (of ipn) that works with points & rewards is v2.2
i suppose i will have to downgrade a bit.. which isn't too bad i suppose, as i was using v1.3 up until a few days ago

If the credit contribution updates the orders_total, then the total amount will be deducted when the button code is generated with in v2.3.x. The problem is the credit itself which is not workable with this module. If you update the used credits before heading out to PayPal, customers will lose their credits if they don't complete the payment. If you try updating the used credits after customers return, then the used credits won't be updated if they don't return. Older version seems to be working, that's only because you don't know the problem. The problem is there since the very first v1.0.

i don't get what you're saying with:

when i test v2.3.3 on my shop, it works fine until somebody encounters a low order fee; purchases & returns for a 2nd purchase.. same incident with redeeming points (except it goes crazy at the first sight of a redeeming point.. it deducts the value to $0.15 when osc says they owe $6.00 or something of the like.)

when i test v2.2 ...everything works 1st, 2nd & 3rd time.
i never had the problems with credits and such, with v1.3 either.

There were shipping & tax problems in "per item" mode before v2.3, so the new version is developed to solve the problem. Prior to v2.3, the order amounts are acquired from $order->info['total'], which doesn't have all details needed for "per item" mode. In v2.3 the order amounts are generated via $order_total_modules, so every installed order totals module affecting the total amounts will be listed in "per item" mode. If your points & rewards contribution doesn't work as a standard order totals module, most likely it will mess up the amounts generated with v2.3.x.

i've never used "per item" before, always had it set to "aggregate".


ok, this explains why points & rewards don't work. there's no way for the points to deduct if the balance is per item mode. thanks for explaining this.

from now on, is this ipn version going to be modified under per-item mode, or will there be separate versions in the future for aggregate?

I won't be updating this module anymore since I have decided to switch to express checkout, and osCommerce team has their official fork of PayPal modules released with 2.2RC2a, there is no reason for me to go on with this one.

All of a sudden all payment attempts through PayPal are now generating the following error when it transfers to PayPal:

Unable to process payment. Please contact the merchant as the shipping address provided by the merchant is invalid, and the merchant has requested that your order must be shipped to that address.

The addresses are certainly valid and this has just started happening (No config changes at our end what so ever. Running version 2.3.3

I have tried Googling but was not able to come up with anything useful. Any suggestions?

Thanks for all your efforts, updates and work in the past. I do appreciate that.

Dennis

Try these 2 posts: #3235 and #3164

I'm getting this error on PayPal site:



The country is the same (Brazil) and I just can't find out what's causing this error.

Is anybody else having this problem? Is this an issue with the contribution or with PayPal/

Any help is appreciated. TIA

Hi Patty

That error message is a common one for PayPal + eBay newbies who have not yet verified their bank account tied to the PayPal account, and not yet confirmed the address used for the account - both need done from within your PayPal account.

Are you using the PayPal account for both osCommerce and eBay?

If so, you need to clear the international trading restrictions at eBay so that they do not affect using the PayPal account with osC

Regards
Gaz

Tks for your reply.

I don't use eBay at all. But this is what I noticed: I have two PayPal accounts, one in the US and another in Brazil. The error happens when I use the one in the US and the shipping address for the order is in Brazil. If I use the one in Brazil, that doesn't happen.

So I guess it's a PayPal thing.

Hello to all. Just installed this contrib. everything works fine exept one thing:

once paid with paypal ipn in the email the payment method is listed correctly. but in the admin and client historey the payment method is blank. Does anyone have a clue why?

Thanks for your help

Another little question: we had in the registration requirements the field "state" disabled. after reading in this forum, we realized, that this contribute requires the field "state". Now i wonder if already registered users can order and paying by paypal (they have blank state field now).

Greetings

Well after realizing that already registered costumers (without stating their state in the adress ) couldn't pay with paypal ipn, i rushed to look for a solution.

spent now 1 hour searching this forum and found something.

in the file in /includes/modules/payment/paypa_ipn.php look for $parameters['address_override'] = '1';

just comment it out to have:

// $parameters['address_override'] = '1';

Apperently now paypal doesnt come up with the error message, that the merchant provided an errorous adress.... .

Please let me know if the above is correct.

Greetings

Hi
I am trying to install both paypal IPN v2.3.3 and Product attributes - Option Type Feature.
I have an issue with checkout_process.php, so I believe I need (in this case) to modify ipn.php

OTF says to change the following

$products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . $attributes_values['products_options_values_name'];

REPLACE with

// OTF contrib begins
//$products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . $attributes_values['products_options_values_name'];
$products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . tep_decode_specialchars($order->products[$i]['attributes'][$j]['value']);
// OTF contrib ends

However, ipn.php is not the same. It has the following

$products_ordered_attributes .= "\n\t" . $order->products[$i]['attributes'][$j]['option'] . ' ' . $order->products[$i]['attributes'][$j]['value'];

Please can someone advise exactly what I need to do in ipn.php
Thank you all very much

Hi

I have used PayPal IPN on my installations with great success. However, I have recently been having problems and the only real difference is that I have started using STS v4.5.3 I am tempted to remove it, but I thought that I would try this support thread 1st...

Basically, orders process OK, but the IPN reply from PayPal fails and returns me to the login page. At the PayPal 'Payment Confirmation' page I get a browser error as below:

---
Line: 148
char : 5
Error: 'PAYPAL' is undefined
Code: 0
URL: https://www.paypal.com/uk/cgi-bin/webscr?cm...a72a7a4da266138
---

The default PayPal works OK too, but also displays the above error and does in fact empty the customer's cart which can then be found in Admin>Customers>Orders

I am not too happy for my client to be using the default PayPal, therefore I need to get IPN working.

I suspect that this is a STS issue, but is there anybody here that can help me work out what the above error (Error: 'PAYPAL' is undefined) refers to?

Regards

Malcolm

hi

is this module (2.3.3) work fine with osCommers on server with register globals off (Register Globals V 1.5 by CMOTD) or require register globals on?

Hello,

After getting frustrated with Paypal Standard due to buyer having to return to store to get stock to update, I finally installed the Oscommerce Paypal IPN Mod. I did a live test tonight, and everything worked great except for one thing:

After completing a test order and then clicking on the "Complete Your Order Confirmation" button at PayPal, I was redirected to the buyer's shopping cart rather than checkout success (as set up on PayPal, and which works fine with Paypal Standard mod). The shopping cart listed the two items just purchased, but had a notation that they were out of stock. (I only carry unique items, so they would be out of stock).

Is there any way to modify the Paypal IPN php's to make it so that if the buyer clicks on the "Complete Your Order Confirmation" button, she is returned to checkout success rather than to their shopping cart? I've looked around and can't find anything about this. Every time I think I've finally got it, some crazy thing like this pops up. I don't have SSL and I have my settings set to "per item" and do not move tax.

Thanks for reading.

Heather

Never mind, I finally figured it out. I amended catalog/checkout_process.php and deleted referenced to redirecting to shopping cart. Hopefully it won't bite me in the butt later!

Thx,
Heather

Can anyone out there help me on this one? Have I missed something. I think this is causing me a problem, when I turn on downloads, the stock updating stops working, and I think this is the reason.
Everything else works fine (order email, confirmed order/ delivered, stock updates etc) until I turn downloads on, then suddenly everything still works EXCEPT the stock update (this is the same even though I have not yet set up any download attributes)

I do not need the attribute stock updating, just the item stock (items are modified to suit the attribute set, so I do not have separate stock of items with different attributes, just stock of the standard item, which I need updating)

Please can someone help?
It's driving me round the bend!

Thanks very much

I am recieving this same thing all of a sudden. Anyone have any ideas? It appears the session id is gone from the url string. WTf?

I have tested with Paypal IPN, both live & sandbox does not offer the option for customer to pay using credit card info only. Is it a paypal problem or the addon problem? It only offers "Sign up for a PayPal account and continue checkout."

Anybody could enlighten me? Thanks a lot!

I have the module set up and works great, in test mode with my Sand Box account.

Question: I have multiple email addresses in my PayPal account and multiple osCommerce carts, for different domains, can I use any of the emails associated with my PayPal account to work with the PayPal IPN module.

Thanks!

I added this last night and everything works fine for ONE order. On completed payment the status changes and the email is sent to customer.
BUT when doing some more test order the status does not change and the customer does not get the confirmation email even thought the payment is marked Completed on paypals sandbox server.

Whats going on, does anyone else have this problem or know whats causing it please, I'm pulling my hair out here

I just want to verify that the official PayPal IPN module is compatible with any osCommerce 2.x? I'm updating a client's site (actually building a new installation, version 2.2 RC2a) and I wanted to make sure that I can use this PayPal IPN module for that version of osCommerce.

Thanks in advance.

I have managed to get it working now but I have another crazy problem.
This happens using my live and sandbox account.....
I add items to my cart, select PayPal(IPN) etc.
I click Confirm. I then get an error saying "ERROR DETECTED-Some required information is missing or incomplete. Please correct your entries and try again."

BUT.
If I click the back button on the browser and press refresh so I'm back at conformation and then click "Confirm" it goes through perfect.
Also if I'm on the conformation page before getting the error and I hit F5(refresh) then click Confirm, The order goes through perfect.

Anyone got any idea's whats going on please ?

I guess no one knows then

i've tried to sift through this thread for a solution, but don't seem to find one... (this board should allow you to search WITHIN a thread!)

has anyone figured out what to do when the Paypal IPN module doesn't deduct stock even when the customer returns to the site from Paypal? thanks!

Hi

I have a problem with this PayPal module that I have had since I installed it. I know I am using quite an older version although I'm not sure how to exactly tell which verison it is.

The problem is that in the Customer Comments box where PayPal leaves the order status' (eg pending, preparing) there is alot of extra code that shows up that doesnt need to be there.

A quick screen shot should explain the problem:


This appears wherever the comment box appears, ie. the customers account/the admin side/invoice/packing slip.

How Can I remove this extra unnecessary code that makes it look like my website is broken?

Thanks

It does. Scroll down to the bottom of the page, and you'll find a small box in the bottom left where the words "Enter keywords" appear. Type whatever you like here and it will search the thread.

Cheers,
Max