Revindex Storefront

How to delete all orders

Last updated on 2021-04-12 1 mins. to read

For your security, we currently do not support deleting orders. Instead, we suggest you cancel the orders. 

If you have only been testing and need to delete all orders before starting production, you can try to execute these SQL queries. Please make sure to take a full backup, run the queries and test your system afterwards. 

We don't support nor encourage deleting orders. Use at your own risk.

UPDATE Revindex_Storefront_SalesOrderDetail SET RecurringSalesOrderID = NULL
DELETE FROM Revindex_Storefront_RecurringSalesOrder
DELETE FROM Revindex_Storefront_VoucherHistory
DELETE FROM Revindex_Storefront_Voucher
DELETE FROM Revindex_Storefront_RewardsPointHistory
DELETE FROM Revindex_Storefront_SalesPayment
DELETE FROM Revindex_Storefront_SalesOrderDetail
DELETE FROM Revindex_Storefront_SalesOrder


Powered by Revindex Wiki