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.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
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
sazpurua wrote: ↑Wed Jan 17, 2018 8:45 amThanks 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
I was wondering what did you do for your problem?
I did developed an extension for this but not published it on the Marketplace. Send me a PM, if interested.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Did you find this?sazpurua wrote: ↑Wed Jan 17, 2018 8:45 amThanks 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
I can't seem to find it in opencart and that is pretty bad if you have no clue what the affiliates earn
Who is online
Users browsing this forum: No registered users and 420 guests
