Do you have real carts you want to keep? if not, a truncate on the table (assuming you're using serialzable carts) should be enough

other than that, if you don't keep the carts forever, they will be automatically deleted after 30 days with the remove expired carts scheduled job

otherwise, you can do a query to join with cls_Contact table (customerid should match with contactid if it is a registered account). you then can have a list of carts without registered accounts.

of course, those deletions should be done with cautions and back up should be performed 

Yes, of course we have real cards we want to keep : D (we run these tests against PROD as well). 

I am talking about Playwright tests, there is no access to the database, only the API. 

As I've mentioned, it is tested with guest users, and the test is completed before the purchase, so no contact ids. 

Some ideas

• Load the carts using IOrderSearchService (by batch)
• For each card, try to load the contact using CustomerContext.Current.GetContactById(cart.CustomerId);
• if it is null, then you know there is no contact associated, you can decide if you want to keep it or delete it.

it will be a slow process however. you can leave it to the Remove Expired Carts to eventually clear the carts (those carts would have fairly small, if any, performance impact, I'd not worry about them, unless if you have tens of millions)