If your store doesn't use sideboxes, the only way for one of your customers to sign up for product notifications is to a purchase a product and request the notification on the checkout_success page. This plugin adds the notification linkage on the product_info pages. No SQL updates, no core-file overrides ... just three template-override files.
You can see it in action below (albeit customized!); it's the "Update Notification" link.
If I've helped you on the Zen Cart forums or you've found one of my free plugins helpful, feel free to give a little back by clicking here.