İptal Edildi

Help with an MLM Web Application

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, PQV's and GQV's. 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 doesn't 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 CTE's that populate my EnrollmentTree and SponsorTree tables but I'm not sure if they're doing what they should be. These CTE's are run as a SQL job at regular intervals.

2 - Commissions: This process should be automated so that the user doesn't 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 don't, 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 didn't 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.

There's 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 they're 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.

Beceriler: .NET, e-Ticaret, MLM, SQL

Daha fazlasını gör: mlm web application, cte sql server 2005 mlm, mlm web app, binary mlm sql cte, mlm binary trees left leg right leg, y trees, write application for job, who can make me an app, what will you do for a dollar, what is vb net used for, what is the use of vb net, what is profile id, what is extended binary tree, what is binary tree in c, what is binary tree, what is a sales associate, what is a job fair, what do you need to develop an app, what are binary trees, website for mlm business

İşveren Hakkında:
( 0 değerlendirme ) Orleans, Canada

Proje NO: #618707

Bu iş için 12 freelancer ortalamada $717 teklif veriyor

Nirmal2006

Pls. check your inbox. Thank you!!...

$850 USD in 25 gün içinde
(110 Değerlendirme)
6.9
sandeep25101982

Hi! Please check PM ! Thanks

$500 USD in 10 gün içinde
(37 Değerlendirme)
6.5
varun8211

Please see PMB.

$750 USD in 30 gün içinde
(6 Değerlendirme)
6.4
sunztech

Please see PMB.

$750 USD in 10 gün içinde
(12 Değerlendirme)
5.8
expertMan

very interested to do it.

$700 USD in 30 gün içinde
(10 Değerlendirme)
5.7
ddInfotech

Please check PMB

$700 USD in 25 gün içinde
(2 Değerlendirme)
4.1
WebsiteMaker07

Lets be honest, none of the bidders above me have read your advert. I can, and I will deliver a high quality implementation of it. RELIABILITY, HONESTY, EVERY OTHER DAY UPDATES, WITH INITIATIVE,WITTY AND GREAT COMMUN Daha Fazla

$800 USD in 5 gün içinde
(1 Yorum)
0.0
manishsharma1987

please check pmb

$750 USD in 30 gün içinde
(0 Değerlendirme)
0.0
indiaBDO

hello, please check the pmb thank you BDO (INDIA)

$1000 USD in 30 gün içinde
(0 Değerlendirme)
0.0
gmwebsolutions

hi, I have gone through your requirement. Please open PM for further discussion about the project. As i am familiar with how the MLM works. thanks gm

$800 USD in 20 gün içinde
(0 Değerlendirme)
0.0
Omnipath

I have knowledge of the MLM industry and I believe that our web skills guided by your vision will create the site that you are looking for. Allowing the distributors to sign up and establishing legs or trees would be Daha Fazla

$800 USD in 20 gün içinde
(0 Değerlendirme)
0.0
toronto0072

please see pm thank you

$250 USD in 7 gün içinde
(0 Değerlendirme)
0.0
techieserve

Hi Please see PMB for details. Thanks

$750 USD in 30 gün içinde
(0 Değerlendirme)
0.0