redirect affiliate link

Posted in

Hi,

I have an affiliate who was deleted from our list of affiliates mistakenly. She has re-registered, but her original affiliate URL is already in use. I tried using a 301 redirect to send her old URL to her new Affiliate URL that was generated when she reregistered, but that does not seem to be working.

Can you recommend a solution?

5 Responses to redirect affiliate link

  1. Leah August 28, 2014 at 5:14 pm #

    Hi Anthony,

    Thank you for your help.

    I looked at both tables and you are correct that they don’t match. This particular affiliate is not listed in the second table “wp_aff_affiliates_users”.

    I am looking at the table via phpmyadmin in our cPanel, and I don’t see an an option to add a line to enter that info.

    Any suggestions?

    • antonio August 29, 2014 at 10:28 am #

      You could create the affiliate in Affiliates->Manager Affiliates using an ‘username’ of a wordpress user already created.
      In your phpmyadmin you should have ‘Insert’ in the top horizontal menu (when you are viewing the table data).
      cheers

  2. Leah August 26, 2014 at 4:58 pm #

    ok. i went ahead and did this, but now when i log in using her credentials to test, i get redirected to the “affiliate sign up” page. The log in info is accepted as a regular wp user, but not for the affiliate area.

    i would go ahead and create a new user and change the aff id in the wp_aff_affiliates table, but the problem with that is when i delete someone whose email address has already been in the system, they do not get the new affiliate registration email with the password in it. so, i would have a user with no way to access the account because we don’t know their password.

    • antonio August 27, 2014 at 6:55 am #

      You could restart the password in the wordpress user profile page.
      There are two tables in the database with information about the affiliate account:
      wp_aff_affiliates : when you can set the status.
      wp_aff_affiliates_users: relating to affiliate with an existing user
      Maybe there isn’t an row in this second table, so your wp user is not an affiliate.
      cheers

  3. antonio August 26, 2014 at 6:27 am #

    Hi,
    you could update the “deleted” affiliate status from ‘deleted’ to ‘active’ directly in the database: wp_aff_affiliates table. So you can still use the original links.
    cheers

We use cookies to optimize your experience on our site and assume you're OK with that if you stay.
OK, hide this message.

Affiliates · Contact · Jobs · Terms & Conditions · Privacy Policy · Documentation · Downloads · Useful Plugins · My Account

Share