Executive brief
A vulnerability exists in the SMS Alert plugin for WordPress, which is used by e-commerce sites to send order notifications and recovery messages. An attacker with administrative access could exploit this flaw to access sensitive information stored in the website's database. While the risk is mitigated by the requirement for high-level access, it could lead to data exposure if an administrator account is compromised.
Technical details
The vulnerability is a generic SQL Injection (CWE-89) located in the 'id' parameter across multiple components including SMSAlert-wc-order-sms.php and class-abandonedcart.php. The root cause is insufficient escaping of user-supplied input and a lack of proper SQL query preparation. An authenticated attacker with administrator-level privileges can append malicious SQL queries to existing ones to exfiltrate data. The issue affects all versions up to and including 3.9.7; a changeset (3623914) indicates a patch has been developed.
Affected products
- CozyVision SMS Alert – SMS & OTP for WooCommerce, Order Notifications & Abandoned Cart Recovery up to, and including, 3.9.7
Timeline
- 2026-07-28: advisory: Published by Wordfence and NVD
References
- https://plugins.trac.wordpress.org/browser/sms-alert/tags/3.9.7/SMSAlert-wc-order-sms.php
- https://plugins.trac.wordpress.org/browser/sms-alert/tags/3.9.7/SMSAlert-wc-order-sms.php
- https://plugins.trac.wordpress.org/browser/sms-alert/tags/3.9.7/helper/class-abandonedcart.php
- https://plugins.trac.wordpress.org/browser/sms-alert/tags/3.9.7/template/sms_campaign.php
- https://plugins.trac.wordpress.org/changeset?reponame=&old=3623914%40sms-alert&new=3623914%40sms-alert
- https://www.wordfence.com/threat-intel/vulnerabilities/id/b8440c1d-2a02-42b4-8fc5-42e5a107c0af?source=cve