Should we delete products when they sell out?

Not automatically. Products coming back into stock should stay live and show availability. Discontinued products with links or traffic can be redirected to the closest alternative or category. The right answer depends on the product, so we agree clear rules with you.