Affiliate transactions are commission payments based on sales referrals completed through registered affiliate links. The OpenCart interface tracks all sales referrals, but payments are made only when an administrator uses the Administration interface to credit affiliates.  The following tutorial reviews both the report and affiliates interface for tracking affiliate sales and payment transactions in OpenCart 1.5.

Managing Affiliates Transactions in OpenCart 1.5

  1. Login as an Administrator into the Dashboard
  2. Hover over SALES in the menu bar, then click on AFFLIATES as it appears in the drop-down menu.  If you have registered affiliates, you will see an existing affiliates list as per the screenshot below.  However, if you have not created an affiliate yet, then you will need to add one by selecting INSERT.  For more details on adding Affiliates, see Adding Affiliates in OpenCart 1.5.opencart15-affiliates-main

    Only registered affiliates can have TRANSACTION records.  Click on the check box next to the affiliate whose transactions you wish to view, then click on EDIT at the far right hand side of the screen.
  3. When selecting a registered affiliate, you will see a screen similar to the following:


    The window opened by selecting EDIT for an affiliate allows you to edit or view GENERAL information on the affiliate, PAYMENT DETAILS for the affiliate, and TRANSACTIONS by the affiliate or administrator.  See Editing Affiliate Information in OpenCart 1.5 for further information.  Select the TRANSACTIONS tab.

  4. Affiliates will only have sales referral TRANSACTIONS if they have created a sale using their specific TRACKING CODE.  For more information about the TRACKING CODE for Affiliates, see How to Add Affiliates in OpenCart 1.5 or Editing Affiliate Information in OpenCart 1.5.  Transactions occur when a sale has been completed using their tracking code.  Transactions for affiliates are based on their commission rate and the sales they have created.  The TRANSACTION interface in the administrator will appear as per the screenshot below:

    Affiliate TRANSACTIONS include referral sales commissions and commission payments made by the Administrator. Note however that for every referral sale, the commission addition for the affiliate must be manually approved.  Here is an example of a sale where the commission option appears in an order:


    When the commission is approved, then the transaction will appear on the report.  Note that NO PAYMENT is made to the affiliate at this time.
  5. Making affiliate commission payments is accomplished by selecting ADD TRANSACTION, then  adding a description of the payment and then adding a value with a negative sign in front of the monetary amount.  Here is an example of how it would look in the TRANSACTION section of the affiliate:


    Note that in the screenshot above, the commission earned from Order ID:#21 has yet to be settled.  Therefore, there is a balance of $23.89 for the affiliate.  There was only a commission payment of $5.00 to the affiliate.

  6. Once you have completed any changes through this interface, you can select SAVE in the top right hand corner to save your entries.

The other way you can review Affiliates commissions is through the reports available in the Administration Dashboard.  Here's how to get to and use the AFFILIATES report:

  1. Login as an Administrator into the Dashboard
  2. Hover over REPORTS in the menu bar, and then click on AFFILIATES, then select COMMISSIONS.  You will see the following screen:


    You can filter this report by setting a start and end date to the report.  Note that one of the options on the report is at the far right where it allows you to select EDIT.  The EDIT function allows you jump back into the section of the Administrator Dashboard so that you can edit affiliate information.

  3. This report lists all of the transactions and the commissions earned by the affiliate per the date range you may or may not have set.  To set the date range, click in each blank and then select FILTER to narrow your results.   

Managing affiliates transactions means assessing their sales referrals and  the commissions paid to them in order to judge their impact upon your business.  Opencart 1.5 offers either the report or your Affiliates interface in the Administrator in order to manage this portion of your ecommerce store.  Keep close track of your affiliates and manage them carefully by setting appropriate commissions in order reward their efforts and you will have a healthier business as a result.

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Did you find this article helpful?


n/a Points
2015-09-22 10:33 pm

How can you clear the balance to zero when you have paid the affiliate his commision?

I cannot find it anywhere!

1,198 Points
2015-09-23 5:49 am
Hello Julius,

I do not see where you can reset it back to zero, even after searching through the forums there is no mention of doing that. I believe that is not possible due to keeping a history of the affiliate and payouts.

Best Regards,
TJ Edens
n/a Points
2016-03-15 1:26 am

in order to get the balance to Zero.

you will basically add the amount you want to deduct in negative.

for example you have $100 you have paid. 

enter -100 and click add transaction :)

n/a Points
2017-03-08 5:40 pm

Please, how can I delete all transaction history of the affiliate? I do not only want to set it back to 0 but I want to delete the history entirely.

17,314 Points
2017-03-09 4:26 pm
Hello Dave,

In general, if you find that the functionality does not exist within the default OpenCart interface, then you'll need to find an extension or speak with a programmer to create a custom function. In this case, there is an extension that you may want to check out. You can find more about it here.

I hope that helps! If you require further assistance, please let us know!

Arnel C.

Post a Comment

Email Address:
Phone Number:

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Need More Help?

Help Center Search

Current Customers

Email: Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.