Summary
CVE-2026-78472 is an unauthenticated SQL Injection vulnerability in the Ni WooCommerce Sales Report WordPress plugin. The plugin fails to sanitize and escape the sort parameter before using it in a SQL query, allowing remote, unauthenticated attackers to inject arbitrary SQL commands. The flaw affects all plugin versions prior to 4.2.0 and carries a High CVSS v3.1 score of 8.6.
Technical details
- Root cause: The plugin does not sanitize or escape a user-supplied
sortparameter before concatenating it into a SQL statement used by one of its reporting features. - Trigger conditions: No authentication or special privileges are required; an attacker only needs network access to a WordPress site running the vulnerable plugin.
- Attack vector: Network-based (AV:N), low attack complexity (AC:L), no privileges required (PR:N), no user interaction (UI:N).
- Impact: Successful exploitation allows an attacker to manipulate backend SQL queries, potentially extracting sensitive data (WooCommerce order/customer records, credentials, or other database contents). The CVSS vector indicates a scope change (S:C) with high confidentiality impact and no direct integrity or availability impact.
Affected software
- Ni WooCommerce Sales Report WordPress plugin — all versions prior to 4.2.0
Severity
- CVSS v3.1 Base Score: 8.6 (High)
- Vector:
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:N/A:N - CWE-89: Improper Neutralization of Special Elements used in an SQL Command (SQL Injection)
Mitigation and recommended actions
- Immediate: Upgrade the Ni WooCommerce Sales Report plugin to version 4.2.0 or later, which sanitizes and escapes the affected parameter.
- If patching is not immediately possible:
- Restrict or disable access to the vulnerable plugin’s reporting functionality until the update can be applied.
- Consider deactivating the plugin entirely if it is not business-critical.
- Deploy a web application firewall (WAF) rule to detect and block SQL injection patterns targeting the plugin’s
sortparameter as an interim measure. - Monitor web server and database logs for anomalous query patterns indicative of injection attempts.

