Hi,
We are having an odd situation we cannot explain or reproduce but it's giving us some headaches. We have at least 4 orders already reported, but I am guessing we have 15 orders in this situation.
We can see that in the order SQL table, there's a reference to the voucher code used and the amount discounted, but there are no orderlines with the discount, so the orderlines total sum don't add up with the order amount.
The SQL queries I used:
SELECT Count(*) FROM EcomOrders AS O
WHERE O.OrderVoucherCode = 'unfairadvantage' AND O.OrderComplete ='True' AND O.OrderDeleted = 'False'
returns: 124 records
SELECT count(*) FROM EcomOrderlines WHERE
OrderlineOrderID IN (
SELECT OrderID FROM EcomOrders AS O
WHERE O.OrderVoucherCode = 'unfairadvantage' AND O.OrderComplete ='True' AND O.OrderDeleted = 'False'
)
AND OrderlineType = '1'
returns: 119 records for "Unfair Advantage"
I looked at the log on two orders at random, and there was nothing weird about it, looked like a perfect order workflow. Imar suggested it might have something to do with some locking tables at a given time, probably between the discount engine deleting all discount orderlines and trying to re-set the orderlines again, but we are not sure.
Can someone take a look at that or provide more information?
Best Regards,
Nuno Aguiar