Thread: Remove Order

Does anyone have a stored procedure or good / safe way to delete specific orders (say by date range or simply order number). if not, I am interested in the tables that I need to remove the entries from and maybe their key association.

But optimally a stored procedure or a process already in place would be the best.

Thank you in advance.

Generally in any ERP/Accounting/E-Commerce software applications, deleting of orders is never good practice. At most, you should be archiving these off if you need to clean them up, and then only after verification that all data has been archived (usually in an off-site database or database backup somewhere) should any orders actually be removed from the live site. We do have a knowledgebase article on clearing old orders out, but again this should only be done if you are deleting test data, or after a full database backup and preferably archival of existing orders that you'll be deleting, because once they are gone...they're gone for good

We had several (like 30) test orders that where created before we did the DNS change and would like to remove or hide those orders...any suggestions.

NVM looks like the article that you provided addresses this need.