WP-Affiliate to Affiliate Pro

I have used WP-Affiliate for years, but now I am migrating to Woocommerce and have purchased Affiliate Pro.

If I am database savvy, is there a way for me to insert data I extract from WP-Affiliate into Affiliate Pro and not require my affiliates to change their affiliate id, making their transition effortless?

3 Responses to WP-Affiliate to Affiliate Pro

  1. Edward March 18, 2018 at 7:55 pm #

    Thanks, the id’s are incompatible – I’mm just having affiliates sign up again.

    • Kento March 19, 2018 at 11:15 am #

      Hi Edward,

      We’re discussing the possibility to add an option which should make this easier – I assume that if we add an option to adopt the user ID as the affiliate ID where possible, that should make it compatible. Please let us know if this still comes in time and we’ll try to add this so you can use it.


  2. George March 14, 2018 at 9:41 am #

    Hi Edward,

    I haven’t used WP-Affiliates and haven’t tried it before but if you can export your affiliates list, you can import it using Affiliates Import. There is a detailed description on how to set your import file. You might need to tweak affiliate ids but since you’re database savvy, it won’t be hard.

    Your other option would be to export the affiliates table from WP-Affiliates, modify the structure and import it to wp_aff_affiliates table. On that case don’t forget to have a look at wp_aff_affiliates_users, it’s the table that connects an affiliate to a user.

    In both cases I would recommend you to try this in a staging site and after finishing the process, try to register a few new affiliates through the registration form and check that the affiliate id auto-increments properly.

    Kind regards,

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