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
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
Hi Robert,
yes, I think the best option is create a test-user and consult in the db the table.
Kind Regards,
Antonio B.
…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
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.
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
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.
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.