How to fix missing WooCommerce sales tax due to extended ZIP codes

When using WooCommerce to manage sales tax, it’s important to ensure that ZIP code rules are configured to handle variations like extended ZIP codes (e.g., ZIP+4). A common issue occurs when taxes aren’t applied during checkout if the customer enters a ZIP+4 code that doesn’t exactly match a predefined entry.

Issue background

A WooCommerce site was failing to apply sales tax on certain orders. On investigation, the commonality was that these orders used extended ZIP+4 codes (e.g., 35466-3064) rather than the standard 5-digit ZIP (e.g., 35466).

Despite having tax rules defined in WooCommerce → Settings → Tax → Standard Rates, the site wasn’t applying them when ZIP+4 values were entered.

Diagnosis

WooCommerce requires exact matches in its tax rate ZIP code entries. If the table only includes 5-digit ZIPs like 35466, then a customer entering 35466-3064 won’t match, and no tax will be applied.

The site’s tax rate entries were visible in the admin panel, but were being managed externally, limiting the ability to edit them manually at scale.

Resolution steps

1. Confirmed the mismatch logic:
   Verified that WooCommerce does not interpret extended ZIPs unless they’re explicitly accounted for.
2. Updated ZIP codes with wildcards:
   ZIP entries were updated to use a wildcard (*) to catch any variation. For example, changing 35466 to 35466* ensures that 35466-3064 and any similar ZIP+4 format will be included.
3. Batch updates via script:
   Due to the volume of ZIP entries and WooCommerce’s lack of overwrite functionality for imported tax rules, a batch script was used to cleanly update ZIP codes without duplicating data.
4. Database verification:
   A direct query against the wp_woocommerce_tax_rate_locations table was used to ensure that no remaining ZIP entries lacked wildcards.

Final outcome

After wildcarding all ZIP code entries, WooCommerce tax rules were correctly applied even when customers entered ZIP+4 values. This fix ensures a consistent user experience and tax compliance regardless of how customers enter their ZIP codes.

If you’re facing similar tax issues in WooCommerce, contact Freshy for expert help configuring and debugging your eCommerce setup.