[Resolved] Unsettled Orders

[tomcoleman]

I have over 127 pages of Unsettled Orders how do I just delete the ones from say 2013-2015?

[keat]

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.

[bsmither]

Deleting an order also manages the proper deletion of associated database records.

Instead of deleting them, perhaps updating their status to Completed.

[Dirty Butter]

Completed would subtract from stock, wouldn't it?

[bsmither]

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.

[Dirty Butter]

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.

[tomcoleman]

Cheers I just arranged by pending checked all on every page and changed to cancelled + delete.

Took about 45mins