Developer forum

Anyone?

Hi Mario

We cannot reproduce. DW usually deletes the Order record when you delete the last orderline.

BR Nicolai

Hi Nicolai,

I came across this issue again. And although I cannot reproduce it consistently, I have +100 carts in that situation. Could somebody take a look and try to check the order logs and find a pattern?

So far all I noticed was that the orders has some more orderline like taxes (using Avalara) but some also had discounts. I picked them up like this

SELECT o.*
FROM EcomOrders o
WHERE
    o.orderID NOT IN (SELECT ol.orderlineorderid from EcomOrderLines ol where ol.OrderLineType IN (0,2) )
    AND
    o.OrderCart = 1
ORDER BY o.orderDate DESC

I will send the URL through email.

Best Regards,

Nuno Aguiar

Not as long as you have custom integration stuff on this. We will never be able to find the error....

Hi Nicolai,

Scott just told me about 8.9.1.10 and the fix to some stale orderlines, which could be the cause for this. We're going to upgrade and delete any problematic orders from the database (it's in dev so it's safe), so we can start fresh.

If we do run into the issue again I will let you know.

Thank you anyway.

Nuno Aguiar