Auto Cancelled Order if past 3 days not in processed status
Can i do this by simple sql update with cronjob?
Why would you want do this?
Assuming you are referring to orders in the Open state? These are generally (when there is a payment processor) a problem with the processor communicating back to the cart. Hence you client has probably already paid and the Open status is there to indicate that you should do a check before manually moving the order.