Prerequisites

• I understand and accept the project's code of conduct
• I have already searched in existing features request and found no previous suggestion of this feature.

Is your feature request related to a problem?

I installed ps_emailalerts, and I reviewed the alerts the customer subscribed to in the table ps_mailalert_customer_oos. Unfortunately, the time when a customer or visitor subscribed to a product alert is not saved. Therefore, the data is not useful for the merchant.
Also, when a customer is notified, then the notification is deleted. This does not allow the merchant to know if the module is efficient in notifying his customers.

Related to #28233 ps_emailalerts: As a merchant be informed about customers subscribing to product availability notifications.

Describe the solution you'd like

The table ps_mailalert_customer_oos must contain the date at which the user requested a notification. This is required to answer these questions, and any other question a merchant could ask about notifications for products out of stock:

• How long are my customers waiting for a product?
• What new notifications were requested last week?
• A product has many requests for notification. Are they old or recent?

The table also must support soft delete instead of hard delete. There are three reasons to delete a notification (customer notified, product deleted, by customer request (gdpr)). The date the notification was sent would also be interesting. I see two ways to solve this:

• field (datetime) date_deleted with (bool) notified
• field (bool) deleted with (datetime) date_notified

Alternatives you've considered

There is no alternative

Additional context

No response

Do you plan to work on this feature?

• I'm willing to contribute a formal specification.
• I'm willing to provide any wireframes or design assets required for this feature.
• I'm willing to submit a Pull Request that implements this feature.
• I'm willing to help verify that the implemented feature works as intended and produces no unintended side effects.