Sales Not Being Tracked

Tagged: affiliate, estore, no sales, PayPal, sales not tracking, wp shopping cart

This topic has 20 replies, 4 voices, and was last updated 12 years, 1 month ago by wpCommerce.

Viewing 15 posts - 1 through 15 (of 21 total)

1 2 →

Author

Posts
February 18, 2011 at 5:21 am #2727

frlane
Member

Hi I am having issues with the affiliates not being credited with sales. The click-throughs are working fine, and showing up immediately, but sales are not showing up.

Fortunately, these aren’t ‘open to the public’ yet, but there is one real affiliate, and her two sales did not track, and neither have my test sales. I have tried the Affiliate plugin on another one of my sites (on a different server) and that one is not tracking the sales either. On one site I am using your eStore and on the other site I am using your WP Shopping Cart plugin.

The two sites are:

http://www.capturemyscreen

http://www.localhcg.com

Any help would be greatly appreciated….especially since it is likely something stupid that I am missing or doing incorrectly.

February 18, 2011 at 5:24 am #29162

frlane
Member

I should probably add that the sales are going through without a problem, they just aren’t being credited to the affiliate.

February 19, 2011 at 12:01 am #29163
wpCommerce
Moderator
Can you please do a test transaction with the debug enabled and share the content of the following files:
```
ipn_handle_debug.log

eStore_post_payment_debug.log
```
Please have a look at the following post which will explain on debugging:

https://support.tipsandtricks-hq.com/forums/topic/how-and-when-to-enable-debug-and-what-does-it-do
February 19, 2011 at 1:41 am #29164

frlane
Member

At first it returned a blank screen, so I followed all the instructions, including going directly to the PHP file. I finally discovered the IPN was off on my account. I turned it back on, did some test purchases using different browsers and the only thing the logs say is…..

[02/19/2011 1:28 AM] – Advisory : Log file reset.

I have tried using the sandbox, not using the sandbox and nothing seems to work.

The other site uses your simple paypal cart, not estore. How do I fix that one?

February 19, 2011 at 1:44 am #29165

frlane
Member

Just a moment! I tried doing step number 4 with the sandbox, and this time I got the following……..

[02/19/2011 1:28 AM] – Advisory : Log file reset.

[02/19/2011 1:43 AM] – SUCCESS :Paypal Class Initiated by 216.113.191.33

[02/19/2011 1:43 AM] – SUCCESS :Post string : test_ipn=1&payment_type=instant&payment_date=17%3A43%3A07+Feb+18%2C+2011+PST&payment_status=Completed&payer_status=verified&first_name=John&last_name=Smith&payer_email=buyer%40paypalsandbox.com&payer_id=TESTBUYERID01&business=seller%40paypalsandbox.com&receiver_email=seller%40paypalsandbox.com&receiver_id=TESTSELLERID1&residence_country=US&item_name1=something&item_number1=AK-1234&quantity1=1&tax=2.02&mc_currency=USD&mc_fee=0.44&mc_gross=15.34&mc_gross_1=12.34&mc_handling=2.06&mc_handling1=1.67&mc_shipping=3.02&mc_shipping1=1.02&txn_type=cart&txn_id=7219143&notify_version=2.4&custom=xyz123&invoice=abc1234&charset=windows-1252&verify_sign=AIMUd4ewZmbFyGCDKV59JUTO1lA8A7z2TT3LWpVKfPq7Ts1XuL-PUVBB&

[02/19/2011 1:43 AM] – SUCCESS :Connection to http://www.sandbox.paypal.com successfuly completed.

[02/19/2011 1:43 AM] – SUCCESS :IPN successfully verified.

[02/19/2011 1:43 AM] – SUCCESS :Creating product Information to send.

[02/19/2011 1:43 AM] – SUCCESS :Transaction Type: Shopping Cart

[02/19/2011 1:43 AM] – SUCCESS :Number of Cart Items:

[02/19/2011 1:43 AM] – SUCCESS :Product Email successfully sent to buyer@paypalsandbox.com.

[02/19/2011 1:43 AM] – SUCCESS :Notify Email successfully sent to video@capturemyscreen.com.

[02/19/2011 1:43 AM] – SUCCESS :Updating Products, Customers, Coupons, Sales Database Tables with Sales Data.

[02/19/2011 1:43 AM] – SUCCESS :Products, Customers, Coupons, Sales Database Tables Updated.

[02/19/2011 1:43 AM] – SUCCESS :Updating Affiliate Database Table with Sales Data if Using the WP Affiliate Platform Plugin.

[02/19/2011 1:43 AM] – SUCCESS :No Referrer Found. This is not an affiliate sale

[02/19/2011 1:43 AM] – SUCCESS :Paypal class finished.

February 19, 2011 at 1:55 am #29166

frlane
Member

Now I am trying to do a test purchase, but when I make the purchase, I get sent to the Paypal sandbox, which says I am logged in, but still has a ‘Login to Paypal’ box. It won’t let me login!

I am brand new to the Sandbox, and I am so frustrated!

February 19, 2011 at 3:13 am #29167

amin007
Participant

First time in PayPal sandbox can be a bit overwhelming so take it easy and you will get there

This article should help you I think:

http://www.tipsandtricks-hq.com/playing-in-paypals-sandbox-2880

Just one note… when using the PayPal sandbox transaction in eStore the buyer actually won’t receive the email as sandbox uses simulated buyer email which is not a real email address where mails can go to.

February 19, 2011 at 4:45 am #29168

frlane
Member

And what about the affiliate stuff still not working??

February 20, 2011 at 12:02 am #29169

wpCommerce
Moderator

[02/19/2011 1:43 AM] - SUCCESS :No Referrer Found. This is not an affiliate sale

Did you follow an affiliate link to make the test purchase?

February 20, 2011 at 12:45 am #29170

frlane
Member

That message came from the sandbox itself, hitting the IPN tester. When I try making a test purchase (or a real one) the debugger is blank.

February 20, 2011 at 2:08 am #29171

amin007
Participant

“When I try making a test purchase (or a real one) the debugger is blank” – This issue needs to be resolved first. This basically means the IPN is not coming to eStore when you make a real purchase and hence nothing is being written to the log file. We have a step by step checklist that will identify where the issue is. Please go through the following checklist and you will find the issue:

https://support.tipsandtricks-hq.com/forums/topic/what-to-do-if-the-debug-file-is-empty

February 24, 2011 at 1:43 am #29172

frlane
Member

I already went through that entire list with no change. That’s how I knew to check and then activate the IPN in PayPal. What else could it be? This is really frustrating.

February 24, 2011 at 2:50 am #29173

amin007
Participant

Well, lets go over it again step by step.

I just checked your site http://www.localhcg.com and found out that the debug isn’t even turned on!

Can you please go to the settings menu of eStore and check the “Enable Debug” checkbox on this site and let me know?

February 24, 2011 at 5:48 am #29174

frlane
Member

The site I have been testing with is http://www.capturemyscreen.com. The LocalHCG site is the one using your Simple Paypal Shopping cart. I have the estore on the localhcg site, but it isn’t being used (yet). Both sites were not recording the affiliate sales info.

February 25, 2011 at 4:07 am #29175

amin007
Participant

Okay thanks. So your site doesn’t have a permission issue about writing to debug files. It can also receive IPN from PayPal as sandbox is doing it.

Can you please tell me if you have the “http://www.capturemyscreen.com” checkbox checked in the settings menu of eStore?

I can also see that the shopping cart is including the proper “notify_url” variable there.

One other thing to check is your PayPal account. What URL have you entered when you enabled “IPN” in your PayPal account?
Author

Posts