Tying to another module

[Frank]

Hey guys,

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?

Thanks,

Frank

[amin007]

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.

[Frank]

that would be great Amin! How can I get eStore to send the paypal IPN to a script?

Frank

[amin007]

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.

[Frank]

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?

[Frank]

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.

Frank

[amin007]

It will be a HTTP POST. This page has reference to what will be included in an IPN:

https://cms.paypal.com/au/cgi-bin/?cmd=_render-content&content_ID=developer/e_howto_admin_IPNReference

[Frank]

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?

Frank

[amin007]

“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?

[Frank]

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?

Frank

[Frank]

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?

Frank

[Frank]

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?

Frank

[admin]

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).

[Frank]

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?

[admin]

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.

[Author]

Posts