Assuming you already have a way to send alerts to users and your problem is on server side, did you try any messaging mechanisms like RabbitMQ?
Workflow might look like:
- Product gets updated and that creates and sends a message to message queue
- Message consumer does the following
- receives message
- queries database for all subscribed users
- send alerts to users