Tagged: Thank you page
March 18, 2011 at 12:58 am #2981
Quick question. I’m running a licensing agent that needs to have a database entry created whenever downloadable digital products are sold. It would include the following fields:
appid – 3 digit number, could be set as a secondary attribute to the product id in estore
transid – paypal transaction id
custname – paypal customer name
custemail – paypal customer email
Do you think that this data can be passed on to another database on the same server automatically on a successful purchase?
FrankMarch 18, 2011 at 6:14 am #30358
Yeah. eStore can even send you the PayPal IPN that it receives to a script. You simply write a script that can process PayPal’s IPN and adds the customer data to your database then simply tell eStore to forward the IPN to this script.March 18, 2011 at 2:53 pm #30359
that would be great Amin! How can I get eStore to send the paypal IPN to a script?
FrankMarch 19, 2011 at 12:46 am #30360
WP eStore Settings -> 3rd Party Integration ->PayPal IPN Post URL
Specify the URL of the script where you want the IPN to be sent.
At the moment this feature is only used by the “Memberwing plugin” so this field is under a section called “Memberwing Integration Settings” but all it does is send the IPN to that script so it will work for your case. I will probably rename the header and make it generic.April 14, 2011 at 4:24 am #30361
I’m finally ready to integrate this feature. What values are passed to the script that I’m going to write? Plus how are they passed? Will it be a simple post or get or part of the url? And is there any way to test this feature simply without having to run through fake payments?April 14, 2011 at 4:42 am #30362
To give you some idea, the script I’ll need to write will only have to enter an entry into a mysql database. I’ll need to pass only the following values to it:
product_id -> the id assigned by the store
transitid -> the transaction id from paypal
custname -> the customer name from paypal
custemail -> the customer email from paypal
If you believe that you could cut the rudimentary script for this please advice to the cost.
Thanks a bunch Amin.
FrankApril 14, 2011 at 9:09 am #30363
It will be a HTTP POST. This page has reference to what will be included in an IPN:April 16, 2011 at 4:46 am #30364
Ok, so I can seek the posted values as per the paypal IPN and use what I need. Is there a way to simulate a payment without reverting to the sandbox mode and such?
FrankApril 16, 2011 at 9:14 pm #30365
“Is there a way to simulate a payment without reverting to the sandbox mode and such?” – you can write a script that POSTS all those variables or you can use a $1.00 transaction maybe?September 2, 2011 at 12:27 am #30366
Hey Amin, I’m still having grief with this one. Seems that the transaction id I get as a seller and the one that the buyer gets are completely different. Can I find some way to just push the seller transaction id to buyer to use as a license key? Or is there some way to capture the buyer transaction id?
FrankSeptember 2, 2011 at 2:22 am #30367
Hey Amin, a change in plans. I talked to paypal and found out that I cannot use the payer trans id, so I see that you provided the ability to put in the seller trans id into the email to send as a license to the buyer. So no worries. But what I’d like to know is if there a way to create a thank you page that contains the same info as the email that is sent?
FrankSeptember 2, 2011 at 5:12 am #30368
Ok, I’ve got a post with the code [wp_eStore_transaction_result:end] in it for a thank you page but it just seems to come up blank. Do you think it’s that I can either push the values to my licensing script or to a thankyou page?
FrankSeptember 2, 2011 at 6:15 am #30369adminKeymaster
PayPal issues different transaction ID to the seller and buyer (the Instant Payment Notification does not contain the buyer’s transaction ID so you cannot use it in your post payment processing script). You might just be able to use the buyer email address as the “key” if that works (buyer email will also be unique).September 2, 2011 at 1:26 pm #30370
I figured that all out. I’m issuing the seller transaction id as a license key. Do you know what’s happening in my last question just above your post?September 3, 2011 at 12:32 am #30371adminKeymaster
Push the values using the “IPN Handling Script”, the one that sends the email. Its always better to send the license key using the email anyway as it stay as a record.
Thank you page one is not reliable as the user can choose to close the browser after hitting the “Pay” button on PayPal (before PayPal can redirect). IPN gets sent as soon as the pay button is hit so this one is more robust.
- You must be logged in to reply to this topic.