joomla 1.5.26 VM 2.0.4
At revenue report the Revenue column total amount is incorrect .
1 ) The total sum is the add of the product(s) (product_final_price) of the order(s) . But in this sum the quantity of each sold product is not calculated .So if i have in my order item Y (x2) with price 100.The total sum at revenue must be 200 but instead is 100.
2)At order column the sum of the orders is not correct.
At administrator/components/com_virtuemart/models/report.php i made the modifications below
Replace the line below
$selectFields[] = 'SUM(product_final_price) as order_subtotal';
With this
$selectFields[] = 'SUM(product_subtotal_with_tax) as order_subtotal';
Also replace
$selectFields[] = 'COUNT(o.virtuemart_order_id) as count_order_id';
With this
$selectFields[] = 'COUNT(DISTINCT o.virtuemart_order_id) as count_order_id';
As is i said this bug is on vm 2.0.4 . Because i have not tested it yet on 2.0.6 can anyone confirms that this is fixed on 2.0.6 ?
Thank you
i have open a similar post days ago... it is not resolved in 2.0.6
virtuemat team please consider this for your next release.
added
the other bug is that the total amout does not substract the amout of the discounts coupon used by customers. Example : a customer orders for $100, he applies a discount coupon for $10 the total amount of the order is $90 without shipping fees. But in the report, the total revenue indicated is $100... the discount is not substracted from the gran total.