How to export affiliate data to CSV

Affiliate for WooCommerce plugin helps you to add, manage affiliates, and track performance from a single place – commissions, sales, payouts, leaderboard, etc. Earn money without hard work. Increase your brand outreach, and get potential customers.

The plugin offers the following export options for affiliate data over selected date ranges, with or without filters:

The standard CSV contains the following information for each affiliate present in your store:

• Name – The display name of the affiliate user.
• Email – The email address of the affiliate user.
• Earned Commissions – The total amount of commission earned by the affiliate.
• Unpaid Commissions – The total unpaid amount of commission.
• Total Order – The total number of orders received via the affiliate’s referral.
• Total Visitors – The number of visitors who came through the affiliate’s referral.

1. Go to WordPress Admin > WooCommerce > Affiliates > Dashboard.
2. By default, data for the past 30 days is displayed and exported. To change this, use the date picker in the top right corner to select your desired date range.
3. If you want to filter data based on commission status, affiliate status, or affiliate tags, click on “Search & Filter” at the top and select the filters that suit your needs.
4. Click the drop-down menu and select “Standard CSV” to export your data.

If you want to make a mass payout via payment file (i.e., Payouts Web), you can export this file and process the payout.

The Mass Payout CSV contains the following information for each affiliate:

• Emails – Affiliate’s email address where they will receive the payment (PayPal email address).
• Unpaid Commissions – The total amount of unpaid Commissions.
• Currency – The currency in which the commission is calculated.

1. Go to WordPress Admin > WooCommerce > Affiliates > Dashboard.
2. By default, data for the past 30 days is displayed and exported. To change this, use the date picker in the top right corner to select your desired date range.
3. If you want to export data based on specific criteria, such as commission status, affiliate status, or affiliate tags, click on “Search & Filter” at the top and choose the filters that suit your needs.
4. Locate the Export option on the left-hand side. Click the drop-down menu and select “Mass Payout CSV”.

You can import this CSV file into your PayPal account or other payment services that support mass payments.

We have integration with WooCommerce Analytics to display and export affiliate details within the Orders report.

To view or export this report, ensure that Analytics is enabled from WordPress admin > WooCommerce > Settings > Advanced > Features.

1. Access the Orders Report: Once Analytics is enabled, go to WordPress Admin > Analytics > Orders.
2. Filter your Data: Use the date range picker and advanced filters to refine your data as needed.
3. View Affiliate Details: In the orders table, there’s an Affiliate column that displays the name and user ID of the affiliate who referred the order.
   1. Click on the ID, it will take you to the WordPress admin > WooCommerce > Affiliates > Dashboard to view referral details for that specific affiliate.
4. Export to CSV: To export to CSV, click the download button located in the table header.

Have a feature request or enhancement suggestion for Affiliate For WooCommerce? Submit a request or send it to us from here.