Search Descriptions Version
 
 
This article applies to: ML8, MultiStore

Clearing Test Orders From The Database


Site admins often want to remove test orders from the DB before going live. Rows will need to be removed from 4 tables to completely remove the 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.

1. Go to Configuration → Advanced → Run SQL.

2. Type the following commands and click Submit. Make sure to replace 'lastordernumbertokeep' with the number you want to use.

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

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.