[Skip to main content](#vessel-content) # Different VAT import? How to? ## - **[joombiz](/forum/user/34736-joombiz "View joombiz's Profile")** - [![joombiz's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34736.jpg)](/forum/user/34736-joombiz "View joombiz's Profile") Topic Author - [ Offline](/forum/user/34736-joombiz) Less More - Posts: 5 - Thank you received: 0 - - - - [](http://joombiz.eu) - 8 years 6 months ago [\#290817](#290817) by [joombiz](/forum/user/34736-joombiz "View joombiz's Profile") *[Different VAT import? How to?](/forum/37-import-export-csv-xls/894350-different-vat-import-how-to#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.")* was created by *[joombiz](/forum/user/34736-joombiz "View joombiz's Profile")* -- 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 ![;-)](/media/kunena/emoticons/14.png ";-)") In attachment a sample of the listing as we receive it with the 6% and 21% VAT. [ ![2018-04-04_17-40-10.jpg](/forum/attachment/43262) ](/forum/attachment/43262 "...4_17-40-10.jpg") - [ ![2018-04-04_17-40-10.jpg](/forum/attachment/43262) ](/forum/attachment/43262 "...4_17-40-10.jpg") [ ](/forum/attachment/43262?download=1 "...4_17-40-10.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTQzNTAtZGlmZmVyZW50LXZhdC1pbXBvcnQtaG93LXRvP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14267 - - 8 years 6 months ago [\#290826](#290826) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Different VAT import? How to?](/forum/37-import-export-csv-xls/894350-different-vat-import-how-to#290826 "-- 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. The following user(s) said Thank You: [joombiz](/forum/user/34736-joombiz "View joombiz's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTQzNTAtZGlmZmVyZW50LXZhdC1pbXBvcnQtaG93LXRvP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[joombiz](/forum/user/34736-joombiz "View joombiz's Profile")** - [![joombiz's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34736.jpg)](/forum/user/34736-joombiz "View joombiz's Profile") Topic Author - [ Offline](/forum/user/34736-joombiz) Less More - Posts: 5 - Thank you received: 0 - - - - [](http://joombiz.eu) - 8 years 6 months ago [\#290860](#290860) by [joombiz](/forum/user/34736-joombiz "View joombiz's Profile") Replied by *[joombiz](/forum/user/34736-joombiz "View joombiz's Profile")* on topic *[Different VAT import? How to?](/forum/37-import-export-csv-xls/894350-different-vat-import-how-to#290860 "-- 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.")* LOL True ![;-)](/media/kunena/emoticons/14.png ";-)") didn't think of that yet Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTQzNTAtZGlmZmVyZW50LXZhdC1pbXBvcnQtaG93LXRvP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.151 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)