Update deletion to handle soft delete