I believe this is something they are planning to address in a future update, if this is the same issue as the one in this post that is:
http://www.coffeecup.com/forums/web-for … submitted/
http://www.coffeecup.com/forums/web-for … submitted/
HI, Prism -
I've followed your advice in the post above and I've had good results
I've also worked on the IPN response script so that it inserts values into a separate DB table.
The only issue now seems to be how to pass a custom value from WFB to PayPal. This value will be returned as a variable in the PayPal IPN. If we can grab this we can establish a relationship between the two different sets of data.
That would open up several possibilities.
For example, if we could send the WFB "_transactid_" to PayPal as a custom value it would be returned as a variable in the IPN. We could then use this to locate the row in the DB and update the entry with the payment status received from PayPal.
Question: how to pass the custom value in a WFB form?
Antar
I've followed your advice in the post above and I've had good results
I've also worked on the IPN response script so that it inserts values into a separate DB table.
The only issue now seems to be how to pass a custom value from WFB to PayPal. This value will be returned as a variable in the PayPal IPN. If we can grab this we can establish a relationship between the two different sets of data.
That would open up several possibilities.
For example, if we could send the WFB "_transactid_" to PayPal as a custom value it would be returned as a variable in the IPN. We could then use this to locate the row in the DB and update the entry with the payment status received from PayPal.
Question: how to pass the custom value in a WFB form?
Antar
I have to agree Antar. There is a flaw in the way WFB is setup and it does need to be addressed by CC. I'm doing registrations for a club convention and it's only been online 1 day before this flaw came up. Someone submitted their registration form, we received a message that the form was complete and the registration was submitted, but no PayPal payment was made. The emails should only go out AFTER the return from Paypal that the transaction was completed.
John
John
Jo Ann wrote:
I believe this is something they are planning to address in a future update, if this is the same issue as the one in this post that is:
http://www.coffeecup.com/forums/web-for … submitted/
I believe this is something they are planning to address in a future update, if this is the same issue as the one in this post that is:
http://www.coffeecup.com/forums/web-for … submitted/
I have also been handling Online Registrations. I have about 1/3, or more, of the registrants say they never were taken to a Paypal Total page after hitting Submit. They would try several times. This IS a big problem. They only way that I could collect funds (I did receive their registration email) is Invoice them out of PayPal. I couldn't figure out what the problem was.
May The Good Lord Take A Likin' To You,
Sandcrab3 (Scooterman)
May The Good Lord Take A Likin' To You,
Sandcrab3 (Scooterman)
Hello, All
I've been trying to find a fix inside the "checkoutpps.php" file. I'm sure the answer lies here somewhere. It lists all of the hidden fields which are sent to PayPal.
I configured a field called "custom". I tested this with various simple strings and each time my IPN script successfully returned the value.
Next I tried to assign a variable to the value including $transactionid, $transactionID, $route, etc - but this did not work. (It's beyond my pay scale to work out why but I tried every parameter I could think of!)
If we could somehow get the real Transaction ID via the IPN we could then cross-reference the value (with the same value in the MySQL table created by WFB). It would then be a simple task to use an UPDATE statement to enter confirmation of the payment into the relevant table row.
The IPN could also trigger confirmation emails via PHPMailer (which is what I'm using) or something similar.
It's tantalizningly close!
Antar
I've been trying to find a fix inside the "checkoutpps.php" file. I'm sure the answer lies here somewhere. It lists all of the hidden fields which are sent to PayPal.
I configured a field called "custom". I tested this with various simple strings and each time my IPN script successfully returned the value.
Next I tried to assign a variable to the value including $transactionid, $transactionID, $route, etc - but this did not work. (It's beyond my pay scale to work out why but I tried every parameter I could think of!)
If we could somehow get the real Transaction ID via the IPN we could then cross-reference the value (with the same value in the MySQL table created by WFB). It would then be a simple task to use an UPDATE statement to enter confirmation of the payment into the relevant table row.
The IPN could also trigger confirmation emails via PHPMailer (which is what I'm using) or something similar.
It's tantalizningly close!
Antar
I think part of the problem is those from a foreign country who does a Paypal transaction. From what I understand, Paypal automatically puts those in a pending status until the funds are processed with the currency conversion? So in those cases, would a PDT (Payment Data Transfer) go through indicating the transaction was complete?
The reason I'm asking this is that we have had 2 convention registrations fail so far with their Paypal payments, one from Japan, the other from Canada.
It seems that IPN is the way to go, but I don't want to spend the next 2 weeks or so trying to figure out how to setup a IPN Listener. I bought WFB to make my life easier, not to try and turn me into a .php coder. That's CC's job
John
The reason I'm asking this is that we have had 2 convention registrations fail so far with their Paypal payments, one from Japan, the other from Canada.
It seems that IPN is the way to go, but I don't want to spend the next 2 weeks or so trying to figure out how to setup a IPN Listener. I bought WFB to make my life easier, not to try and turn me into a .php coder. That's CC's job
John
I just got my ipn working for a site that I'm working on. It's a php membership site where I allow user to register then they are presented with a Paypal button to pay their membership fee to get full access to the content. My ipn updates my user mysql database to paid and increases their user level that allows them access to more content. If anybody's interested I will post a sample of my ipn.
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
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
Hello Eric .. is it possible to share the code to allow the form to mysql to be updated with paid once the user pays?
Lyn O wrote:
Hello Eric .. is it possible to share the code to allow the form to mysql to be updated with paid once the user pays?
Hello Eric .. is it possible to share the code to allow the form to mysql to be updated with paid once the user pays?
Are you using a login system?
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
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
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.