I just need someway to take canceled orders out of the dashboard reports, any ideas?
I agree that canceled orders should not be included in reports. I just had a look and noticed a couple of bug reports that mention the issue, why not comment on them to help flag up the issue:
That solution sounds good - but I do not want to mess with the database. Why no Delete button? One can delete customers, for example, but not newsletter subscribers or orders. What’s that all about?
Early in this thread Moshe replied back with a SQL statement:
select @order_id:=entity_id from sales_order_entity where increment_id=’100000001’;
delete from sales_order_entity where entity_id=@order_id or parent_id=@order_id;
Have any of you tried this? If you need help understanding what to do with this code just let me know!