Forum Replies Created
December 13, 2013 at 6:40 pm in reply to: Using eMember Registration, Referrer is not saved in Affiliate DB table #59600
I ended up coding another option in the Affiliate Center Menu that lists referrals that have not turned into sales.
I will eventually charge a membership fee, but my affiliates want to know that their referrals are being credited correctly. The data was in the table, I just created another menu option to display this data in a table.
Thanks for making the source code available so pepole can make such changes as necessary. Without such, I would not be able to use your plugin, but so far it’s working out very well.December 12, 2013 at 1:41 am in reply to: Using eMember Registration, Referrer is not saved in Affiliate DB table #59598
Upon further investigation, the referrer field is updating correctly in the Affilaite table.
The original problem that let me to post the problem is that the referrers are no showing in the Affiliate Center.
The clicks are showing and any custom tracking codes are there but no list of referrers.
I’m thinking since everyone is signging up for free and there are no sales referrers are not shown?
But it seems there should be something showing your referrals regardless of if there is a sale or not.
So, How to get a list of referrals of eMember registractions showing in the Affiliate Center even if there are no resulting sales and the referrer field does have the referrer username in the referrer field in the table?
Great!, Thanks for the answer. It confirms what I thought.
In that case, rather than increase the cookie life, I think my plan will be to write some custom code to look up the member’s referrer in the DB first, then include that in the PayPal button custom variable field as referring affiliate if found in the DB. I’ll make this override any existing cookies. If I didn’t do this, then another affiliate cookie could potentially hijack the original affiliates referral.
Your plugin/code is much more flexible and customizable than other membership and affiliate code I have tried and had to throw out. It’s the only member/affiliate code for WP I’d recommend at this point.
Thank’s again, for the quick support.
Regarding your response. It did not directly answer my question. That part was already clear; the fact that once a member subscribes the affiliate will continue to get a commission on that “subscription”. Assuming “subsciption” meaning a particular paypal subscription. As that is not distinctly clear. And assuming a person with an eMember “membership” can be referred to as a “membership” not a subscription.
But and so, My real question was regarding membership upgrades which is still not clear, which I understand PayPal handles as a NEW subscription, since in most cases a new PayPal button is used with new a NEW subscription price and details.
So if a member/client decides to upgrade his eMember “membership” with a NEW PayPal “subscription”, say from $10/month to $20/month way after the cookie expires, is this NEW PayPal subscription still credited towards the original affiliate with proper commission? Is this situation accounted for in eMember?
I hope the question is more clear now.
Thanks again for your answer and support here
great, ok, makes sense.
I think one last question…
If the member upgrades a few months later after the cookie has gone away, is the Affilate Platform smart enough to credit it to the right affiliate?
I ask because the upgrade requires a new PP subscription button and the affiliate cookie may not be around still but I’d still want to continue paying the affiliate.
Thanks for the response.
Yes, I initially did follow those instructions in the link mentioned to get the PayPal subsciption button working but it only mentions creating or generating the notify URL which contains the subscription reference variable: subscr_ref.
All that works. What does not work or happen is giving the affiliate credit. Does the ap_id variable need to be included in the custom variable as well? If so, that should be mentioned on that page and would have saved me from creating this thread.
I found this in ipn_handle_debug_eMember.log which helped to explain some.Quote:
[11/11/2013 12:23 AM] – SUCCESS :Membership payment paid for membership level ID: 3
[11/11/2013 12:23 AM] – SUCCESS :WP Affiliate Platform is installed, checking if custom field has affiliate data…
[11/11/2013 12:23 AM] – SUCCESS :Custom field value: subsc_ref=3
[11/11/2013 12:23 AM] – SUCCESS :Could not find affiliate ID (ap_id) data in the custom field
[11/11/2013 12:23 AM] – SUCCESS :Referrer value is empty! No commission will be awarded for this sale
In the referrer field in the eMember table the correct affiliate/referrer is there so it still somehow knew who the affiliate was/is.
In my button code I only had subsc_ref=3
<input type=”hidden” name=”custom” value=”subsc_ref=3″>
Should I also include ap_id like this?
<input type=”hidden” name=”custom” value=”subsc_ref=3&ap_id=AFFILIATEID”>
The plan is do dynamically create the value= contents anyway using PHP so if I know
it is necesary to include ap_id I can do that a number of ways it seems…
$_COOKIE probably being the most appropriate I think.
So is it true that I always should include the “ap_id” variable in the custom field of the button?
Then the next question is how are reoccuring affiliate commissions are handled.
I would imagine that each month that PayPal bills the customer, PP will continue to post back both custom variables so the sale can be credited to the affilaite.
So will both subsc_ref and ap_id always be included in the monthly IPN post from PayPal?
If this is the case, it makes sense… and I will find a way to make sure ap_id is included in the custom field.
Let me know if this is correct.
Thanks again for following up. Much appriciated.
as I wait for a definitive answer here from admin…
So this leads to 2 more questions..
1) Which IPN script is used for what reason and how do I know which is called in my situation.
2) If I am going in the right direction with this, where in the eMember IPN script do I include the GET request with my affiliate sale info.
This all leads to another question as well. Since I want to pay affiliates on reoccuring monthly membership payments, is this automatically done? Or do I have to add additional code that checks if a membership has an associated affiliate and take that into consideration before posting my GET request from the eMember IPN.
How could it be so tedious and difficult to integrate 2 plugins from the same developer that I thought would be integrated “out of the box”?
I can’t be the only one that has wanted to pay Affiliate commissions on memberships, but I can find any referrences or examples on how this is done anywhere on your site or forums.
Please help me out here mr admin or developer.
The first link posted above has not mention of Affiliate Platform integration.
The second link is what I have already metioned which leads to the problem of eMember and Affiliate Platform both wanting to use a special PayPal notify parameter in the button.
I can direct you back to my first post for more clarification.
I will try today and let you known how it works. Thanks for the feedback
Thanks for the suggestion but no. At that link, it talks about crediting the Affiliate with a “Lead” different that paying a commission on a membership sale.
What I want to do is pay a 25% commission to the Affiliate who referred a sale of a membership.
If it makes a difference, members sign up FREE. I have special code that requires them to upgrade to a paid membership after 7 Days. When they upgrade, there membership after 7 days, this would be the first time they pay with a PayPal subscription button.
What I need that is not happening now… is to credit the Affiliate with 25% of the membership price and for each and every month after.
When doing a paypal subscription button test, the eMember “wp_eMember_members_tbl” table is updated correctly
The table has the correct membership level and even has the correct referrer in the “referrer” field so I know the affiliate is being tracked somehow. Probably from a cookie.
But nothing appears in the affiliate’s sales, only the referred clicks are being registered.
The affiliate log does not have any actions in it either that look like a sale is being generated.
Intergrating these 2 plugins should be the most brain dead thing. Right? I Don’t see how can’t find an obvious brain dead answer
Thanks for some pointers