Hi,
I have started an MLM web application and need help to finish it. This web app is done in ASP.Net (VB.Net in 3.5 environment) and SQL Server 2005. I would need someone who has worked on MLM websites before and can develop efficient tree traversal methods for binary trees in order to calculate commissions for everyone in the database. These methods should use multithreading as they will require a lot of resources.

I need help with the calculations of the commissions, PQVs and GQVs. I need to be able to calculate commissions for a specified number of levels based on your distributor type id commissions. ANy work that you do would need to be integrated into my application. I have the functionality to purchase products online and write records to the sales and orders table so you would need to calculate the percentage for the commissions for everyone in your tree and all subtrees in your tree.

Here are some of the business rules:
1 – Distributors sign up other distributors on the website. When any distributor signs up another distributor, the new distributor would need to be placed in the tree of the distributor that signed them up. He/she would have to be placed under the next available distributor that doesnt have 2 distributors assigned to them (taking into consideration the right and left leg). This next available distributor would then be the Sponsor for the newly created distributor. I just need the ContactID of that contact(sponsor) so I can enter it into the SponsorID column when the new user is created. I enter the ContactID of the person doing the enrolling into the EnrollerID column of the newly created record. I have 2 CTEs that populate my EnrollmentTree and SponsorTree tables but Im not sure if theyre doing what they should be. These CTEs are run as a SQL job at regular intervals.

2 – Commissions: This process should be automated so that the user doesnt have to log in to initiate the calculation.
Here are some facts about getting paid your commissions:
-You must meet your monthly quota (minimum $99.00 a month in online purchases) in order to get paid commissions from your downline for that month.
-You will always get 5% from sales in your downline.
-Your downline consists of your tree and every subtree in your tree.
-Based on your Distributor Rank, you will be paid up to a certain number of levels below you. (There are exceptions to this…see below)
-e.g. Associate (first level) will get paid 2 levels down
Director (second level) will get paid 4 levels down
Junior Executive (third level) will get paid 6 levels down
Senior Executive (fourth level) will get paid 7 levels down
Presidential Executive (fifth level) will get paid 8 levels down
Executive Partner (sixth level) will get paid 8 levels down

- Exceptions: all distributors in your downline must make their monthly quota of ($99.00) for you to get commissions from them. If they dont, then you can get the commissions from the distributor below this one, provided they made their quota…and so on. So if an associate can get commissions from 4 levels but one of the distributors in the 4rd level didnt make their monthly quota in sales, then you would get the commissions from one distributor in the 5th level. This applies to all levels.

3 – Distributors also get paid a certain amount when signing up a new distributor.
Here is the breakdown:
Associate – $40
Director – $80
Junior Executive – $130
Senior Executive – $170
Presidential Executive – $190
Executive Partner – $200
Also there is a 5-4-3-2-1 bonus. If an Associate signs up a distributor, he gets $40, the Director above them gets $50, the Junior Executive above him gets $40, the Senior Executive above them gets $30, the Presidential Executive above them gets $20 and the Executive Partner above them gets $10…assuming that these uplines exist. ou can never pay more than $200 for new signups.

You can also get an additional bonus if you sign up distributors in a weekly period.
3 Distributors in a week – $100
4 Distributors in a week – $200
5 Distributors in a week – $400

4 – All distributors have a PQV (Personal Qualification Volume) and GQV (Group Qualification Volume) in their profile. These numbers should be dynamic or updated once or twice a day.
PQV – This is the amount of points in sales that you have sold in the month (1 point per dollar of sales) or any regular customer that you are the Enroller for (Your ContactID will be their EnrollerID).
GQV – This is the amount of points in sales that your group below you have sold in the month (1 point per dollar in sales). Your group consists of the distributors in your tree and all subtrees in your downline. This counts for product sales as well as points from distributors you enroll.

5 – You will also move up distributor ranks by the amount of associates you have Enrolled.
Associate – enroll 2 associates and maintain a $99 in Autoship sales or $200 from customer sales.
Director – enroll 3 associates and maintain a $99 in autoship and have a 2000 GQV/month.
Junior Executive – enroll 6 associates, remain active ($99/month) and a 12000 in GQV/month.
Senior Executive – enroll 10 associates, remain active ($99/month) and a 40000 in GQV/month.
Presidential Executive – enroll 15 associates, remain active ($99/month) and a 80000 in GQV/month.
Executive Partner – enroll 20 associates, remain active and a 150000 GQV/Month.

Before calculating commissions we would check to see how many associates the user has enrolled and then update their DistributorTypeID to the proper rank. Then, that will determine how many levels to check below them for commissions.

Theres a grace period for all new enrollees, if they sign up after the 15th of the month, they can use the remainder of that month and the next full month. This extended period would be used to calculate their new enrollees and volumes in order to move them up in the ranks so that theyre given a fair chance to move up.

I can supply you with a copy of my database. You may need to make some changes based on what you will need to do. I will also need help in implementing the work that you will be doing.

Thanks and let me know if anyone has prior experience in doing this.

See also: , application, asp net, binary trees, business, business rules, commissions, copy, distributor, distributors, executive, functionality, intervals, job, left leg, levels, mlm, mlm web, month, numbers, online, partner, product, Sales, server, sign, signs, SQL, sql server, taking into consideration, tree traversal, type id, web, web application, websites, work, write