You'll need to create a redirect from the old URL to the new one ( you can use Easy Redirect app:

https://apps.shopify.com/easyredirects)

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/6f572205-90df-488b-841b-39a4540349be/Screenshot_2020-07-29_at_10.45.37.png

  1. Afterward update the inventory once notifications are sent out make the product unavailable.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/0306a242-a41c-4434-b3c7-c4fc1aca7c8b/Screenshot_2020-07-29_at_10.58.23.png

  1. Check notifications are sent

https://s3.us-west-2.amazonaws.com/secure.notion-static.com/6779f96b-953c-46a0-82f7-13fb0675dcc1/Screenshot_2020-03-18_at_15.31.51.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAT73L2G45O3KS52Y5%2F20200729%2Fus-west-2%2Fs3%2Faws4_request&X-Amz-Date=20200729T100139Z&X-Amz-Expires=86400&X-Amz-Signature=6a0b14cd31b93d72e12782c4abc8d7323c151b8e0aab316add8aa7eb8facd157&X-Amz-SignedHeaders=host&response-content-disposition=filename %3D"Screenshot_2020-03-18_at_15.31.51.png"

  1. Shopify only allows redirecting on products that are inactive URLs (404). remember it will not work if the product is available, so make it unavailable on the store.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/85512219-45c2-404a-8326-c202295386a8/Screenshot_2020-07-29_at_10.35.26.png

So once the customer receives the email that the product is in-stock they click on it they will be redirected to the new product.