[Skip to main content](#vessel-content)

#   Import CSV Tax handling

##

- **[comyoo](/forum/user/1145-comyoo "View comyoo's Profile")**
- [![comyoo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1145.png)](/forum/user/1145-comyoo "View comyoo's Profile") Topic Author
- [ Offline](/forum/user/1145-comyoo)

Less More

- Posts: 97
- Thank you received: 0
-
-

15 years 8 months ago [\#9957](#9957) by [comyoo](/forum/user/1145-comyoo "View comyoo's Profile")  *[Import CSV Tax handling](/forum/4-how-to/9957-import-csv-tax-handling#9957 "Hello,  I can import a csv file and I get no errors when import the csv. Either I want to let Hikashop calculate my ex vat price. In my csv the price&#95;value is by example 3,95.  I don't now what to fill in at the product&#95;tax&#95;id field. Is that 19 (from percent?) or Nederland19 (my tax name) I've tried everything and it will not select the tax categorie.  Can you help me out?  Thank you!  attachment: csv file  &#91;file&#93;")* was created by *[comyoo](/forum/user/1145-comyoo "View comyoo's Profile")*

Hello,

I can import a csv file and I get no errors when import the csv.
Either I want to let Hikashop calculate my ex vat price. In my csv the price_value is by example 3,95.

I don't now what to fill in at the product_tax_id field. Is that 19 (from percent?) or Nederland19 (my tax name)
I've tried everything and it will not select the tax categorie.

Can you help me out?

Thank you!

attachment: csv file

####  *This attachment is hidden for guests.
Please log in or register to see it.*

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzk5NTctaW1wb3J0LWNzdi10YXgtaGFuZGxpbmc/dG1wbD1tYXJrZG93bg==) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 8 months ago [\#9962](#9962) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import CSV Tax handling](/forum/4-how-to/9957-import-csv-tax-handling#9962 "Hello,  I can import a csv file and I get no errors when import the csv. Either I want to let Hikashop calculate my ex vat price. In my csv the price&#95;value is by example 3,95.  I don't now what to fill in at the product&#95;tax&#95;id field. Is that 19 (from percent?) or Nederland19 (my tax name) I've tried everything and it will not select the tax categorie.  Can you help me out?  Thank you!  attachment: csv file  &#91;file&#93;")*

You first need to set your tax rules via the menu System-&gt;Taxation. There, you will be able to create tax categories.
Then, you can just put in the column product_tax_id and the price with VAT will be calculated automatically from your price_value column based on the tax rules and the tax category.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzk5NTctaW1wb3J0LWNzdi10YXgtaGFuZGxpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[comyoo](/forum/user/1145-comyoo "View comyoo's Profile")**
- [![comyoo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1145.png)](/forum/user/1145-comyoo "View comyoo's Profile") Topic Author
- [ Offline](/forum/user/1145-comyoo)

Less More

- Posts: 97
- Thank you received: 0
-
-

15 years 8 months ago [\#9966](#9966) by [comyoo](/forum/user/1145-comyoo "View comyoo's Profile")  Replied by *[comyoo](/forum/user/1145-comyoo "View comyoo's Profile")* on topic *[Re: Import CSV Tax handling](/forum/4-how-to/9957-import-csv-tax-handling#9966 "Hello,  I can import a csv file and I get no errors when import the csv. Either I want to let Hikashop calculate my ex vat price. In my csv the price&#95;value is by example 3,95.  I don't now what to fill in at the product&#95;tax&#95;id field. Is that 19 (from percent?) or Nederland19 (my tax name) I've tried everything and it will not select the tax categorie.  Can you help me out?  Thank you!  attachment: csv file  &#91;file&#93;")*

Oke, thank you. I set the wrong ID number.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzk5NTctaW1wb3J0LWNzdi10YXgtaGFuZGxpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.052 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
