Product cost / profit in order excel report

1 month ago
Hi,

Is there a way to view a colum for the "product cost" and "Profit" when i generate an export of my orders in the "Sales" / "Orders" section in Excel.

I would like to know the product cost / profit for products by period.

I'm using Nop version 4.00 with multi-store.

I'm waiting for your answer...

Thank you!
1 month ago
Profit is not in the Export.  It only shows as a summary in footer of the Order List - e.g.
Summary
Profit $4,469.30
Shipping $0.00
Tax $0.00
Total $4,469.30


You can set the Start date / End date  criteria in the Search section at the top of the Order List page.

You would need to customize the Export if you want it there.
1 month ago
Hi,

Thanks for the answer.

Do you know in wich file in the code the export Excel is generated if I want to modify the code?

I'm waiting for your return...
1 month ago
The Export manager is here:
\Libraries\Nop.Services\ExportImport\ExportManager.cs
private byte[] ExportOrderToXlsxWithProducts(...

FYI, you can see how profit (summary) is calculated here:
\Libraries\Nop.Services\Orders\OrderReportService.cs
public virtual decimal ProfitReport(...