> ## Content Index
> Fetch the complete content index at: https://blog.tsd.digital/llms.txt
> Use this file to discover other available public pages before exploring further.

# How To: Bulk delete orders in uCommerce
- URL: https://blog.tsd.digital/how-to-bulk-delete-orders-in-ucommerce/
- Published: 2014-05-21T03:32:08.000Z
- Updated: 2014-05-21T03:32:08.000Z
- Author: Tim Gaunt
- Tags: e-commerce, Ucommerce, #Import 2025-04-01 05:38

Sometimes things go wrong in testing but you don't want to delete all orders so here's a little script that will help you quickly delete orders based on your own criteria. In this example I'm deleting orders from customers without a billing email address but you can change the select statement to anything you like.

DECLARE @OrderIds TABLE (OrderId int) INSERT INTO @OrderIds (OrderId) -- Change this to whatever select statement you need SELECT DISTINCT po.OrderId FROM uCommerce\_PurchaseOrder po LEFT JOIN uCommerce\_OrderAddress oa ON po.BillingAddressId = oa.OrderAddressId WHERE oa.EmailAddress = '' BEGIN TRAN UPDATE a SET ShipmentId = NULL FROM uCommerce\_OrderLine a WHERE OrderId IN (SELECT OrderId FROM @OrderIds) UPDATE uCommerce\_PurchaseOrder SET BillingAddressId = NULL WHERE OrderId IN (SELECT OrderId FROM @OrderIds) DELETE a FROM uCommerce\_Shipment a WHERE OrderId IN (SELECT OrderId FROM @OrderIds) DELETE a FROM uCommerce\_OrderAddress a WHERE OrderId IN (SELECT OrderId FROM @OrderIds) DELETE a FROM uCommerce\_OrderProperty a WHERE OrderId IN (SELECT OrderId FROM @OrderIds) DELETE a FROM uCommerce\_OrderLine a WHERE OrderId IN (SELECT OrderId FROM @OrderIds) DELETE pp FROM uCommerce\_PaymentProperty pp JOIN uCommerce\_Payment p ON pp.PaymentId = p.PaymentId WHERE p.OrderId IN (SELECT OrderId FROM @OrderIds) DELETE a FROM uCommerce\_Payment a WHERE OrderId IN (SELECT OrderId FROM @OrderIds) DELETE a FROM uCommerce\_OrderStatusAudit a WHERE OrderId IN (SELECT OrderId FROM @OrderIds) DELETE FROM uCommerce\_PurchaseOrder WHERE OrderId IN (SELECT OrderId FROM @OrderIds) --Uncomment this --COMMIT TRAN --And comment out this ROLLBACK TRAN