Support » Plugin: YITH WooCommerce Affiliates » Affiliates have negative balance

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author YITHEMES

    (@yithemes)

    HI James

    this usually happens when there are problems with orders
    Have you recently deleted an order?

    Balance param is just calculated subtracting the total paid from the total earned
    Unfortunately, these data are stored into DB, inside affiliates table, and there is no direct way to access them

    Maybe you could try updating them with a query, that changes paid amount to reset balance to zero

    I will work to add a function to recalculate these totals, and to add some checks that avoids plugin showing a negative balance

    Hope this helps
    Have a nice day

    Thread Starter James Fosker

    (@james-fosker)

    I have not removed any transactions, how would I perform a query to fix this

    Plugin Author YITHEMES

    (@yithemes)

    Hi again

    Well, you could try to use any editor your hosting offers to read and change db tables (usually phpmyadmin), or any remote tool, to change affiliate row, and make earnings value equal to paid value

    If you’re not sure about how to proceed, anyway, I suggest you to wait until “recalculate” code gets released

    Hope this helps
    Have a nice day

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Affiliates have negative balance’ is closed to new replies.