Steven PotterParticipant@steveaplus-com-auAugust 6, 2019 at 1:32 am #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 FreemanParticipant@christianfAugust 7, 2019 at 1:39 pm #10614
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 PotterParticipant@steveaplus-com-auAugust 7, 2019 at 10:52 pm #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 FreemanParticipant@christianfAugust 19, 2019 at 4:05 pm #10636
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.
You must be logged in to reply to this topic.