3 sales for the same paypal transaction ID

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

Sorry 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:

http://www.tipsandtricks-hq.com/wordpress-affiliate

Not 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:

https://support.tipsandtricks-hq.com/update-request

I sent you an email to get site access.

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

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

Unfortunately 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&notify_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&notify_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…