Different VAT import? How to?

  • Posts: 5
  • Thank you received: 0
  • Hikashop Business
5 years 11 months ago #290817

-- 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.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
5 years 11 months ago #290826

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.

The following user(s) said Thank You: joombiz

Please Log in or Create an account to join the conversation.

  • Posts: 5
  • Thank you received: 0
  • Hikashop Business
5 years 11 months ago #290860

LOL True ;-)
didn't think of that yet

Please Log in or Create an account to join the conversation.

Time to create page: 0.068 seconds
Powered by Kunena Forum