Manually Assigning Affiliate to Another for 2nd tier

I am working on a project with 2 partners, I have manually added the partners to amember as users/affiliates. We are selling an item for $15.00, partner 1 gets 5.00, partner 2 gets 3.00. I setup the affiliate program to pay 5.00 at level one, and 3.00 to the 2nd tier affiliate. How do I manually set partner 2 to be the referring affiliate of partner 1? What field in amember_members table do I update, and I assume I should update it to the member_id to make this work?

g

It should happen automatically when affiliate 2 signs up under affiliate 1, but not clear on what you mean. Can you explain if this is different than a standard 2 tier?

David

I manually entered the users, there isn't one signed up under the other. So I just need to edit the amember_members table to make it look like he signed up under the other.

Ah, yep, you got it.

David

No I don't, I don't know what field to update or what to update it with.

Table: amember_members
Field: aff_id

You need to set aff_id with the user id of the member you want to put all them under.
You'll need to do an SQL query in phpmyadmin to set it.
Do a backup first!

UPDATE amember_members SET aff_id = "1"

This will set all members to the be under the member #1

David

Perfect answer, thanks.