Referral records can be exported from the Export/Import tab of the Affiliates → Tools page. This export option will generate a CSV file of all referrals that match the affiliate, date, and status specified.

Unlike the payment file generated from the Referrals page, this export tool allows you to generate an itemized CSV of all referral records with each referral having its own line in the CSV.


Note: You may wish to temporarily disable email notifications before importing affiliates to prevent registration application emails from being sent during the import process.

As of version 2.1, Arabianaffiliates has the ability to import affiliates from an export file in a CSV format. Affiliate importing is done under Affiliates → Tools → Import/Export. On this page you’ll find a box labeled Import Affiliates:

Format

Your CSV should be comma separated, with fields enclosed by double quotes. The order of the fields is not important, as you’ll be mapping them in the next step.

Uploading

Click Choose File and browse to your file. Then click  Import CSV.

Mapping

Once your file is uploaded you’ll see a list of Affiliate fields that need content, and a dropdown for each one, where you can map where the data is. Each dropdown will be populated with the columns from your CSV, so you’ll be able to map accurately.

Additionally, as you choose a column, a preview from the column will appear on the right, taken from the first row of data, as in the example below.

Note: If no data appears in the right column it is NOT a problem. That merely indicates that the row being used for examples doesn’t contain data for that column.

Required Fields

The more fields you have the more complete your site data will be, which can be helpful when working with financial statements or customer information. That said, the really vital field is the Email field. The importer won’t run until the Email field has been mapped.

Importing From Non-Arabianaffiliates Systems
Arabianaffiliates is looking for this information in its import:


Affiliate Field
Expected Data Type

Email A valid email address


Username
An affiliate username, usually a plaintext string only containing letters, numbers, or underscores. In some cases this might be an email address, which should be mapped to the Email field instead.


First/Full Name Any plain text string representing the affiliate’s first name or full name. If Last Name is omitted, the First Name will be considered the “full” name.


Last Name
Any plain text string representing the affiliate’s last name. Used in conjunction with the First Name field.


Payment Email
Any valid payment email address (if available and different from the Email field)


Rate The affiliate’s referral rate, usually expressed as an integer with up to two decimal places.


Rate Type
A plain text value usually made up of letters and hyphens. Core rate types are percentage or flat.




As of Arabianaffiliates 2.0, Payout records can be exported from the Export/Import tab of the Affiliates → Tools page. This export option will generate a CSV file of all payouts that match the affiliate, date, and whether or not it was paid/failed, as specified.

This export tool allows you to generate an itemized CSV of all payout records with each payout having its own line in the CSV.

Note: You may wish to temporarily disable email notifications before importing referrals, otherwise, any affiliates who have opted-in to receive new referral notifications will be notified with Referral Awarded emails during the import process.

As of version 2.1, Arabianaffiliates has the ability to import referrals from an export file in a CSV format. Referral importing is done under Affiliates → Tools → Import/Export. On this page you’ll find a box labeled Import Referrals:

Format
Your CSV should be comma separated, with fields enclosed by double quotes. The order of the fields is not important, as you’ll be mapping them in the next step.

Uploading
Click Choose File and browse to your file. Then click Import CSV.

Mapping
Once your file is uploaded you’ll see a list of Refferal fields that need content, and a dropdown for each one, where you can map where the data is. Each dropdown will be populated with the columns from your CSV, so you’ll be able to map accurately.

Additionally, as you choose a column, a preview from the column will appear on the right, taken from the first row of data, as in the example below.

Note: If no data appears in the right column it is NOT a problem. That merely indicates that the row being used for examples doesn’t contain data for that column.

Required Fields
The more fields you have the more complete your site data will be, which can be helpful when working with financial statements or customer information. That said, the really vital fields are Email and Amount. The importer won’t run until the Email and Amount fields have been mapped.

Importing From Non-Arabianaffiliates Systems
Arabianaffiliates is looking for this information in its import:


Referral Field
Expected Data Type

Arabianaffiliates ID or Username (required)
An affiliate ID or username. The ID should be a number, the username is usually a plaintext string only containing letters, numbers, or underscores. In some cases this might be an email address, which should be mapped to the Email field instead.

Amount (required) Any plain text string representing the currency amount of the referral.

Affiliate Email
A valid email address, often used as the username.

Affiliate Username
A plaintext string only containing letters, numbers, or underscores. In some cases this might be an email address, which should be mapped to the Email field instead. If already mapping username above, set this to – Ignore this field –

Affiliate First/Full Name Any plain text string representing the affiliate’s first name or full name. If Last Name is omitted, the First Name will be considered the “full” name.

Affiliate Last Name
Any plain text string representing the affiliate’s last name. Used in conjunction with the First Name field.

Payment Email
Any valid payment email address (if available and different from the Email field) .

Currency The affiliate’s currency abbreviation that applies to this referral.

Description
A plain text value used to describe the referral.

Campaign Campaign associated with the referral.

Reference The reference field is most frequently used to note the transaction ID (or order number) of a referring sale which you’d like to associate with this referral.

Context
The context typically defines the payment system used to process the transaction. Commonly-used contexts are the name of the commerce plugin in use, such as woocommerce, gravityforms, or edd, for example.

Status
The status determines whether or not the referral is Unpaid, Paid, Pending or Rejected. If not mapped, it will default to Pending.

Date
Any standard date format
An example screenshot with the fields mapped properly, and example data showing in the right column.

REMEMBER: it’s ok if there isn’t data showing in the right column, some fields are simply empty.

 

As of Arabianaffiliates 2.1, Visits can be exported from the Export/Import tab of the Affiliates → Tools page. This export option will generate a CSV file of all visits that match the affiliate, date, and whether or not the visits were converted, unconverted, or either, as specified.

This export tool allows you to generate an itemized CSV of all visit records with each visit having its own line in the CSV.