This article applies to:
ML8, MultiStore
After upgrading from v8 to v9, existing Zip Code Taxes are not showing in admin console
|
|
Symptoms
In the previous v8 admin console, existing Zip Code Taxes were showing in the Configuration -> Taxes -> Tax by Post Code and after upgrading to v9, they no longer show.
Cause
The upgrade script adds a new column: CountryID to the ZipTaxRate table with default value set to -1
Solution
Set the CountryID value to your United States ID (typically 1) using this sql query entered in the Configuration -> Advanced -> Run SQL window, and press Submit:
UPDATE ZipTaxRate
SET CountryID='1'
|