3 replies [Last post]
roclok's picture
Offline
Joined: 04/07/2010
Juice: 18
Was this information Helpful?

Bear with me while I am learning the ways of Drupal, Ubercart and Affiliate programs.

I have searched high and low for a way to pay commissions to indirect sales people.

I want to pay out commissions based on number of sales, essentially if they sell from 1-10 units they get $12, from 11-20 units they get $15, etc. There would be 5 levels of payment.

To complicate things I will pay out on the 15th and the 30th, but the volume calculations are based on the month, so there would need to be compensation paid on sales from the 1st to the 15th that were underpaid ( ex. they sell 10 units by the 15th, receive a check for 120, then sell another 10 from the 15th to the 30th, then they should have received payment of $15 per unit not $12)

I hope this is making sense.

I would like them to be able to view commissions, sales receipts etc, but most of that functionality is there already.

The commissions would be calculated when they process their sales, it is accepted and the credit card is processed. I need a simple 1 page form for the sales people to fill out, check boxes for the product or products they are selling, shipping and billing address for the end customer, credit card info, shipping and tax would be calculated and added to sale then the sales Rep would click submit and the order is either accepted or denied...

I have setup and tried to use Affiliate V2 but it does not appear to have the functionality I need.

Thank you in advance!

roclok's picture
Offline
Joined: 04/07/2010
Juice: 18
Re: Affiliate payment and setup

Has anyone created some PHP script to do anythign like this? Does anyone have any insight on how to have a tiered comission structure paying based on sales not clickthrough?

Thanks!

manatwo's picture
Offline
Joined: 02/19/2008
Juice: 235
Re: Re: Affiliate payment and setup

This wouldn't be too hard to write a module for - you can use Ubercart's hook_order and check the user id of the user creating the order to create a record in a new table in the database of the sale. The rest would just be a matter of doing the math and fitting the orders within the date range.

roclok's picture
Offline
Joined: 04/07/2010
Juice: 18
Re: Re: Re: Affiliate payment and setup

OK, I found that PHP script thank you!

Now does anyone have anything written that I can just cut and past in there or the terms I will need to use to make it function properly?

Also how does this tie into the affiliate system, and where is that database you are reffering to.

Agian thanks for helping me to learn this system!