This is also occurring on my site. The import only imports the rates and then sets State code and Postcode/ ZIP as *, rendering the import useless.
con
(@conschneider)
Engineer
Howdy,
When running an import through Woocommerce it generating a * for Postal / Code and City, even when the column has content in it.
The CSV file for importing requires 10 columns;
country code, state code, postcodes, cities, rate, tax name, priority, compound, shipping, tax class
For reference: https://docs.woocommerce.com/document/setting-up-taxes-in-woocommerce/#section-14
Here is a sample CSV file: https://docs.woocommerce.com/wp-content/uploads/2013/02/us_tax_rates.csv
Does yours differ in any detail from our example CSV? Does it work if you just put in one row for testing?
Kind regards,
con
(@conschneider)
Engineer
We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.