Prices include tax bulk import

Hi there
version 3.9
I have set up a tax category of 20% and applied this to my bulk import of products on the excel sheet(approx 5000)
however when i imported the products i did not select "Prices include tax" under
/Admin/Setting/Tax section

if i now tick this box after the import it removes the tax thus reducing the price of the products.

does this mean i will have to re-import all the products to get the tax set up correct?


Thanks!


David

Hi there

Im really confused. Ive set the following

/Admin/Tax/Providers set to Manual (Fixed or By Country/State/Zip)
Created a product tax @ 20% in /Admin/Tax/Categories
Prices include tax  - Selected
Tax display type - Including tax

Ive imported a product with column AU :  TaxCategory
correctly filled in

if i view the product in admin it is set at price 21.6
if i view the product on the customer view it shows 18.00 m(even though display price inc tax is selected)

the site takes the imported price 21.60 and removes 20% !!

the price should display as 21.60 not 18.00

am i missing something with tax settings?