No Totals After Relaunch

Hello,

Our Affiliates Pro > Totals show all Affiliates with a total of 0 (despite dozens of orders).

Looking through the history — we notice this has happened after relaunch, is there way to “reassociate” affiliates with the order data?

Posted in

Comments

4 responses to “No Totals After Relaunch”

  1. George Avatar
    George

    Hey Jason,

    Thanks for the additional info on this. The Totals report relates directly to your referrals, hence my question about the contents found in Affiliates > Referrals report. On the other hand, the rates relate to the calculation of the referral commission, when a referral is tracked.

    What do you get if you go to Affiliates > Referrals and then if you go again to Affiliates > Totals and Clear your filters, so that the report includes referrals of any status?

    From your description and findings it looks as if some of your Affiliates tables are missing data. In case you partially imported your database, I would recommend you to import it again fully, perhaps first in a new staging site.
    Also, in case you’re using any of the plugins listed here, https://docs.itthinx.com/document/affiliates-pro/troubleshooting/alleged-optimization-plugins/, I would recommend you to avoid them because as mentioned in this page, they can be responsible even for loss of data. During the db-optimization process, these plugins can delete db tables for no valid reasons.

    Kind regards,
    George

  2. Jason Avatar
    Jason

    The Rates Table found here: {/wp-admin/admin.php?page=affiliates-admin-rates}

    Is empty, even though pre-existing users have rates assigned.

    Could this be affecting the Totals?

    Do I need to manually recreate everyone’s rate in that table?

  3. Jason Avatar
    Jason

    If I go here: /wp-admin/admin.php?page=affiliates-admin-totals

    Filters:

    Referral Status: ACCEPTED

    Date Range: {Last Month – All of June 2025} (we relaunched May 15th)

    And I look at all the totals for ANY affiliate, the totals column shows 0 — which is making it difficult to know what to pay my affiliates.

    The list contains all the affiliates who had their coupon codes applied but not their Totals.

    I’ve reviewed the affiliates themselves — they have both Coupon Codes and percentages assigned, but the Totals are 0.

    Relaunch entailed rebuilding the website from the ground up, didn’t change servers, but worked on a staging server, then migrated back into the existing server.

  4. George Avatar
    George

    Hi Jason,

    Welcome to our support forum for Affiliates Pro.

    Can you please share some more information on your reports? When you mention that totals are zero, does it mean that there are no results rendered? Or do you get your affiliates listed but each one has a total of 0(zero)? What records do you get in Affiliates > Referrals and Affiliates > Manage Affiliates?
    Last but not least, what did your relaunch include? Did you migrate to a new server or installed Affiliates Pro again?

    Kind regards,
    George

Only authorized members can comment on this topic.

Log in