Synopsis
Site admins often want to remove test orders from the DB before going live
Procedure
Rows will need to be removed from 4 tables to completely remove these test orders. The following SQL statements will clear those orders out. Make sure you have a good backup of your database before making changes to it!
NOTE: These statements assume that you want to remove ALL orders before "lastordernumbertokeep." If that is not the case, you may need to edit these statements.
DELETE FROM Orders WHERE OrderNumber < lastordernumbertokeep
DELETE FROM Orders_CustomCart WHERE OrderNumber < lastordernumbertokeep
DELETE FROM Orders_KitCart WHERE OrderNumber < lastordernumbertokeep
DELETE FROM Orders_ShoppingCart WHERE OrderNumber < lastordernumbertokeep