[docfx]

Thanks for your assistance.

Its also nice to see that you incorporated a few of our previous mods into the current release of the affiliate plug-in. This eliminated the need for re-deployment of all except one of our mods for this particular client. Once we added that mod back in it all continued to work as expected.

Excellent store and affilliate set-up and from a programmers perspective, clean enough hooks and commenting to be able to enhance them for the occasional unique things a client might want.

[docfx]

Another post upgrade related issue… checkout via manual payment redirects to info request screen, but submitting calls estore_manual_gateway.php where in the screen goes blank. The customer data is updated, the sale is listed as unpaid, inventory is reduced, but clickthru doesn’t appear to be updated, and of course, no affiliate commission is applied, even upon marking the sale as paid.

However, post payment log shows no failure (transaction ID/email duplication). Affiliate debug log remains empty although toggled on in dashboard.

[docfx]

Additional info…

Affiliate sales updates as expected manually via the admin dashboard. Just not via an actual transaction.

[docfx]

Ok, so I’ve now also updates Affilliate from 4.4.4 to 4.8.1. Increased the sale amount to $0.50, so commission should calculate.

Still getting the same result… Commissions are not getting applied to affiliate. I can see that the ‘clickthrough’ table is getting updated during the process, but not sales commissions.

Debug log still shows same FAILURE message

[09/02/2011 3:13 PM] – FAILURE :The transaction ID and the email address already exists in the database. So this seems to be a duplicate transaction notification. This usually happens with bad server setup.

Transaction ID (after upgrading e-store) was ’90J23365PL660625A’, (after upgrade of affiliate) next transaction ID was ‘7D399878WN462013G’.

[docfx]

yeah it looks like I’ll need to do that tomorrow. I updated e-store to 5.9.2 and that seemed to fix the multiple notification issue. Recent sale created one customer (does appear in the manage customers dashboard), deducted 1 item from inventory, and did update the store sales table.

It does not show up in the affilliate dashboard or in the affiliate data tables. Current using 4.4.4, but will try again after update.

[admin deleted debug]

[docfx]

Oops, regarding 1-6, which plug-in? wp e-store or wp-affiliate? or both? Will assume e-store unless I hear otherwise.

[docfx]

Thanks.

Am just heading into a meeting, but will get to 1-6 in a bit., but as for manual gateway settings, yes, ‘Auto Award Affil Comm’ is checked.

[docfx]

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…

[docfx]

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)

[docfx]

thanks.

I believe I have a work-around using an existing, but apparently unused field in the affiliate sales table w/o borking it by adding an extra field to the table. I’m simply pushing the buyer name into it from wp-estore, so I only need worry about the two tweaked scripts (one in wp-estore and one in wp-affiliate) if/when they need upgrading.

[docfx]

I’m not looking for full buyer info only the name and/or email. I appreciate the security aspect, especially were this an open affiliate system or the commission was coming from sales of a product not attendance to an event.

However, it is a closed agent/affiliate relationship. Our client (booking agent) is creating the affiliate pages, it is not open to anyone. The affiliate landing pages are personalized and assigned to each affiliate.

I (buyer) want to book a trip that I see on the affiliate’s travel site (affiliate could be the resort itself or an independent general travel agent). Chances are VERY high, that buyer and affiliate have already discussed this particular trip/event/excursion and the buyer is interested. A some point later, buyer clicks on the banner advert which takes them to the booking agent’s (our client) site.

The booking agent is not a general travel agent, but has a focus on highly specialized trips/excursions/events. While on the boooking agent site, buyer reserves said trip/event/excursion and via paypal (clearly identified as booking agent), make an initial deposit which then is credited against the appropriate referring affiliate.

The booking agent verifies the buyers information and, if necessary, adjusts final travel arrangements (buyer requests to arrive early, stay late, etc.) AND adjusts the affiliate commissions as needed.

On the other hand, the affiliate, does indeed want to know 1) that a sale occurred that generated commissions and 2) that the buyer (with whom they had discussed said trip) had or was able to reserve said trip.

The sales table can be made to show the buyers email address (which you do store in the affiliate sales table), but that is of marginal value when sandy or joe bob’s email is actually sharkhunter12@gmail.com or stormchaser237@yahoo.com.

The booking agent has no previous discussion w/ sandy/joe-bob, doesn’t know to be looking for them and doesn’t know them UNTIL sale/deposit completion. The agent has no way to easily verify that sandy/joe-bob are being serviced, were able to reserve, except for bugging the booking agent and/or guessing at emails. This somewhat defeats some of the automated nature and leaves a potential hole in the sales channel.

So, yes, in this particular case, buyer name AND email (not full address, not CC info, etc.) would be beneficial to all parties to ensure the buyer doesn’t drop thru a crack somewhere.

[Author]

Posts