“Connect” existing users manually to affiliates

—

by

Robert

HI,

We are migrating our old system, users, vouchers and affiliates to Woocommerce Subscriptions with Affiliates Pro. In other words – we make everything new and must import users (done), vouchers (done) and affiliates.

We added the affiliates manually and it works well – we are good here.
But we need to “re-connect” customers/users to the affiliates, so they get also the commission paid from us for users they brought months ago…

Example: Affiliate “John Smith” brought the customer “Sabine” in 2015. Sabine has a monthly subscription and pays $ 9.90 every month automatically by PayPal until she cancels. So we must be safe that “John Smith” Sabine is connected to John Smith for her customer lifetime.

By the way: Can we “move” customers from one affiliate to another?
Meaning: If Sabine would have cancelled in June 2016 and „John Smith” stopped working with us. And another affiliate “Jimmy Smith” brings Sabine back as a customer, how can we do this?

Thanks for your help,
Robert

Posted in

Comments

7 responses to ““Connect” existing users manually to affiliates”

  1. Robert Avatar
    Robert

    Hi Antonio,

    Thanks. But I’m not shure if I understand it right now. What/how must we do if we…

    1. import users (done)
    2. add affiliate partners and commission rate (done)
    3. manually add a subscription to some users/customers (not done)
    4. Now: How to bring the users in a life-time-relation to their affiliates – manually

    Maybe it’s better to register a new test-user, buying a subscription and look what’s stored in which db, isn’t it?

    Robert

    1. antonio Avatar
      antonio

      Hi Robert,
      yes, I think the best option is create a test-user and consult in the db the table.
      Kind Regards,
      Antonio B.

  2. Robert Avatar
    Robert

    …and there is no wp_aff_subscriptions table.

    We have only this:
    cb_aff_affiliates
    cb_aff_affiliates_attributes
    cb_aff_affiliates_users
    cb_aff_hitsVerstecken
    cb_aff_referrals
    cb_aff_robots

    1. antonio Avatar
      antonio

      Hi Robert,
      That’s true, sorry. The subscriptions are based on the aff_referrals table. You need to search about the post_id (this post_id must be the subscription product id).
      When a subscription is renewed, the plugin search on the referrals table where the post_id is the same that the subscription product id.
      Kind Regards,
      Antonio B.

  3. Robert Avatar
    Robert

    Hi Antonio,

    Yes, we are using Woocommerce Subscriptions.

    We could do it in the DB. But I have seen the http://www.itthinx.com/shop/affiliates-permanent/ Add-on. Is this doing the same?

    Additional:
    I wrote an Email to itthinx@itthinx.com on Sept. 22nd, but get no answer – can you help also?
    “Hi,

    I placed and paid an order with the number Order #18919 for Checkbilliard GmbH
    Unfortunately we haven’t received an invoice which we can use in our bookkeeping. Can you please send us one?

    Additionally I haven’t used your coupon code “Store Sale! Use the coupon code sale20 on orders in our Shop.”
    Can you redeem this retroactively?t”

    Thanks,
    Robert

    1. antonio Avatar
      antonio

      Hi Robert,
      Affiliates Permanent doesn’t change the existing subscriptions.
      Related to the invoice, I’ll talk to @karim about it.
      Kind Regards,
      Antonio B.

  4. antonio Avatar
    antonio

    Hi Robert,
    I assume that you are using Woocommerce Subscriptions. You can not change the relation between subscriptions and affiliates from the dashboard, you could do it directly from the database. There is a wp_aff_subscriptions table that you can chnage.
    Makes a full backup before to change anything in the database.
    Kind Regards,
    Antonio B.

Share