Rather than deleting the membership, the order should be refunded as needed and the membership should be cancelled.