bobismyuncle73 Posted June 21, 2016 Share Posted June 21, 2016 We use CubeCart to allow for online registrations for some in person workshops we run. We don't need to hold on to the records of orders and customers afterwards, but when I've tried to delete an order in the past, it always sends a message to the person who made the order, saying their order was cancelled. Some of our orders are stuck in processing for periods of time after the workshop has already happened, because it sometimes takes weeks/2 months for the finance sections for some government workshop attendees to pay us. I can't mark the order as 'complete' before then, because we haven't technically been paid until that point. What happens then, is a person may get an order complete e-mail 1-2 months after they've already attended the workshop. Is there a way for me to delete the orders (that are long since completed) without an e-mail being sent to the customer? Thanks so much ! Quote Link to comment Share on other sites More sharing options...
ayz1 Posted June 21, 2016 Share Posted June 21, 2016 If you have access to the database tables you can delete them from there. Normally access is gained via cPanel and phpMyAdmin. Alternatively you could just change the customer email address to something else (maybe an email address you have) and then delete the orders. Quote Link to comment Share on other sites More sharing options...
bsmither Posted June 21, 2016 Share Posted June 21, 2016 In admin, "deleting" an order (not the same as "cancelling"), assuming the logged in Admin has the permission to do so, calls the deleteOrder() function in the file /classes/order.class.php. The deleteOrder() function simply removes the order from the CubeCart_order_summary table (also, does not decrement the order count against the customer, but that aspect may be dealt with elsewhere). Then, regardless of the outcome of deleting that record, related records concerning the order's inventory, digital file downloads, taxes, notes, and history are deleted. At no point does deleting an order trigger an email -- as opposed to "Cancelling" an order. Quote Link to comment Share on other sites More sharing options...
keat Posted June 22, 2016 Share Posted June 22, 2016 Wouldnt a query from the maintenace section do this ? Quote Link to comment Share on other sites More sharing options...
bsmither Posted June 22, 2016 Share Posted June 22, 2016 One could mimic what CubeCart does when one clicks the delete icon for an order listed in admin, Orders. I prefer having CubeCart do it rather than issue a series of DELETE queries against six or seven separate tables. Again, I find no evidence that CubeCart sends any email when an admin deletes an order by clicking the delete icon in the Orders List. Quote Link to comment Share on other sites More sharing options...
bobismyuncle73 Posted June 22, 2016 Author Share Posted June 22, 2016 Very helpful responses. Thank you. I thought I'd have to make a selection under both the order status and action sections. This addresses my issue perfectly ! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.