Can rates change by quantity ordered?

—

by

Erica Thumma

Hi – my client asked if we could change the rate depending on how many items were ordered (this can also be calculated by $ spent as all items in the store are the same price at $6). The affiliate only gets a single payout following a specified end date. Basically, she wants to have these rules:

0 to 99 products sold ($594 in sales) gets a $2/item (or 33.33%) commission.

100 to 999 products sold ($600 – $5994) gets $2.50/item (or 41.6666%) commission.

1000+ products sold ($6000+) gets $2.75/item (or 45.8333%) commission.

I wasn’t sure if I could do this with Affiliates Pro, if I needed Affiliates Enterprise, another plugin or if it needs custom code. If there’s no automated solution, can she reassign a rate and make it retroactive so it applies to all previous orders made with that link?

For example, can an affiliate start out with 33% commission. When they reach $600 in sales, can they be reassigned to the 41% commission and it recalculate all previous orders with the new commission rate?

Looking forward to hearing back with your insight. Thanks!

Posted in

Comments

4 responses to “Can rates change by quantity ordered?”

  1. George Avatar
    George

    Hi Erica,

    FYI, after some more thought on this, you don’t need to use formulas and since the product price is equal for all items, you should first count the referrals recorded for an affiliate for specific dates using affiliates_get_affiliate_referrals, and then add a referral with the proper commission using add_referrals() as shown in the Example we provide here.
    Hope it helps.

    Kind regards,
    George

  2. Erica Thumma Avatar
    Erica Thumma

    Hi George,

    Thanks for the details. Yes, she wants to be able to change the commission amount based on the total sales accumulated over a period of time, so it seems that would need custom work to be automatic.

    Is there a work around for this? I believe most affiliates (in this case it’s school fundraisers) will sell 100-999 items. If we set this as the commission rate, following the end date, can she manually change the payout if the total falls below 100 items, or exceeds 1000 items sold? If this is possible, is there anything we need to consider before implementing this process?

    Or, can you run a mass update once the link changes to inactive via the referrals section? Guessing this too would need custom work. 🙂

    Thanks for your insight!
    -Erica

  3. George Avatar
    George

    Hi Erica,

    Welcome to our support forum and many thanks for being a loyal customer.
    You can have variable rates depending on the sale income or items sold using formula rates and affiliates_formula_computer_variables which is a feature of both Affiliates Pro and Affiliates Enterprise.
    However, and correct me if I’m wrong here, based on your description you want to adjust the commissions according to the performance for a set time interval, ie the total referred sales and the products sold for example during a month. For this approach a custom implementation is required which will count the referrals recorded for each affiliate and examine the orders involved to decide what would be the final commission to be paid. This way the final payment will depend on all the referred orders for the given interval.

    Also, is the rate adjustment permanent for each affiliate or would it start all over again at 33.33% once the payments are processed?

    Kind regards,
    George

    1. Erica Thumma Avatar
      Erica Thumma

      Oh, and in regard to your question about “is the rate adjustment permanent for each affiliate or would it start all over again at 33.33% once the payments are processed?” Since this is a fundraiser program, she could delete the user from the system and that way if they register another fundraiser, it would start over. …right? 🙂

Share