Different VAT import? How to?

-- HikaShop version -- : 3.3.0
-- Joomla version -- : 3.8.6
-- PHP version -- : 7.1.8

Hi,
We receive a CSV file from a manufacturer, stating the price including VAT and in another column the VAT %.
Importing the price is no issue, but i can't get the VAT % to work...
Any help is much appreciated.

The total listing is +1000 products, so changing them 1 by 1 would be hell
In attachment a sample of the listing as we receive it with the 6% and 21% VAT.

Hi,

In that "product_tax_id" column, you're supposed to enter the id of a tax category and not the percentage you want.
So one way you could cheat would be to change the ids of the tax categories in the database (via phpmyadmin in the hikashop_category table) to match with the percentage amount.

LOL True
didn't think of that yet