tomcoleman Posted April 5, 2016 Share Posted April 5, 2016 I have over 127 pages of Unsettled Orders how do I just delete the ones from say 2013-2015? Quote Link to comment Share on other sites More sharing options...
keat Posted April 5, 2016 Share Posted April 5, 2016 I'm guessing that you'd have to do this using an SQL command either via PHPAdmin or via Query Database in the maintainace section. Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 5, 2016 Share Posted April 5, 2016 Deleting an order also manages the proper deletion of associated database records. Instead of deleting them, perhaps updating their status to Completed. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted April 5, 2016 Share Posted April 5, 2016 Completed would subtract from stock, wouldn't it? Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 5, 2016 Share Posted April 5, 2016 That is a choice in CC6. Reduce Stock Levels when the order is Complete. That would require, still, the admin to work through 127 pages of orders. (Show All would be impractical.) But using the same approach as using a database manager to effect a mass change, the solution is to change the status of the order. (And if not an external bulk change to Complete, then perhaps to Declined.) Going external to CubeCart means none of the associated actions will be executed: update stock according to Reduce Stock Level setting, emailing customers the order has been shipped, etc. There are consequences to doing anything, of course. For example, moving an order to complete if it has not, in fact, been shipped means shipping costs have been collected but not spent -- a relatively major accounting pickle. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted April 5, 2016 Share Posted April 5, 2016 My way around this was to change Pending to the Declined/Fraud choice (renamed to Unpaid Order), usually after 3 or 4 business days. I manually mark them as Unpaid and reworded the email about Declined to give one more chance to pay. Then, if nothing happens with the order I from time to time delete the Unpaid Order ones. Quote Link to comment Share on other sites More sharing options...
tomcoleman Posted April 6, 2016 Author Share Posted April 6, 2016 Cheers I just arranged by pending checked all on every page and changed to cancelled + delete. Took about 45mins 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.