Carry Affiliate Sponsor code throughout backend for upgrades and downgrades

—

by

cramirez77

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

Posted in

Comments

13 responses to “Carry Affiliate Sponsor code throughout backend for upgrades and downgrades”

  1. cramirez77 Avatar
    cramirez77

    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

    1. kento Avatar
      kento

      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.

  2. cramirez77 Avatar
    cramirez77

    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.

    1. kento Avatar
      kento

      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.

  3. cramirez77 Avatar
    cramirez77

    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

    1. kento Avatar
      kento

      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 the wp_ prefix which could be different in your database). A referral would be recorded for a recurring payment if the related subscription is found there.

  4. cramirez77 Avatar
    cramirez77

    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

    1. antonio Avatar
      antonio

      Hi,
      I have sent you an email with the latest version. Please update and test again.
      cheers

  5. cramirez77 Avatar
    cramirez77

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

    1. antonio Avatar
      antonio

      Hi Cesar,
      please send us dashboard admin access to support at itthinx dot com and we’ll have a look.
      cheers

  6. cramirez77 Avatar
    cramirez77

    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

    1. kento Avatar
      kento

      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

  7. antonio Avatar
    antonio

    Hi,
    I have sent you an email.
    cheers

Share