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 ?
Commission Percentages more than 2 decimal places
Posted in Affiliates by Username
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.
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.
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?
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.
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.