in v3.0.2.0 how can I find out all the commissions that have to be paid to the Affiliates?
The report is not in Modules...
There are two distinction on using the term all in this case. Either you are talking about all the commissions of each regrouped orders to find out all commissions or you are looking for all totals of each affiliates that needs to be owned within the reports. Assuming you are talking about the first one,in v3.0.2.0 how can I find out all the commissions that have to be paid to the Affiliates?
The report is not in Modules...
In your admin/model/extension/report/sale.php file, in the getOrders() method,
find:
Code: Select all
SUM(o.total) AS `total`
Code: Select all
, SUM(`o`.`commission`) AS `commission`
find:
Code: Select all
'products' => $result['products'],
Code: Select all
'commission' => $this->currency->format($result['commission'], $this->config->get('config_currency')),
add at the bottom of the file:
Code: Select all
$_['column_commission'] = 'Commission';
find:
Code: Select all
<td class="text-right">{{ column_products }}</td>
Code: Select all
<td class="text-right">{{ column_commission }}</td>
Code: Select all
<td class="text-right">{{ order.products }}</td>
Code: Select all
<td class="text-right">{{ order.commission }}</td>
Code: Select all
<td class="text-center" colspan="X">{{ text_no_results }}</td>
This should show you the total commissions of all related orders of the same products for each rows.
The most generated errors being found on Opencart forum originates from contributed programming.
Regards,
Straightlight
Thanks for your reply!straightlight wrote: ↑Sat Jan 13, 2018 10:46 pmThere are two distinction on using the term all in this case. Either you are talking about all the commissions of each regrouped orders to find out all commissions or you are looking for all totals of each affiliates that needs to be owned within the reports. Assuming you are talking about the first one,in v3.0.2.0 how can I find out all the commissions that have to be paid to the Affiliates?
The report is not in Modules...
Actually what I need is a report that shows me (for a given time period) the list of the affiliates that have earned commissions, and the amount owed to each of them.
However, the info you supply before is quite useful as well.
Thanks
Who is online
Users browsing this forum: No registered users and 9 guests