Once your program is running, you need to know what it is producing. Affiliate and Referral Program for WooCommerce keeps a running scoreboard on its own dashboard, and lets you take the underlying data out as a spreadsheet whenever you need it. This guide covers the figures on that dashboard, what each one counts, and how to export your affiliates and their commissions. Part of the plugin documentation.
The program scoreboard
↑ Back to topGo to: WooCommerce > Affiliate & Referral > Dashboard. The cards across the top answer the questions you are most likely to be asked in a monthly review:
- Total affiliates – how many people are signed up to promote you.
- Total Referrals – how many earnings the program has generated, counting every kind: sales, network commission, bonuses and rank rewards.
- Total Commission – what those earnings add up to. This is the number to budget against: it includes everything still waiting for your approval, and leaves out only what you have rejected.
- Approved Commission – the part you have already signed off, and which is therefore sitting in affiliate wallets.
- Pending Commission – earnings awaiting your decision on Manage Referrals.
- Rejected Commission – what you turned down, kept visible so the numbers reconcile.
- Payout Paid and Payout Pending – money actually sent to affiliates, and withdrawal requests still queued. These come from the payout side, not from commission approval.
These cards cover your affiliate program. Rewards from the customer refer-a-friend program are deliberately excluded — it is a separate programme with its own balances, and mixing the two would misstate both.
Clicks, purchases and conversion
↑ Back to topThree tiles further down measure how well the traffic your affiliates send actually converts:
- Total click – how many times affiliate links have been opened.
- Total Purchase – how many of those visits ended in an order. This tile is a count of orders; the dashboard prints your currency symbol in front of it, which you can ignore.
- Conversion Ratio – the second as a percentage of the first.
These three count links your affiliates built with the link generator, which is where the click and purchase counters live. A sale credited through a coupon code still earns commission and still appears in every commission figure above — it simply has no link click to count, so it does not move the conversion ratio.
Recent activity and your strongest affiliates
↑ Back to topTwo short tables close the dashboard. Last 5 Referrals lists the most recent earnings with their Amount, Date, User and Time — a quick check that tracking is still working after a change. Top 5 Affiliates ranks your partners by what they have earned, showing User, Referrals and Total Amount, which is the shortlist worth a bonus, a better rate or a personal email.
For the full picture behind these summaries — every earning, its type, its status and the order it came from — work from the ledger on Approve, Reject and Manage Referrals, or open a single partner’s record from How to Approve and Manage Your Affiliates, where their referrals, payouts and traffic are listed per affiliate.
Export your commission records
↑ Back to topOn WooCommerce > Affiliate & Referral > Manage Referrals, use Filter & Export Referral Table to set a From: and To: date, then take the result as CSV or PDF. Generate Referral CSV downloads the commission records as a spreadsheet with one row per earning:
- Order ID – the order the commission came from, so you can reconcile against WooCommerce.
- Affiliate ID and Affiliate Name – who earned it.
- Request Date – when the earning was created.
- Amount – the commission.
- Device – whether the buyer was on desktop or mobile.
Export your affiliate list
↑ Back to topThe Affiliates screen mirrors this. Filter & Export Affiliate Table narrows by date and exports to CSV or PDF, and Generate Affiliate CSV produces the roster: Affiliate ID, Affiliate Name, Affiliate Email, and Parent Id with Parent Name — the affiliate who recruited them. That last pair makes the file useful for more than a mail merge: it is a flat representation of your multi-tier network, one row per member.
These exports are one-way. There is no import: editing a downloaded file and uploading it will not create or change affiliates, commissions or payouts. Treat the files as reporting and accounting copies, and make every change on the screens themselves.
What affiliates can export themselves
↑ Back to topAffiliates running a network of their own get one export on their dashboard: Download Full MLM Sales CSV, listing every member below them with their sales and commission totals. It is scoped to their own downline, so no affiliate can export anyone else’s figures. See How to Set Up MLM in Your Affiliate Program.
FAQ
↑ Back to topDoes Total Commission include earnings I have not approved yet?
↑ Back to topYes. Total Commission counts pending and approved earnings together and excludes only rejected ones, so it is a liability figure rather than a paid figure. Compare it with Approved Commission to see how much is already committed, and with Payout Paid to see how much has actually left your account.
Why is my conversion ratio lower than my sales suggest?
↑ Back to topThe ratio compares purchases to clicks on generated referral links. Sales credited another way — a coupon code, or a customer already tied to an affiliate by lifetime commission — count in your commission totals but bring no click with them, so they lower the ratio without being lost.
Can I import affiliates or commissions from a spreadsheet?
↑ Back to topNo. The exports are read-only downloads and there is no import routine. Affiliates join through the registration form, and a one-off earning can be added by hand with Enter Referral Manually on the Manage Referrals screen. Moving from another platform is covered in Switching from Another Affiliate Plugin.
Where do I see one affiliate’s own numbers?
↑ Back to topOpen them from the Affiliates screen: each record has its own referrals, payouts and traffic, described in How to Approve and Manage Your Affiliates. Affiliates see the same figures for themselves on their dashboard. More questions are answered in the Affiliate and Referral Program: FAQ.
