Home Forums Plugin Support AffiliateWP MLM reconnecting mlm trees after site export then site rebuild and import

6 replies, 2 voices Last updated by  Christian Freeman 3 weeks, 1 day ago
  • Steven Potter
    Participant
    @steveaplus-com-au
    #10604

    reconnecting mlm trees after site export then site rebuild and import.
    I have had to rebuild my site so exported all I could then imported into newly built site but affiliate numbers all changed, trees are not visible and no links that we can see, the affiliates don’t see their downline.

  • Christian Freeman
    Participant
    @christianf
    #10614

    Hi Steven,

    Hmmm, that’s a tough one. The MLM plugin stores the affiliate connections in the database using each affiliate’s Affiliate ID. Once those IDs change (Which doesn’t happen in a normal situation), the system can’t recognize which affiliates were connected to which.

    At this point, the only thing you can do is manually connect the affiliates to their correct Parent & Direct Affiliate. The easiest way to do this is to change it via the Edit Affiliate screen. This method will at least allow you to see a list of affiliates to connect them to. Otherwise, you would have to edit your affwp_mlm_connections table using phpMyAdmin, and manually update those Affiliate IDs, which is much more difficult.

    Do you still have access to the old version of your site? Maybe a database backup file?

  • Steven Potter
    Participant
    @steveaplus-com-au
    #10615

    yes still have the old site running in a sub folder on the server so yes can thread them together manually after I finish changing all the affiliate ID’s to the right number because the export and import for that don’t work together (the import lists them all in reverse order) and I learnt you can’t just remove them reverse the order in the import file and import again because it starts its numbering from where it left off before so all numbers then started at 180 upwards, this has turned into a massive job and because I didn’t have the right numbers on the affiliates I hadn’t imported the referrals and now the site has new referrals starting from 1, affiliates getting angry, I’m stressed, and at this stage I’m sorry I ever started on this direction.

  • Christian Freeman
    Participant
    @christianf
    #10636

    Hi Steven,

    How is this process working out for you? I actually didn’t realize that the affiliate importer would import the affiliates in reverse order. That is an issue.

    I’ve been thinking about ways to make this easier, and I figured the fastest and simplest way, would be to export your affiliates database table from the original site, and import it into the database of your new site. This would ensure that the affiliate IDs match the originals. You could do the same thing with the affwp_mlm_connections table – Export the database table and import it to the new site.

    To clarify, this would have to be done using a database management program such as phpMyAdmin or something similar.

  • Steven Potter
    Participant
    @steveaplus-com-au
    #10649

    I’m stuck stumbling through now as I have new affiliates signing up that I’ve got to edit each time because their membership starts at site default 0.10% instead of 10% and can’t seem to change the default.
    Have some affiliates with customer info in their back office (not theirs or their customer info).
    Have some affiliates with number of 3 to 400 sub affiliates under them but no tree when they don’t really have any.
    Overall the export and import has been a dismal failure after following that route I would hope for clear and concise instruction in future from the AffiliateWP team, although I’m now never likely to try the process again in fact I would rather scrap the whole AffiliateWP idea.

    Thanks so much for your help Christian it has been much appreciated.

  • Steven Potter
    Participant
    @steveaplus-com-au
    #10762

    Hi Christian, hope all is well, I have referred a contact to buy your plugin and pointed him to this forum if he needs help.
    Update: my site has now settled and stopped deleting older users as new ones join, I think it just had to get over the first numbers that were imported.
    Still have the problem with when someone joins it does not assign the site default referral rate and type, even though it looks that way, unless I go into their affiliate edit screen and click percentage and move the rate to 10 they will only get 0.1% on a referral.
    Let me know if you have any ideas about that 🙂

  • Christian Freeman
    Participant
    @christianf
    #10772

    Hi Steven,

    I’m glad to hear that things are starting to work smoothly with your affiliate program after rebuilding your site. And thanks for recommending us as well.

    There is one way that I know of. You can use our Ranks add-on to setup a Default Rank (Eg. Basic Affiliate), which will be automatically assigned to all new Affiliates. Then, you set the commission rate for that Default Rank to 10%. This should take care of this for you.

You must be logged in to reply to this topic.