Product cost / profit in order excel report

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!

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.

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...

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(...