PayPal & MySQL - PayPal Confirmation?...

User 18194 Photo


Ambassador
289 posts

Yes, that would be very helpful fur me as well. I have the same issue with a membership form I'm doing.

See-ya
Mitch
--Mitch
Long time CoffeeCup user, lover and ambasador !!
Mitchell Baker AMA 7548 GSWA WB251 10th AF USSMA 358
Webmaster Terre Haute R/C Club http://www.thrcc.org
US Scale Masters Director of Administration www.scalemasters.org
Proud member of the 1/8th Air Force http://www.oneeighthairforce.org

User 464893 Photo


Ambassador
1,611 posts

Perchpole commented
I've cobbled together a working IPN listener script. All I need to do now is make it update the corresponding database (transaction) entry as each payment is approved...


Actually you would only have to update those transactions that failed which again is a small percentage. But given a reply and sort those that failed is fairly easy to script and can re adjust the database automatically but I still feel it is another thing to go wrong. Use the info and check what the ratio of failed to good transactions. are and investigate the reasons for failure.
The Guy from OZ


User 69715 Photo


Registered User
30 posts

Hi, Prism -

I'm sorry but I disagree.

WFB records "transactions" when no transactions have taken place. This is a fundamental flaw and we're not going to fix it by pretending it's not important.

Currently, if I pull the data off the database, all it tells me is who used the form. I cannot rely on that information as proof-positive that those same people actually paid at the end of the process.

Yes, I could use emails to cross reference the data - but that's besides the point. The information on the database needs to reflect the activity of the user - including whether or not they completed the transaction.

Without some kind of verification - like PayPal IPN - the info in the database is incomplete.

:/

Antar
User 187934 Photo


Senior Advisor
20,193 posts

Eric Rohloff wrote:
Any chance you can post an example code for other users wanting to do the same thing.:)
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2073552 Photo


Registered User
1,625 posts

Eric Rohloff wrote:
Eric Rohloff wrote:
Any chance you can post an example code for other users wanting to do the same thing.:)
"An Apple doth not fall far from its tree, yet an orange does."

https://lbwebsitedesign.com - Responsive Web Design & Web Hosting Services.
http://helpsite.sirage.com - HTML5, CSS3 and CC Help Video Blog.
User 69715 Photo


Registered User
30 posts

Eric Rohloff wrote:
Eric Rohloff wrote:
Any chance you can post an example code for other users wanting to do the same thing.:)


Happy to - once I've worked out the database code. It might take a while...!

Antar
User 2196221 Photo


Registered User
15 posts

I have similar trouble with a membership renewal form that issues an invoice requesting payment.
However, for some reason the 'confirm to pay' page displays with the cursor half way down the page, therefore some members do not realise they have to scroll up to the top of the page to see the instructions and 'button' to press ( I've added additional instructions on the form to make them aware of the problem).
So, a number of members have stated that although they have filled the form in they did not receive an invoice.
Checking the database, I find that they have an entry on it. It took me some time to realise what was going on!
In the meantime is there any way to get the 'confirm to pay' page to open at the top of the page so all is displayed?
I have to agree that the transaction should not appear in the database until the 'confirm to pay' is pressed.
User 1545 Photo


Registered User
26 posts

I am trying to set up payment by Paypal and am having the same problems outlined above BUT I HAVE set up the IPN and still get forms submitted when payment is not complete. To be specific, I click on the Paypal button and am transferred to the site. I login with my personal account and see the payment. At this point I simply navigate the browser back to form. When I check my e-mail, I have all the information that was submitted. The S-Drive shows a record but all the fields are blank. I, like many others, only want the information if the payment was made.

It has been more than 10 days since the last post so I assume CC has no solution and that other users are stuck as well. The only reason I upgraded to a paid account was for this purpose! I will have to cancel the paid account if this is not resolved.
User 69715 Photo


Registered User
30 posts

I have set-up a form to run donations on a small charity website. The PayPal transaction fires an IPN script which sends a confirmation email to the admin to confirm the payment. It doesn't update the database - as it should - but at least it's something.

The main problem is that the user (making the donation) receives a "Thank you" notification before the transaction is completed. They often receive email notification before they login to the PayPal portal. It's daft!

I've spoken about this at length in the post above and I really do feel that CC need to look hard at this issue.

:/

Antar
User 464893 Photo


Ambassador
1,611 posts

You can change the notification by redirecting to a script that can send a reply after the callback from Paypal and not let WFB handle that notification. Alternately you could re write the notification to say the form submission has been received and is being processed. You can add that this is an auto response.
The Guy from OZ



Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.