Skip to main content

Affiliate Ultimate

Mageplaza Affiliate extension for Magento 2 is the greater choice than ever if you want to build an Affiliate program that is crazy enough to drive traffic and sales increase promptly, get qualified leads, and also enhance your brand awareness. Our Affiliate program allows you to pay affiliates an amount of commissions.

Mageplaza Affiliate User Guide will provide detailed instructions to know How to use on the frontend and How to Config on the backend.

How to Use​

After installing Affiliate module, the Affiliate link is available on the footer of your site. Click on the link and go to Affiliate Home Page.

Affiliate Home Page​

Affiliate Home Page is already setup with CMS Block including Welcome Message and How does Affiliate Program work? If you want to change the text, it is possible to edit from the backend. In addition, all of active Affiliate Program will be displayed on the Affiliate Home Page.

Look at the left panel on the page, the customer can sign up to become an affiliate.

My Affiliate​

Each affiliate can manage every credit information such as available balance, holding balance, total earned, total paid, and all transactions related to the account are listed in detail.

  • Credit Information: Display Available Balance, Holding Balance, Total Commission, and Total Withdrawal
  • Balance Report

  • Policy

Campaigns​

Campaigns, Commission, Discount, Coupon Code, Valid Time, Copy Referral Link button, and More Details will be shown here:

Affiliate module by Mageplaza allows affiliate refer friends via referral URL, code and email.

Just insert friends' email addresses together with a message to send invitation instantly on Affiliate Links and Banners page. Besides that, they can edit the Referral Code or share Referal URL via social media.

Customers can edit the Referral Code in this section:

Banners​​

At the Banner Page, all available banners according to each campaign will be listed here:

When clicking on “Get Banner link”, the HTML and Banner Link will show as below:

In this Ultimate version, the Report for the Banner on Frontend/ Backend for each campaign is shown as follows:

My Withdrawal Page​​

Mageplaza Affiliate supports offline payment and PayPal payment for the withdrawal. You can check the 10 most recent withdrawals. Each created withdrawal will be saved and managed in Withdraw History. Let's follow its status to know where the request is in progress.

Balance History Page​​

Affiliate allows you to check Commission Logs with detailed information about the affiliate account's commission receipt including time, campaigns, status, customer ordered, product, Total sales, and Commission. Besides that, the Withdraw History is also displayed to record affiliate account withdrawal details (Amount, Fee, Withdraw Method, Withdraw Description, Status, and so on).

Commission Logs and Withdraw History are displayed in the following screenshot:

Report Page​

Affiliate accounts can see the balance reports for each purchase here

Setting Page​​

When the affiliate account selects which email to receive, that email will be sent.

How to Configure​

From the Admin Panel, go to Mageplaza Extensions > Affiliate > Configuration

1. Configuration​

1.1. General​

  • Enable: Choose Yes to apply the feature of the module

1.1.1. Advanced configuration

  • Cookie Expiration

    • Enter the number of days to store cookies of this program.

    • If skip it, the default (365) is used, that means Lifetime Commissions can be active.

  • Allow overriding cookies: Choose Yes to override Affiliate code when a customer is referred by many Affiliates.

  • Enable Banner: If Yes, the banner will be shown on the Affiliate Links and Banners page on the frontend.

  • Show Report for Banner on Frontend: If Yes, will show the report of Impressions, Clicks of customers to each banner.

  • Show Affiliate link on: Choose the display position of the Affiliate link

    • Show Affiliate link on = Footer Link: Display the Affiliate link at the bottom of the page

    • Show Affiliate link on = Top Link: Display the Affiliate link at the top of the page along with the link

  • My Account

    • You can choose to display in both positions

    • If admin does not choose the position to display Affiliate link, the link only shows on Frontend at My Account Page when customers login.

  • Custom CSS

    • Admin can freely customize the display of the Affiliate site

    • Supports HTML, CSS

  • Traffic Source Statistics Page Content: Set the Page Content that you want to statisticize the Traffic Source.

  • Enable Referral History: Select Yes to show Refer History page in My Affiliate. Display information of customers invited using Refer URL or Coupon Code, including columns such as ID, Customer Name, Customer Email Address, Date.

  • Enable Affiliate Referral Information: Select Yes to show Parent Affiliate customer information on the My Account page. Note that, the customer account has Sign Up Account Affiliate and the Affiliate account has been active.

1.1.2. Default Page​

  • Affiliate homepage content

    • Select CMS Block for Affiliate homepage content

    • The default display is: Affiliate Welcome homepage content

  • Affiliate Policy content

    • Select CMS Static Block for Affiliate Policy content
    • The default display is: Affiliate Welcome homepage content

1.1.3. Coupon code

  • Allow using Affiliate Code as Coupon: Select YES, so customers can use Affiliate Code as Coupon code on the shopping cart page and checkout page.
  • Coupon Suffix: Enter the Suffix you want to set for the Affiliate Code.

1.1.4. Affiliate URL

  • URL Style: Choose the type to display URL

  • Custom parameter

    • Enter the letter for the customization of Affiliate URL. Those parameters here will be inserted in front of the Refer code.
    • If this field is left blank, the default value is "u".

    For example: refer code is 123, Custom parameter is ABC

  • Hash: http://example.com#abc123

  • Parameter: http://example.com/?abc=123

  • Parameter value

    • Parameter value = Affiliate ID: Display the ID of Affiliate account on the Refer URL link in My Account/ My Affiliate/ Refer Friend outside the frontend. For example: ?u=1 or #u1

    • Parameter value = Affiliate Code: Display the code of Affiliate account on the Refer URL link outside the frontend. For example: ?u=b1dc or #ub1dc and display the code of Affiliate account in the Refer Code field in My Account/ My Affiliate/ Refer Friend outside the frontend

  • Length of Affiliate code

    • Enter the length of Affiliate code

    • The default length is 6 characters

    • It is recommended to enter a length between 3 and 32 characters to ensure safety

1.2. Account Configuration​

1.2.1. Affiliate Sign up

  • Default Affiliate Group

    • Choose the default group whenever an account is registered as an Affiliate account

    • The original default group is General

  • Require admin's approval: Choose No so that when registering as an affiliate account, you don't need to go through the censorship of the store

  • Checked "Email notification" by default: Select Yes to automatically check the Receive affiliate email box on the My Account/My Affiliate/Setting tab outside the frontend whenever an account is registered as an Affiliate account.

1.2.2.Terms and Conditions

  • Enable Terms and Conditions: Choose Yes to display Terms and Conditions in the Sign Up section which is outside the frontend

  • Checkbox Text: Enter the checkbox text that is in the right of Terms and Conditions checkbox.

  • Terms and Conditions Title: Enter the title for Terms and Conditions

  • Terms and Conditions Content

    • Select CMS Block for Terms and Conditions Content

    • The default content is Affiliate terms & conditions

  • Checkbox is checked by default: Choose Yes to tick in the checkbox automatically

1.2.3. Account Balance

  • Maximum of Affiliate Balance

    • Enter the Maximum of Affiliate Balance

    • If Affiliate reach the milestone, none of commission is added

    • If the field is left empty or entered as zero, Affiliate Balance will have no limitation

  • Allow negative balance: If Affiliate's account balance is not enough to take back commission, allow the balance be negative number by choosing Yes in the respective field

1.3. Commission Configuration​

  • Earn commission from tax: Choose Yes to earn commission from tax

  • Total Commission Statistics including On Hold Commissions: If yes, commissions that are in On Hold status will also be calculated in the Total Commission column in the Traffic Source Statistic page.

1.3.1. Commission calculation process

  • Allow Affiliate receiving commission when Invoice created

    • Allow Affiliate receiving commission when Invoice created = Yes: Commissions received when creating an invoice

    • Allow Affiliate receiving commission when Invoice created = No: Commissions are only received when the order is in the completed state

  • Hold commission transactions for

    • Enter the days between commission transaction for accounts. After that period of time, the transaction will no longer be kept

    • If the field is blank or entered as 0, the transaction will not be kept

  • Deduct commission from Affiliate's balance when the order is refunded/canceled

    • Choose Yes to allow deducting the commission from the balance of the branch when the order is refunded or canceled

    • The default allows deducting

1.4. Withdrawal Configuration​

  • Allow withdrawal request: Select Yes to display the withdrawal request outside the frontend

  • Payment Method

    • There are three withdrawal methods which are Offline payment, Bank Transfer and Paypal payment, and Store Credit. Affiliate extension is completely compatible with Mageplaza Store Credit (v4.0.4 or above for M2.4 | v1.1.9 or above for M2.3 or below) to support withdrawal with the store credit payment.
    • Enter the withdrawal fee for each form of withdrawal. You can enter the charge as a specific amount or a percentage of the total amount withdrawn
    • To allow displaying a withdraw’s form outside the frontend, select Active = Yes corresponding to that form

  • The minimum balance in affiliate account for requesting withdrawal

    • Enter the minimum balance in the linked account to request a withdraw

    • If you leave blank or fill in as 0, you will not be limited when withdrawing

  • Minimum withdrawal amount

    • Enter the minimum amount for each withdraws

    • The withdraw fee will be included in here

  • Maximum withdrawal amount

    • Enter the maximum amount for each withdraws

    • The withdraw fee will be included in here

1.5. Email Configuration​

  • Email Sender

    • Select the email sender

    • The default email sender is: General Contact

1.5.1 Admin Email

  • Send Emails To: Enter the email address so that admin can receive notifications. You can fill in multiple emails, separate them by commas ","

  • New Affiliate Sign Up: Select Yes to let admin receive notification emails when a customer signs up for affiliate program. This will show the Sign up Template field

  • New Withdraw Request: Select Yes to let admin receive notification email when a customer requests withdraw. This will show the Withdraw Request Template field.

1.5.2. Account Email

  • Send Welcome Email: Choose Yes to send the email when an account registered as an Affiliate account

  • Welcome Email

    • Choose the email template sending when an account registered as an Affiliate account

    • The default content of the template is Welcome Email (Default)

  • Welcome Email After Account Approved

    • Choose the email template sending when the registered account is approved to be an Affiliate account by the store owner

    • The default content of the template is Welcome Email After Account Approved (Default)

  • Account Rejection: Select Yes to send email to the customer whose request register for affiliate account is rejected. This shows the Account Rejection Template field

  • Account Change Status: Select Yes to email the customer when the status of the affiliate account changes. This shows the Account Change Status Template field

  • Withdraw Cancel Email: Select Yes to email customer when the customer's withdraw request is canceled. This shows the Withdraw Cancel Template field

1.5.3. Transaction Email` section

  • Send Transaction Email: Select Yes to send a notification email whenever there is a transaction

  • Update Balance Email

    • Select the sending email template when there is a change in the balance

    • The default content of the template is Update Balance Email (Default)

1.5.4. Withdrawal Email

  • Send Withdrawal Email: Select Yes to send a notification email when you withdraw money

  • Withdrawal Complete Email

    • Select the sending email template when there is a change in the balance

    • The default content of the template is Withdraw Complete Email (Default)

1.5.5. Campaign Email

  • Send New Campaign Email: Select Yes to send a New Campaign Email to the affiliate account when a new campaign is created and that affiliate account must meet the campaign conditions.
  • The receiver will receive the email as this form

  • Send Expired Campaign Email: Select Yes to Send Expired Campaign Template to the affiliate account when the campaign expires and that affiliate account must meet the campaign conditions
  • The Expired Campaign Template will be in this form:

Note: These emails will be sent at 0 a.m every day.

1.6. Refer Friends Configuration​

  • Enable Refer Friends Feature: Choose Yes to activate the introduce to friends function

  • Refer Sharing Email

    • Choose the email template which will be sent when introducing with friends through email

    • The default content of the template is Affiliate Sharing Email (Default)

  • Default Refer URL

    • Insert the referral link. This link will display in the My Account/My Affiliate/Refer Friend tab

    • If empty, the default homepage url will be used.

  • ShareThis.com Property ID

    • Enter the Property ID to identify your ShareThis property.
    • If empty, default Public ShareThis ID 65435143043d5c0012cc72df will be used
    • Instructions on how to get property values can be foun here

  • ShareThis.com Tool

    • Select your Enabled Engine under Property ID. Because each Property ID corresponds to a different domain, if your tool does not belong to the entered Property ID, the social refer friend section will not work.

  • Use Cloudsponge to retrieve email contacts: Select Yes to allow access contacts from customer's account such as Gmail, Yahoo, Live, AOL, Outlook, etc.

  • Cloudsponge Key

    • Enter the Cloudsponge key

    • The default key used is a473483c2e256bd812bdc9a0bac867ecf1999a54

  • Enable Referral via Social Networks on Product Listing Page: If Yes, the Referral via Social Networks will be displayed in the product listing page, helping customers to share and introduce to their friends to join the campaigns and get certain promotions.

  • Enable Referral via Social Networks on Product Details Page: If Yes, Referral via Social Networks will be displayed in the product details page.

Note: As AddThis.com no longer supports, the features in this section have accordingly stopped working since May 31st, 2023.

1.6.1. Sending Email Content

  • Default Subject Email

    • Enter a title for the sending email

    • The default title is Good product and services

  • Default Email Body

    • Enter the content for the sending email

    • The default content is I've been shopping at {{store_name}} and feel really happy. They provide good service and reasonable prices.

1.7. Credit Balance Chart​

Admin can change the Background color and Border color of the Balance Chart at the Balance Report Table on My Affiliate Page.

2. Manage Accounts​

From the Admin panel, go to Marketing > Affiliate > Manage Accounts

2.1. Manage Grid​

  • Display Affiliate account information: account balance, total earned amount, account activity status, etc. Click Edit link to see the account details.

  • In this panel, admin can delete the account by clicking to the account checkbox, then choose Action > Delete

2.2. Mass action: change affiliate group​

Admin can change the affiliate group with one click:

2.3. Add New Account​

  • Account: Choose account

  • Affiliate Group: Select the group for the created Affiliate account

  • Referred By: Enter the ID of the previously registered Affiliate account

  • Status

    • Status = Active: The Affiliate account which is just created can start working now
    • Status = Inactive: The Affiliate account which is just created can't start working yet
    • Status = Need Approved: The affiliate account which is just created needs to be approved by admin

  • Email Notification: Choose Yes to receive notification emails when there is a change in your Affiliate account balance

2.4. Edit account​

Admin can edit the account and check the transaction log of the affiliate account here:

3. Affiliate Groups​

From the Admin panel, go to Mageplaza Marketing > Affiliate > Affiliate Groups​

3.1. Manage Grid​

  • There are five default groups: General, Bronze, Silver, Gold, Platinum

3.2. Add New Group​

  • Name

    • Insert the group name

    • This field is compulsorily required

4. Campaigns​

From the Admin panel, go to Mageplaza Marketing > Affiliate > Campaigns

4.1 Edit Campaigns​

  • Step 1: Fill in the Campaign Information
  • Step 2: Choose the conditions for applying the campaign
  • Step 3: Set up Actions

Step 1: Fill in the Campaign Information

Campaign Information​

  • Name

    • Name your campaign

    • This is a required field

  • Description: Fill in the description of your campaign

  • Status: Sellect Enable to apply the campaign

  • Website IDs

    • Choose the website to conduct the campaign
    • This is also a required field

  • Affiliate Groups

    • Choose the group you want to conduct the campaign
    • This is another required field

  • Display

    • Display = Allow Guest: Show the campaign for all visitors
    • Display = Affiliate Member Only: Show the campaign for Affiliate only

  • Active From Date: Select the starting day for your campaign

  • Active To Date: Select the finishing day for your campaign

  • Priority: Enter the number of priorities for each campaign. If the conditions are met, the campaign with the lowest priority will be applied.

Campaign Referral Link

This includes the Referral Link field to create referral links for the campaign. If left blank, it will default to the only link placed in the Configuration section.

Step 2: Choose the conditions for applying the campaign

  • You can choose the products for a specific campaign by setting the rules for those products
  • Or you can also choose the categories for applying the campaign
  • If you satisfy the conditions in the cart and the conditions here (for each specific item), you will receive a discount and commission

Step 3: Set up the Action

  • Choose the rule for each item matching the following conditions
  • Leave it blank if the rule is for all items.

Set up Discount

  • Apply

    • Apply = Percent of product price discount: Apply discount for the percentage of each product price
    • Apply = Fixed amount discount for product: Apply a fixed discount for purchasing

  • Discount value: Insert the amount or the percentage of discount for purchasing

  • Apply to Shipping Amount: Choose Yes to apply discount for shipping

  • Discount Description: Insert the description for your discount policy

Set up the Commission​

This section allows to configure the Tiers. You can choose one or add more tiers as follows:

  • Pay per commission: Pay per sale is the default option for this field.

  • There are two commission types:

    • Percentage of product price: Commission is calculated based on the percentage of each product price
    • Fixed amount: Commission is a fixed amount

  • Choose type and value of commission in the 1st order and the next orders. You can set them to the same or separate option depending on your strategy.

4.2 Add New Campaigns​

  • Step 1: Fill in the Campaign Information
  • Step 2: Choose the conditions for applying the campaign
  • Step 3: Set up Discount

Step 1: Fill in the Campaign Information

Campaign Information​

  • Name

    • Name your campaign

    • This is a required field

  • Description: Fill in the description of your campaign

  • Status: Select yes to apply the campaign

  • Website IDs

    • Choose the website to conduct the campaign
    • This is also a required field

  • Affiliate Groups

    • Choose the group you want to conduct the campaign
    • This is another required field

  • Display

    • Display = Allow Guest: Show the campaign for all visitors
    • Display = Affiliate Member Only: Show the campaign for Affiliate only

  • Active From Date: Select the starting day for your campaign

  • Active To Date: Select the finishing day for your campaign

  • Priority: Enter the number of priorities for each campaign. If the conditions are met, the campaign with the lowest priority will be applied.

Campaign Referral Link

This includes the Referral Link field to create referral links for the campaign. If left blank, it will default to the only link placed in the Configuration section.

Step 2: Choose the conditions for applying the campaign

  • You can choose the products for a specific campaign by set the rules for those products

  • Or you can also choose the categories for applying the campaign

Step 3: Set up the Action

  • Choose the rule for each item matching the following conditions
  • Leave it blank if the rule is for all items.
  • From the Affiliate Pro, it applies multi-tier: for each item in a campaign, you can receive discounts and commissions according to different tiers

Set up Discount

  • Apply

    • Apply = Percent of product price discount: Apply discount for the percentage of each product price
    • Apply = Fixed amount discount for product: Apply a fixed discount for purchasing

  • Discount value: Insert the amount or the percentage of discount for purchasing

  • Apply to Shipping Amount: Choose Yes to apply discount for shipping

  • Discount Description: Insert the description for your discount policy

Set up the Commission

This section allows to configure the Tiers. You can choose one or add more tiers as follows:

  • Pay per commission: Pay per sale is the default option for this field.

  • There are two commision types:

    • Percentage of product price: Commission is calculated based on the percentage of each product price
    • Fixed amount: Commission is a fixed amount

  • Choose type and value of commission in the 1st order and the next orders. You can set them to the same or separated option depending on your strategy.

5. Withdraws​

5.1. Manage Grid​

  • Allow showing the withdraw history of each Affiliate account including The amount, the status, payment method, etc. Click Edit to see the details of each withdraw.
  • Admin can also change the status or delete the withdraw history.

5.2. Add New Withdraws​

  • Account

    • Click on this field to show the affiliate accounts that have positive balance which can be withdrawn

    • This field is required

  • Amount

    • Insert the withdraw amount which is including the fee of withdrawal

    • This is a required field

  • Fee

    • Insert the withdraw fee

    • If you leave this field empty, the configuration value will be applied

  • Payment Method

    • Choose the payment method for withdrawal

    • There are three payment methods: Offline payment, Bank Transfer, Paypal payment

  • Withdraw Description: Fill in the description for withdrawal

  • Payment Detail:

    • For Offline payment, you need to insert the Addresses
    • For Bank Transfer, insert the Bank account
    • For Paypal payment, you need to fill in the Paypal email and Transaction ID

  • Payment Email: Enter the Paypal email who receives commission

  • Paypal transaction ID: Enter Paypal transaction ID

6. Transactions​

6.1 Manage Grid​

  • Show the transaction of each affiliate account including the amount, status, the order, Product SKU, Product Qty, and Campaign that generates a commission. Click View to see more details of each transaction.
  • The transaction is created according to each item: For each item in the order that meets the conditions in the campaign, the affiliate account receives a commission. Each item will create 1 transaction. In case 1 item has many qty, if the customer creates an invoice/shipment or refund each item according to the qty quantity, a transaction will be created according to the number of invoices, shipment, refund, and qty.
  • Admin can also change the status or delete the transaction records.

Assign to Affiliate Group

After adding the new Affiliate accounts, store admin can manage them in the Accounts Management grid.

  • On the grid, find the Affiliate account needed to assign and open the Edit mode

  • Choose the Affiliate group to assign. By the default, General is chosen

6.2. Add New Transaction​

  • Account

    • Click on this field to show the affiliate account and then you can choose the account to add transaction in

    • This is a required field

  • Amount

    • Insert the added amount. It can be a negative one

    • This is a compulsorily required field

  • Title: Add the Title of transaction

  • Holding Transaction For

    • Add the number of days that you want to keep the transaction records

    • If you leave it empty or insert 0, the transaction will be deleted

7. Email​

7.1 Notification emails for successful registration the affiliate account​

7.2 Notification emails for Affiliate account aproval​

7.3 Notification emails for changing the Affiliate account balance​

7.4 Notification emails for completion of withdraw request​

7.5 Notification emails for admin when there is a request to create Affiliate account​

7.6 Notification emails for admin when there is a request to withdraw​

7.7 Notification emails for customer when an account creation request is rejected​

7.8 Notification emails for customer when status of Affiliate account changes​

7.9 Notification emails for customer when withdrawal request is rejected​

8. Compatible with Mageplaza Store Credit (Withdraw)​

Affiliate is compatible with the Store Credit extension by Mageplaza to support withdrawal into store credit accounts conveniently and connect accounts with each other.

9. Reports​

9.1 Compatible with Mageplaza Reports Standard and Professional​

9.1.1 Top Affiliate

  • This card will show Top 5 Affiliate account who earn the highest commission in a specific period

9.1.2 New Affiliate

  • This card shows the Top 5 Affiliate accounts which have been created most recently and also their time of registration.

9.1.3 Bestsellers Affiliate

  • This card shows the top 5 best-seller products by Affiliate links. Click to View Details to see more best sellers

9.1.4 Affiliate Transaction

  • This card records all the affiliate transactions with three statuses: On Hold, Completed, Cancelled. It will be shown in Pie chart for better visualization.

9.2 Affiliate Reports​

From the Admin Panel, go to Reports > Affiliate Reports

9.2.1 Best sellers

This field allows showing the information for best seller products including: name, SKU, price, number of product sold. Admin not only can filter the products by Magento default but they also can filter by store data, by date with an ease.

9.2.2 Accounts

This field enables showing the information of Affiliate account such as the date receiving the commission, email, number of orders from affiliate link, total cart of order, commission amount. Beside filtering by some available filter options of Magento, admin also can filter by store, day, week, month and year easily.

9.2.3 Sales

In this field, admin can view the sales and the commission of related Affiliate accounts by date. This module beside allows filtering by some available filter options of Magento, admin also can filter by store, day, week, month and year easily.

10. API​

  • Affiliate Ultimate does support API. The API allows users to get a list with all their offers in the selected format (JSON) with the payout showcased in the selected currency. The list can be filtered by status (pending, approved, or cancel), order, account affiliate, transaction, withdraw and campaign; add new account affiliate, withdraw; delete account affiliate, campaign.

  • Moreover, it can be customized to return only the selected fields (transaction, campaign, withdraw, account affiliate, change status of account affiliate, campaign)

  • You can see some syntaxes that we list below:

  • You can see some syntaxes that we list here. Also, please refer the guide on how to create API right here and creating token-based authentication here.

11. Import/Export​

When admins want to change their Magento store system, for backup data purpose, we add the Import/Export function for all the data of Account Affiliate and Transaction of Affiliate.

11.1 Import/Export Affiliate Account​

  • Import

From the Admin Panel, go to Sytem > Data Tranfer > Import

Step 1: Choose Entity Type = Mageplaza Affiliate Account

Step 2: Select Import behavior: You can Add/Update or Delete account

Step 3: Upload the import file from your computer. If you do not know what the file format is and which data to insert, please click to Download Sample File to see the example.

Step 4: Check and import data

  • Export

From the Admin Panel, go to Marketing> Affiliate > Manage Accounts

  • Click Export and choose the file format to download the data. Also, you can use this file to import to other system.

  • Note: When import file to other system, please check the header to make sure it is compatible with that system.

11.2 Import/Export Affiliate Transaction​

  • Import

From the Admin Panel, go to Sytem > Data Tranfer > Import

Step 1: Choose Entity Type = Mageplaza Affiliate Transaction

Step 2: Select Import behavior: Add transaction

Step 3: Upload the import file from your computer. If you do not know what the file format is and which data to insert, please click to Download Sample File to see the example.

Step 4: Check and import data

  • Export

From the Admin Panel, go to Marketing> Affiliate > Transactions

  • Click Export and choose the file format to download the data. Also, you can use this file to import to other system.

  • Note: When import file to other system, please check the header to make sure it is compatible with that system. Also be noted that all the data imported to orther system are in log. Therefore, you can not add transaction such as adding commission and withdrawal into these files.

  • Below are headers that this module support to import/export data. In which, the header with * is required.

  • Affiliate Account

Note: If you do not insert the data in column, it will be set as NULL at the database. If you import the same email twice, the system will record the initial email and ID.

  • Transaction

Note: If you do not insert the date or time then the module will automatically get the date and time when you import the data. For the data imported with the actions as in the table above but shown at Transaction Grid, the Action Type = Admin