Can you please implement a piece of code to carry the ID throughout a user being logged in case they upgrade or downgrade to preserve the Affiliate and referral relationship?
Thank you.
Cesar
Carry Affiliate Sponsor code throughout backend for upgrades and downgrades
Posted in Affiliates Enterprise
Hi Kento,
This helped a lot. I can now manually fix affiliate relations for subscriptions linked to Direct that should go to a specific affiliate. My concern is that on new subscriptions or upgrades/downgrades the referral isn’t being assigned to the appropriate affiliate. Is there a way to link this table with Manage Affiliates area and permanent affiliate plugin??
So that I don’t need to do it manually? It’s a lot if work 🙁 thank you
Hi Cesar,
I think the best option would be to do the SQL update I suggested rather than trying to link tables. Do you have a way of relating old and new subscription IDs that we could use for that? I’d be happy to help you figure out what exact query has to be run.
Hello Kento, ok this makes sense now. I found that table which appears to still contain OLD subscription numbers from members. Regardless, what is the tool from the GUI that updates this table? No matter what I change in the GUI of Affiliates Pro, that table DOES NOT get updated.
The only way for me to update that table is by hand and this can be a very daunting task.
Fortunately I do have the option on to capture Direct-1 and that is how I can find the subscription IDs. Thank you.
Please advise.
Hi César,
The table is only an internal reference so the system can relate subscriptions when a recurring payment is recognized and grant the affiliate a referral for it. There’s no GUI integration for that because for the use-cases where it is involved, there is no admin involvement.
If you have to make a large update, I wouldn’t do it manually, rather run an SQL update on the table relating old and new transaction IDs. Of course, that would work only if you have a relationship between old and new subscription IDs.
Hello I have tested the fix and replied to you to email. It still does not work with the latest fix. Why are some recurring going to Direct if their affiliate relationship isn’t under direct? Maybe if you explain how the process works I can fix it myself.
Cesar
Hi Cesar, for recurring payments the integration uses a table that relates the subscription_id to the initially referring affiliate. This table is
wp_aff_subscriptions(mind thewp_prefix which could be different in your database). A referral would be recorded for a recurring payment if the related subscription is found there.Antonio I have sent admin dashboard access. Can you please confirm you received it?
Also what’s the latest version of affiliate permanent?
The screenshots in the documentation look different then the version 1.0.2 I have
Hi,
I have sent you an email with the latest version. Please update and test again.
cheers
>> The “Permanent affiliate” option in the user profile is done automatically when a new customer is referred by an affiliate.
This does NOT happen automatically for me. How can I make this to be automatic please. Maybe you gave me an old version of Permanent Affiliates or it doesn’t work with the new version of WordPress? Please advise
>>For the affiliate kfed100, the assignment to Katie would need to be done from within the affiliate profile, under Affiliates > Manage Affiliates > Edit > Tiers > Referrer, you would set kfed100′s to Katie.
He was already set to Katie. He logged into his account which was (Subscriber) paid to reactivate (Level 2 in S2Member) and Katie didn’t get credit nor did the Level 2 (We are using Tier 2)
Hi Cesar,
please send us dashboard admin access to support at itthinx dot com and we’ll have a look.
cheers
Hello, I have tested the plugin out but it’s not working. Can you please explain how to fix the problem I outlined in this video:
http://screencast.com/t/U0ammLg6Fw6p
Hi César,
Thanks for explaining your question through the screencast, that makes it much easier to help 🙂
The “Permanent affiliate” option in the user profile is done automatically when a new customer is referred by an affiliate. This isn’t related to how the tiers work in Affiliates Enterprise, it simply reminds the system to grant referrals for any purchases that are made by the customer, to the affiliate that is assigned there in the user profile. The assignment is done automatically when a customer account is created after being referred by an affiliate. With the option, the assignment can also be changed by an admin in the user profile.
For the affiliate kfed100, the assignment to Katie would need to be done from within the affiliate profile, under Affiliates > Manage Affiliates > Edit > Tiers > Referrer, you would set kfed100’s to Katie.
I hope that makes it clearer, please let me know if you need further help.
Cheers
Hi,
I have sent you an email.
cheers