Gigfiliate Commissions Create a PayPal File for Mass Payouts

This is a tutorial for Gigfiliate Commissions. You will learn how to create an upload-able PayPal file for PayPal Mass Payouts.

Step 1: Copy This Spreadsheet to Google Drive

To do: Provide sample spreadsheet.

Step 2: Export All Affiliates

Export a spreadsheet of all active affiliates.

WordPress Admin > Gigfiliate > Tools > Export All Affiliates

Step 3: Download Key Metrics

Then get the Key Metrics report from Gigfiliate API.

Gigfiliate API Admin > Reports > Key Metrics > Choose Month & Year > Export to CSV

https://partners.gigfiliate.com/report/key-metrics

Upload to Google Drive. I like to upload my .CSV to Google Drive for cloud storage backup.

Rename file to “{year}-{month} {month_name} Key Metrics by Period” and open as a Google Spreadsheet.

Filter the rows at the top. Filter by TA (Total Volume) Z-A.

Comments

  • Is this an unnecessary step?

Step 4: Process Payouts

Export the Gigfiliate Process Payouts for the selected period.

Gigfiliate API Admin > Process Payouts > Export to CSV

https://partners.gigfiliate.com/payouts

Upload to Google Drive and open as a Google Spreadsheet.

Filter the rows at the top. Filter by Amount Due Z-A.

Delete records with 0 Amount Due.

Step 5:

Copy Payouts values to Final Payouts file.