wp_aff_referrals ip and user_id fields

—

by

gpbush

Two fields in wp_aff_referrals are not behaving as I would expect. Affiliates seems to be keeping track of referrals properly, but all of the records have the ip field = 387409553 and the user_id = 0 . Are theses fields deprecated or do I have a problem with my s2member notification URLs?

This became an issue as I am looking for an easy way to print a report showing all of the referrals by affiliate number, just like the one in Affiliates>Referrals and if these fields were populated correctly, it would solve my problem.

Posted in
Tags , ,

Comments

11 responses to “wp_aff_referrals ip and user_id fields”

  1. gpbush Avatar
    gpbush

    Thank you for the answers, but my original questions is still unanswered.

    Here is what I am looking for:

    We offer a data subscription and give customers a 30 day free trial, with no credit card required.

    Since not credit card is required, their signup does not generate a transaction ID. (Affiliates is properly notified through the s2Member Registration API)

    I am looking for the specific field that ties the new user to an affiliate, as I cannot find it.

    I am looking for a report to give my affiliates that shows them their Free trial users, when they signed up, etc. It is the exact information that is shown when you go to Affiliates>Referrals. The shortcode affiliates_affiliate_stats does not do this.

    1. antonio Avatar
      antonio

      Sorry, I don’t understand you,
      If you need create an affiliate from an user, you must use “username” field when you create the new affiliate (on Affiliates->Manager Affiliates), but if you need create a referral when a new user is registered, you can use Affiliates Members.

      In your report, you can use “data” attribute to show more information (use the notification url params), for example:
      [affiliates_affiliate_stats type="stats-referrals" data="full_name,payer_email,user_login"/]

  2. gpbush Avatar
    gpbush

    And do not use the Affiliates-Extra-Tokens plugin, as it breaks the s2member integration.

    1. antonio Avatar
      antonio

      Hi,
      fixed Affiliates-Extra-Tokens. Tokens like as order_XXX are for woocommerce data, but you can use user_XXX.

  3. gpbush Avatar
    gpbush

    I use some of the shortcodes for the notification email, but I do not see how that helps from the reporting side…

    I already use the notifications for registration & signup properly, I think, because the information I want to display for my affiliates is shown properly when I go to Affiliates>Referrals. That is the exact report I want my affiliates to see. How do I get that exact report for my affiliates, both printed and so that they can see it for their own referrals?

    1. antonio Avatar
      antonio

      You can use Affiliates-Extra-Tokens as referrence, and create your own tokens.

  4. gpbush Avatar
    gpbush

    Thank you, but all that does is list the file by affiliate. The user id is still 0 for all of the members that were referred, so I cannot print what new users “belong” to what affiliate. The user id is buried in the data field, but shouldn’t it be in the usr_id field instead?

    I am looking to be able to give my affiliates a report that looks just like the screen when you go to Affiliates>Referrals and select an affiliate.

    1. kento Avatar
      kento

      No, the user_id in that table is not going to help you (that’s the current user’s ID when the referral is recorded and with the notification triggering that it should be empty).

      Have a look at the wp_aff_subscriptions table, you will find the subscription ID related to the referring affiliate’s ID there.

      By the way, why don’t you just use the stats shortcodes – the Detailed Referral Overview section in the documentation explains how to use it.

      1. gpbush Avatar
        gpbush

        The wp_aff_subscriptions table uses the transaction id to link the referral to the affiliate. This is only generated from the payment gateway, so no free users show up in this file. I need a way to manage free users who do not did use any form of payment. This way we can work to convert them.

        As for the short codes, that was my preferred method, but none of them work for this. As an example, the shortcode above, does not show any email address, or any identifying information – just date, post, amount, Currency, Status and a line for Details – No email, user id or name.

        All I want is to print a list of the free subscribers, with their emails just like when you go to the Affiliates>Referrals section and run the reports. Optimally, I would want one of your short codes to work so that each affiliate could see their own referrals.

        1. kento Avatar
          kento

          You can use the referral data along with the shortcodes now, there’s an interesting topic on that Name, Phone and Email for referring affiliate and see this comment on the tokens that can be used.

          You can in fact use the notification URLs to record referrals when the users sign up, instead of just when the user makes a payment. That way you will have referrals with the user data and no amount, and the usual referrals for payments. For that you would use a similar notification URL under Registration Notifications as the one that is proposed for Payment Notifications under s2Member > API / Notifications.

  5. kento Avatar
    kento

    If you want them by affiliate, the field that identifies the affiliate is affiliate_id in that table.

    An example query listing all referrals and sorted by affiliate id in ascending order, date and time of the referral in descending order, would be:

    SELECT * FROM wp_aff_referrals ORDER BY affiliate_id, datetime DESC;

    Does that help you?

Share