Commission Percentages more than 2 decimal places

—

by

Ryan

Is it possible to make the commissions more accurate. For example, I have a product that is $399 and I want to pay $50 to my affiliate this is something like 12.532%. Can I do more that 2 decimal places? So in the back end…. 0.12532 ?

Posted in

Comments

5 responses to “Commission Percentages more than 2 decimal places”

  1. Ryan Avatar
    Ryan

    Thanks, I did all that and it’s still showing up as 2 decimal places after I save it. Does the system just not show all the places but saves the data anyway? I changed the functions.php and the MySQL as instructed. The MySQL is showing up as (18,5) as described.

    1. antonio Avatar
      antonio

      Hi Ryan,
      the referrals already registered, they don’t change.
      If you generate new referrals with more decimals, they should be saved with the new limit.
      Kind Regards,
      Antonio B.

      1. Ryan Avatar
        Ryan

        So it’s backwards. What I found out is that the payout or commission has 5 decimal places now, but not the commission percentage. Meaning when someone get’s a 10% commission it shows as $50.00000 instead of just $50.00

        The place I need to have the commission set is in the percentage that the person is charged. Meaning currently I’m limited to 0.12 commission in each product and I need it to be 0.12345 or more if possible so I can be more accurate with my pay out.

        I hope this makes sense. I will try to reverse what I did before but can you direct me to resolve this issue?

        1. antonio Avatar
          antonio

          Hi Ryan,
          If you use this filter (affiliates_referral_amount_decimals) for ex. to 5, then you can set a value with 5 decimals as rate in Affiliates->Woocommerce Integration or in Affiliates->Settings:Commissions.
          If you only need to set 5 decimals to rates, but not in the referrals values, then don’t change the database value, only use the filter.
          Kind Regards,
          Antonio B.

  2. antonio Avatar
    antonio

    Hi Ryan,
    There is a filter called affiliates_referral_amount_decimals you can use to achieve this described in the documentation.
    Please first read the instructions carefully, because there is also a modification you should do on the database as well.
    Kind regards,
    Antonio B.

Share