Profit calculation doesn't take into account of previous batch after cost rise

Take into account the following info of a product

Product Name : ABC
Product Cost : $30
Selling Price : $40
Stock Quantity : 2

Since, the stock is low, I perform a re-stock of 10 units. However the cost of the product for this batch has gone up by $2 and assuming that I don't raise my selling price and am able to live with a reduced profit margin. The following data is updated into nopCommerce (Catalog -> Products -> Manager Products -> Edit the product in question -> Product Info tab)

Product Name : ABC
Product Cost : $32
Selling Price : $40
Stock Quantity : 12

Now assuming that I've sold 6 units of this product (2 from the previous batch & 4 from the current batch - assuming the system clears off products from previous batch first), the profit calculation of nopCommerce is given as

($40 * 6) - ($32 * 6) = $48

The actual profit that I'm getting is

[($40 * 2) - ($30 * 2)] + [($40 * 4) - ($32 * 4)] = $52

Shouldn't nopCommerce take into account scenario like this to produce a more accurate account of the profit obtained?

Profit is calculated for the orders that meet the search criteria  (i.e. the orders showing in the results grid - all pages)

When the order is placed, the orderItem's OriginalProductCost field is set.  The orderItem.OriginalProductCost is used in the profit calculation, so it should reflect the actual profit based on the margin at the time the order was placed.

Profit is calculated for the orders that meet the search criteria  (i.e. the orders showing in the results grid - all pages)

When the order is placed, the orderItem's OriginalProductCost field is set.  The orderItem.OriginalProductCost is used in the profit calculation, so it should reflect the actual profit based on the margin at the time the order was placed.

I understand what you're saying but I think you've misunderstood me. I implore you to read my question again, this time in between the lines. After the re-stocking of the 2nd batch, the cost has since been changed. Every order placed after the re-stocking will set the orderItem.OriginalProductCost at $32 which is incorrect. The first 2 orders (assuming each order consist of 1 unit in quantity) should take $30 as the orderItem.OriginalProductCost instead since there are 2 units leftover from the previous batch. The 3rd order onward can use $32 as the orderItem.OriginalProductCost since the previous batch has been cleared.

When you drill down the problem, the question at its most rudimentary level is: which order(s) (assuming there are 6 orders) take(s) $30 as the cost and which order(s) take(s) $32 as the cost?

Following your example of 2 @ $30 + 10 @ $32 your cost for the remaining 12 units should be averaged (($60+$320)/12)=$31.67) and so at the end your profit will be calculated properly

What you want,would require  that Nop keeps a track of all inventory/cost changes. This belongs to ERP systems that are more appropriate for functions such as costing, profit calculations, inventory management, etc. So lets focus Nop development in the e-commerce functions.

Right.
Otherwise work on average costs as shown in my example above. This method is very much used in cost accounting unless you want to use more elaborated methods such as LIFO/FIFO which require to keep track of all your cost history. Imagine, as an example that you have a return of 5 unit which you originally acquired @ $25 apiece

This belongs to ERP systems that are more appropriate for functions such as costing, profit calculations, inventory management, etc. So lets focus Nop development in the e-commerce functions.