Looking for the v10 manual? Visit our new user's guide!
 
Search Descriptions Version
 
 
This article applies to: ML v7, ML8, MultiStore

Clearing Old/Test Orders From The Database


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