Jump to content

How to clear Transaction Log?


Recommended Posts

I have several orders in my "transaction log" that are all related to print order forms, which I do not do at this time. These were just test orders I created. How can I get rid of these orders in the transaction log? The orders are NOT under my orders section, but the logs remain.



Link to comment
Share on other sites

This will delete the entirety of the transaction logs:


In admin, Maintenance, Rebuild tab, check the "Clear transaction logs" checkbox and click Submit.


To delete specific records in the transaction logs, you will need to use a database utility and manually delete the rows.


You may also suggest in the Github that Order->deleteOrder() include the deletion of relevant records from CubeCart_transactions.


Make this edit to delete the relevant records from the database (from this point forward):

Near line 179, find:
            // No checking required, because they would be useless without order_sum anyway
            $GLOBALS['db']->delete('CubeCart_order_inventory', $where);
            $GLOBALS['db']->delete('CubeCart_downloads', $where);
            $GLOBALS['db']->delete('CubeCart_order_tax', $where);
            $GLOBALS['db']->delete('CubeCart_order_notes', $where);
            $GLOBALS['db']->delete('CubeCart_order_history', $where);
Add after:
            $GLOBALS['db']->delete('CubeCart_transactions', array('order_id' => $order_id));
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...