WP Affiliate & PayPal

[mikee17]

Hi,

Does this http://www.tipsandtricks-hq.com/wordpress-affiliate/wp-content/uploads/2011/03/php-example-award-commission-http-post.txt script work on notify_url of PayPal ?

What if the sale amount = 0 ?

I tried and no sale is recorded…

I turned the debug log ON and here is what I get from the log.

—

[05/19/2011 3:05 PM] – SUCCESS :Start Processing…

[05/19/2011 3:05 PM] – SUCCESS :Request does not have any GET or POST data.. cannot process request

—

PS: I use the code for HTTP Post using cURL from the above link.

Thanks & Regards

[mikee17]

Hi,

1. I learned that the sale amount cannot be 0.

2. cURL and file_get_contents do not work on the notify_url page and requires browser execution.

Am I correct?

Thanks & Regards

[amin007]

1. I learned that the sale amount cannot be 0 – There is no point in doing a commission calculation on a 0 (zero amount) so I added that restriction but if for some reason you really need to have 0 amount then this condition can be taken out.

2. CURL can work on any script execution. You just can’t directly make that script your notify_url without doing modifications to it. For example you will need to massage the data you get from PayPal’s IPN then populate the variables correctly then execute the CURL POST. If you are simply trying to integrate with a PayPal button why not use this integration?

http://www.tipsandtricks-hq.com/wordpress-affiliate/plain-paypal-button-and-affiliate-plugin-integration-168

[mikee17]

Say for example, we have a MONTHLY subscription of 5 USD with ONE WEEK trail(0 USD) and would like to record a commission even though its not relevant. How do we take out the condition you say?

Saying when I used the script from the link I pasted above, it does not mean I used the script as it is… I have all the values in place, i.e…

cURL: $secretKey, $affiliate_id, $sale_amt

file_get_contents: $secret, $referrer, $sale_amt

Stil it did not work for both POST and GET methods, shall try again and get back on this.

[mikee17]

If, I’m using direct SQL statements to insert values to ‘wp_affiliates_sales_tbl’ table, what do I do for ‘txn_id’ ?

i.e $txn_id = uniqid(); ? or can we use for ex. the payer_id => TT4B9D8ZKHBQA from paypal?

I have values from paypal on the notify_url page for >> refid, date, time, payment, sale_amount, item_id, buyer_email

Do I have to insert/update to any other table?

[amin007]

You can use a unique ID as the transaction ID. I prefer to use the transaction ID sent from PayPal (PayPal will also send you the transaction ID in the IPN… the name of the variable will be “txn_id”). Either method is fine though.

“Do I have to insert/update to any other table?” – No.

[mikee17]

Thank you!

* I actually wanted to say ‘Transaction ID’ i.e ‘txn_id’, by mistake said ‘payer_id’ instead.

[Author]

Posts