Tips and Tricks HQ Support Portal › Forums › WP Affiliate Platform › 3 sales for the same paypal transaction ID
- This topic has 25 replies, 5 voices, and was last updated 13 years ago by
docfx.
-
AuthorPosts
-
November 9, 2010 at 10:09 am #2196
FrankAlm
MemberI think this is a bug. For the second time, i had 2 or 3 sales for the same papal transaction ID. The only difference is thera are different sales times. Could it be that happens if the customer made a reload with the “thank you” page?
Regards
Frank
November 10, 2010 at 12:17 am #26308amin007
Participant“Could it be that happens if the customer made a reload with the “thank you” page?” – Nope, the sale is only registered when the plugin receives a payment notification from PayPal.
Few questions…
1) Do you see multiple transactions in PayPal?
2) How are you determining that there are 2 or 3 sales? Is it because you got multiple emails?
3) When you go to the “Manage Customers” menu of eStore do you see the same entry for the same product multiple times?
November 10, 2010 at 9:09 am #26309FrankAlm
MemberThe Answers…
1. There a NO multiple transactions in paypal
2. I see the multiple transactions in the affiliate plugin under: WPAffiliate > Sales Data. And the Affiliate can see 2 or 3 Sales in his Affiliateaccount. For Example like this:
TheVideoFrank 48.5 2010-11-05 15:30:45 info@XXXXXX 6AA4XXXXXXXXXXXX
TheVideoFrank 48.5 2010-11-05 15:35:42 info@XXXXXX 6AA4XXXXXXXXXXXX
TheVideoFrank 48.5 2010-11-05 16:02:21 info@XXXXXX 6AA4XXXXXXXXXXXX
So for example 3 sales with the same paypal transaction ID only the salestime is different.
3. I don´t use eStore, i worked with WP eMember and WP Affiliate (with 3rd Party Cart Integration)
The multiple transactions are not everytime! Until now i have 25 Sales withou problems, there are only 2 Sales with multiple entrys. one sale with 2 Entrys in the affiliatesystem and one sale with 3 entrys.
November 11, 2010 at 12:54 am #26310amin007
ParticipantSorry I assumed you use eStore. Can you please tell me which integration option you are using?
There is an “Integration Section” on the following page so just point the URL that you followed:
November 11, 2010 at 10:57 am #26311FrankAlm
MemberI use this
Option 1) Integrating PayPal Button Using PayPal’s PDT Feature (Easier Option)
November 12, 2010 at 3:51 am #26312amin007
ParticipantNot sure exactly what happened but I added a new check in that integration option to make sure only one commission will be calculated per transaction ID. Please get a new build of the affiliate plugin from here and update it:
November 20, 2010 at 1:36 pm #26313FrankAlm
MemberAfter the Update today there is always the same Problem !
Could i sent you a Screenshot or a Login? So you can see it by yourself. Sent me your Mailadress.
November 21, 2010 at 1:32 am #26314amin007
ParticipantI sent you an email to get site access.
January 30, 2011 at 4:19 pm #26315dustycat
MemberI am having similar problems
I am running the WPAffiliate platform with eShop and Paypal as my merchant.
I have put eShop into test mode and have created some test accounts in the Paypal sandbox.
When I use one of my affiliate links to visit my website and make a purchase, the following occurs in WPAffiliate:-
Paypal sandbox seller account shows a transaction completing at 15:43:01 with reference
7b9dfbfcedb1bd85c126ba471bcfa2d24d4586e62f93d6.81674923
eShop shows the transaction happening at 15:42
WPAffiliate shows two transactions
one at 15:43:11 with a reference 2VE93235U6342044C and my test paypal buyer email address;
the other at 15:43:36 with a reference of TEST-2VE93235U6342044C and my ‘master affiliate’ email address
January 30, 2011 at 4:54 pm #26316dustycat
MemberLooking at the problem again, it seems that the error only occurs when I have both eShop and WPAffiliate in sandbox mode.
As soon as I unchecked the box in WPAffiliate settings to take it out of sandbox mode, and made another purchase, only one entry appeared in WPAffiliate
So something strange is happening when it’s in Sandbox mode in that it’s duplicating entries
The only ‘problem’ I can see now is that in live mode, the entry for the transaction is showing my affiliate’s email address as the buyer’s instead of the buyer’s own one.
I really need a solution to both these issues – the duplicate entries in sandbox mode and the wrong email address in live mode.
January 31, 2011 at 5:22 am #26317amin007
ParticipantRegarding the double commission for sandbox payment… I have updated the integration plugin slightly to add a guard. Please delete the existing version and get the new one from here:
Regarding the “buyer’s email address”… the affiliate plugin simply uses the buyer email sent by the eShop plugin to record that value.
August 27, 2011 at 8:09 pm #26318docfx
MemberI appear to be having similar issues, although this worked at one point, but is not now…
Am using WP estore (v5.3.3) and WP affiliate (v4.4.4) and Paypal (and manual pymt for testing).
When I test a sale via manual payment, the customer is created (once), but the commission is not getting updated (although both are checked in settings). I rec’v an ack email & a copy of order detail email
When I test the same sale via paypal, it processes the payment at paypal once. I click to return and go to a thank you, but see no results. I get six (6) ack emails, the customer is created six (6) times in the store customer table, the sale is entered six (6) times in the store sales table, but the affiliate is NOT credited w/ the commission (although the debug logs indicate the correct affiliate is identified (via a cookie rather than manual entry). Doesn’t seem to matter how many are in inventory, if set to four (4), I still get six (6) and inventory drops to negative 2 (-2)
August 28, 2011 at 12:22 am #26319admin
KeymasterYou have a server setup issue which is causing PayPal to send you the payment notification again and again (6 times in your case).
This usually happens when PayPal does not receive the proper response from your server when it sends the payment notification and it thinks the message got lost so PayPal keeps sending the notification.
Your issues is similar to this user’s issue:
https://support.tipsandtricks-hq.com/forums/topic/multiple-sales-record-and-mails-for-one-sales
Please keep debug enabled and post a link to your site so I can confirm this. You can reply on the above mentioned thread so all the information related to this stays on that thread.
August 31, 2011 at 9:32 pm #26320docfx
MemberUnfortunately I don’t believe that the handshaking betw server paypal is the issue (but am open to the possibility). However, I have 25+ zen cart installs (20 using IPN), 2 wp ecommerce (both using IPN) and this one wp e-store / wp-affiliate all on the same server for a variety of clients & domains – and this one is the only one ‘not talking to paypal’.
This install was, in fact, talking to paypal when it was wp e-commerce/wp-affilate, but not since we dumped e-commerce for e-store. More flexibility for this client’s needs, but whole project rests on payment gateway and affiliate functionality.
so let me re-iterate the issues so I’m painting a complete picture…
1) Neither manual OR paypal checkout is updating affiliate sales, although manual commission in admin dashboard does.
2) Manual checkout creates customer record once, reduces inventory (once) and issues single email acknowledgement, but doesn’t update affiliate.
3) paypal checkout exits to paypal, processes single payment (in paypal), creates multiple customers (in e-store), updates inventory multiple times (even into negative values), but does not update affiliate sales/commissions…
3a) IPN alone does NOT display transaction results
3b) IPN & PDT does properly display transaction results
3c) e-store (not paypal) sends out multiple emails (thanks to buyer and notifies to owner)
4) Simulated IPN from paypal sandbox is successful
4a) Sim IPN updates customer records once (as expected)
4b) Sim IPN does not update sales nor inventory (as expected)
4c) e-store (not paypal) sends out a single email (one each to buyer and owner)
Logs are enabled and show…
TYPICAL POST PAYMENT LOG
[08/31/2011 7:48 PM] - SUCCESS :Performing item specific autoresponder signup if specified.
[08/31/2011 7:48 PM] - SUCCESS :Performing global autoresponder signup if specified.
[08/31/2011 7:48 PM] - SUCCESS :===> Start of Affiliate Commission Calculation <===
[08/31/2011 7:48 PM] - SUCCESS :Checking if the WP Affiliate Platform Plugin is installed.
[08/31/2011 7:48 PM] - SUCCESS :WP Affiliate Platform is installed, checking commission related details...
[08/31/2011 7:48 PM] - SUCCESS :The referrer for this sale is:ifi01
[08/31/2011 7:48 PM] - SUCCESS :Processing Commission for : Hedonism - Ocean View (SallieMae Plaesome) (.10)
[08/31/2011 7:48 PM] - SUCCESS :Total Price of the currently processing item : 0.1
[08/31/2011 7:48 PM] - SUCCESS :Using commission rate from affiliate profile
[08/31/2011 7:48 PM] - SUCCESS :Using % based commission rate for this commission. Qty:1, Total price:0.1, Commission level:5
TYPICAL IPN HANDLE LOG
[08/31/2011 8:31 PM] - SUCCESS :Paypal Class Initiated by 66.211.170.66
[08/31/2011 8:31 PM] - SUCCESS :Post string : mc_gross=0.10&protection_eligibility=Eligible&address_status=confirmed&item_number1=11&payer_id=SH5KUEMCJ6RVE&tax=0.00&address_street=648+Monroe+Ave+NW%0D%0ASte+118&payment_date=12%3A38%3A19+Aug+31%2C+2011+PDT&payment_status=Completed&charset=windows-1252&address_zip=49503&mc_shipping=0.00&mc_handling=0.00&first_name=Ted&mc_fee=0.10&address_country_code=US&address_name=the+Imagination+Factory¬ify_version=3.2&custom=ap_id%3Difi01%26ip%3DXX.XXX.XXX.XXX&payer_status=verified&business=info%40client.com&address_country=United+States&num_cart_items=1&mc_handling1=0.00&address_city=Grand+Rapids&verify_sign=A.ZAfn054-4iil5KPzbxjORlXbHPAx4-Ft0.zCdr87HIdRVSvzLdird.&payer_email=me%40me.com&mc_shipping1=0.00&txn_id=5SU42451BD890953R&payment_type=instant&payer_business_name=the+Imagination+Factory&last_name=Bailey&address_state=MI&item_name1=Hedonism+-+Ocean+View+%28SallieMae+Plaesome%29+%28.10%29&receiver_email=info%40tomstrips.com&payment_fee=0.10&quantity1=1&receiver_id=BQCZXKP2P7GQ6&txn_type=cart&mc_gross_1=0.10&mc_currency=USD&residence_country=US&transaction_subject=ap_id%3Difi01%26ip%3D66.255.223.103&payment_gross=0.10&ipn_track_id=wSOJbI9YbNjYHxiD9in8ow&
[08/31/2011 8:31 PM] - SUCCESS :Connection to http://www.paypal.com successfuly completed.
[08/31/2011 8:31 PM] - SUCCESS :IPN successfully verified.
[08/31/2011 8:31 PM] - SUCCESS :Creating product Information to send.
[08/31/2011 8:31 PM] - SUCCESS :Transaction Type: Shopping Cart
[08/31/2011 8:31 PM] - SUCCESS :Number of Cart Items: 1
[08/31/2011 8:31 PM] - SUCCESS :Item Number: 11
[08/31/2011 8:31 PM] - SUCCESS :Item Name: Hedonism - Ocean View (SallieMae Plaesome) (.10)
[08/31/2011 8:31 PM] - SUCCESS :Item Quantity: 1
[08/31/2011 8:31 PM] - SUCCESS :Item Price: 0.10
[08/31/2011 8:31 PM] - SUCCESS :Item Shipping: 0.00
[08/31/2011 8:31 PM] - SUCCESS :Item Currency: USD
[08/31/2011 8:31 PM] - SUCCESS :Download Link :
Hedonism - Ocean View (SallieMae Plaesome) (.10) - This product does not have any downloadable content
[08/31/2011 8:31 PM] - SUCCESS :Product Email successfully sent to me@me.com.
[08/31/2011 8:31 PM] - SUCCESS :Notify Email successfully sent to owner@client.com.
[08/31/2011 8:31 PM] - SUCCESS :Updating Products, Customers, Coupons, Sales Database Tables with Sales Data.
[08/31/2011 8:31 PM] - SUCCESS :Products, Customers, Coupons, Sales Database Tables Updated.
[08/31/2011 8:31 PM] - SUCCESS :Updating Affiliate Database Table with Sales Data if Using the WP Affiliate Platform Plugin.
[08/31/2011 8:31 PM] - SUCCESS :Affiliate Commission may need to be tracked. See the "eStore_post_payment_debug.log" file for more details on commission calculation
[08/31/2011 8:39 PM] - SUCCESS :This debug line was generated because you entered the URL of the ipn handling script in the browser.
FROM SANDBOX IPN SUCCESSFULLY SENT and IPN HANDLER LOG SHOWS…
[08/31/2011 8:45 PM] - SUCCESS :Paypal Class Initiated by 173.0.82.126
[08/31/2011 8:45 PM] - SUCCESS :Post string : test_ipn=1&payment_type=instant&payment_date=13%3A24%3A39+Aug+31%2C+2011+PDT&payment_status=Completed&address_status=confirmed&payer_status=verified&first_name=John&last_name=Smith&payer_email=buyer%40paypalsandbox.com&payer_id=TESTBUYERID01&address_name=John+Smith&address_country=United+States&address_country_code=US&address_zip=95131&address_state=CA&address_city=San+Jose&address_street=123%2C+any+street&business=seller%40paypalsandbox.com&receiver_email=seller%40paypalsandbox.com&receiver_id=TESTSELLERID1&residence_country=US&item_name=Hedonism+TB+-+Ocean+View+Nude+%28SallieMae+Plaesome%29+%28.10%29&item_number=11&quantity=1&shipping=3.04&tax=2.02&mc_currency=USD&mc_fee=0.44&mc_gross=12.34&mc_gross_1=9.34&txn_type=web_accept&txn_id=398312024¬ify_version=2.1&custom=xyz123&charset=windows-1252&verify_sign=AucMbdOk3is4njbHprgL5XaJ87qiA4NVppD8ySgNOEuyoKbToFhbfL1j&
[08/31/2011 8:45 PM] - SUCCESS :Connection to http://www.sandbox.paypal.com successfuly completed.
[08/31/2011 8:45 PM] - SUCCESS :IPN successfully verified.
[08/31/2011 8:45 PM] - SUCCESS :Creating product Information to send.
[08/31/2011 8:45 PM] - SUCCESS :Transaction Type: Buy Now/Subscribe
[08/31/2011 8:45 PM] - SUCCESS :Item Number: 11
[08/31/2011 8:45 PM] - SUCCESS :Item Name: Hedonism - Ocean View (SallieMae Plaesome) (.10)
[08/31/2011 8:45 PM] - SUCCESS :Item Quantity: 1
[08/31/2011 8:45 PM] - SUCCESS :Item Price: 12.34
[08/31/2011 8:45 PM] - SUCCESS :Item Shipping:
[08/31/2011 8:45 PM] - SUCCESS :Item Currency: USD
[08/31/2011 8:45 PM] - SUCCESS :Download Link :
Hedonism - Ocean View (SallieMae Plaesome) (.10) - This product does not have any downloadable content
[08/31/2011 8:45 PM] - SUCCESS :Product Email successfully sent to buyer@paypalsandbox.com.
[08/31/2011 8:45 PM] - SUCCESS :Notify Email successfully sent to kbrown@what-if.com.
[08/31/2011 8:45 PM] - SUCCESS :Updating Products, Customers, Coupons, Sales Database Tables with Sales Data.
[08/31/2011 8:45 PM] - SUCCESS :Products, Customers, Coupons, Sales Database Tables Updated.
[08/31/2011 8:45 PM] - SUCCESS :Updating Affiliate Database Table with Sales Data if Using the WP Affiliate Platform Plugin.
[08/31/2011 8:45 PM] - SUCCESS :No Referrer Found. This is not an affiliate sale
[08/31/2011 8:45 PM] - SUCCESS :Paypal class finished.
Please advise…
September 1, 2011 at 2:58 am #26321admin
KeymasterPlease do the following:
1. Deactivate and delete the currently installed version of the plugin(s).
2. Download a fresh build of the plugin(s) from here:
https://support.tipsandtricks-hq.com/update-request
3. Upload and activate this version of the plugin(s).
4. Now reset the debug log files of eStore from the settings menu
5. Do a live test transaction
6. Share the content of the “ipn_handle_debug.log” file
This will give me a clear picture.
Regarding the manual checkout… do you have the “Automatically Award Affiliate Commission ” field checked in the manual checkout settings?
-
AuthorPosts
- You must be logged in to reply to this topic.