clean up all the order related data when conducting an order delete action with ets_ordermanager module
/modules/ets_ordermanager/ets_ordermanager.php
before 7603 line
// start - edited by Jimmy @14OCT2022-- clean up all the order related data
// these lines are for cleaning up the POS module and order payment transaction database
Db::getInstance()->execute('DELETE FROM `'._DB_PREFIX_.'order_payment` where order_reference LIKE \'%' .$order->reference . '%\'');
Db::getInstance()->execute('DELETE FROM `'._DB_PREFIX_.'pos_cart` where order_reference LIKE \'%' .$order->reference . '%\'');
Db::getInstance()->execute('DELETE FROM `'._DB_PREFIX_.'pos_sales_commission` where order_reference LIKE \'%' .$order->reference . '%\'');
// these lines are for cleaning up other order related databases
Db::getInstance()->execute('DELETE FROM `'._DB_PREFIX_.'message` where id_order='.$order->id);
Db::getInstance()->execute('DELETE FROM `'._DB_PREFIX_.'order_history` where id_order='.$order->id);
Db::getInstance()->execute('DELETE FROM `'._DB_PREFIX_.'order_cart_rule` where id_order='.$order->id);
Db::getInstance()->execute('DELETE FROM `'._DB_PREFIX_.'order_return` where id_order='.$order->id);
// end - edited by Jimmy @14OCT2022-- clean up all the order related data