Developer forum

Hi Martijn

There's no way to do this automatically.

A way to do it is to get a collection of orders from the database, find the ones you want to delete and then deleting them--the properties IsCart and Complete will be useful for this. This will be enough in your case because deleting an order will also delete all orderlines on that order.

Eg.:
public void DeleteOrphanedOrders()
{
    OrderCollection orders = new OrderCollection();
    orders.Load("SELECT * FROM EcomOrders"); // You might want to limit this query to more
                                                                                        // or less only contain the ones you want :-)
    foreach (var order in orders)
    {
        if (order.IsCart && !order.Complete)
            order.Delete(); // Deleting an order also deletes the associated orderlines
    }
}

I haven't tested this code, but it should work, or at least give you an idea as to what to do :-)

- Jeppe

Hi Jeppe

Thanx for your quick reply.

I will make my own function, based on the code you provided.
With a scedulded task I will run the function occasionally

Gr.
Martijn