Flat Shipping Rate by City for WooCommerce SQL Injection Vulnerability

A time-based SQL injection vulnerability has been identified in the Flat Shipping Rate by City for WooCommerce plugin for WordPress, affecting all versions through 1.0.3. The vulnerability arises from inadequate escaping of user-supplied data in the 'cities' parameter, allowing authenticated attackers with Shop Manager-level access or higher to inject additional SQL queries. This exploitation could lead to unauthorized access to sensitive information in the database.

Impact

Exploitation of this vulnerability allows for time-based SQL injection, where an attacker can manipulate SQL queries to extract sensitive data from the database.

Reproduction

To reproduce this vulnerability, an authenticated user with Shop Manager-level access or higher can send a request that includes the 'cities' parameter. The injected SQL payload can then be used to extract information from the database, taking advantage of the time-based nature of the injection.

Remediation

No known patch is available for this vulnerability. It is recommended to review the vulnerability details and consider uninstalling the affected plugin.