[Skip to main content](#vessel-content) # Price with VAT and without VAT ## - **[Ronon](/forum/user/16953-ronon "View Ronon's Profile")** - [![Ronon's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-04-25.jpg)](/forum/user/16953-ronon "View Ronon's Profile") Topic Author - [ Offline](/forum/user/16953-ronon) Less More - Posts: 107 - Thank you received: 1 - - - - 13 years 3 months ago [\#114086](#114086) by [Ronon](/forum/user/16953-ronon "View Ronon's Profile") *[Price with VAT and without VAT](/forum/2-general-talk-about-hikashop/85373-price-with-vat-and-without-vat#114086 "Hi, when I import the products in HikaShop, I have a field called "price_value_with_tax" which includes the total price including VAT and another called "price_value" which includes the price without...")* was created by *[Ronon](/forum/user/16953-ronon "View Ronon's Profile")* Hi, when I import the products in HikaShop, I have a field called "price_value_with_tax" which includes the total price including VAT and another called "price_value" which includes the price without VAT. Apparently it does not matter either because no error, but in the list of products is only stored the price with VAT, so I'm not sure that I'm calculating either the final price when you place an order. I attached two images in a CSV file you can see where all products are priced with VAT and price without VAT. And in the other picture you can see a random product, which only shows the price with VAT in both fields. Thank you. - [ ![Sin_ttulo-6.jpg](/forum/attachment/11141) ](/forum/attachment/11141 "Sin_ttulo-6.jpg") [ ](/forum/attachment/11141?download=1 "Sin_ttulo-6.jpg") - [ ![Sin_ttulo-8.jpg](/forum/attachment/11142) ](/forum/attachment/11142 "Sin_ttulo-8.jpg") [ ](/forum/attachment/11142?download=1 "Sin_ttulo-8.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1MzczLXByaWNlLXdpdGgtdmF0LWFuZC13aXRob3V0LXZhdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 13 years 3 months ago [\#114113](#114113) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Price with VAT and without VAT](/forum/2-general-talk-about-hikashop/85373-price-with-vat-and-without-vat#114113 "Hi, when I import the products in HikaShop, I have a field called "price_value_with_tax" which includes the total price including VAT and another called "price_value" which includes the price without...")* Hi, I tried to export my products, and I only have the **price\_value** column, so I think that you'll only need to use the **price\_value** column and then your price with tax will be automatically calculated regarding your **product tax category**. Hope this will help you a little. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1MzczLXByaWNlLXdpdGgtdmF0LWFuZC13aXRob3V0LXZhdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[Ronon](/forum/user/16953-ronon "View Ronon's Profile")** - [![Ronon's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-04-25.jpg)](/forum/user/16953-ronon "View Ronon's Profile") Topic Author - [ Offline](/forum/user/16953-ronon) Less More - Posts: 107 - Thank you received: 1 - - - - 13 years 3 months ago - 13 years 3 months ago [\#115703](#115703) by [Ronon](/forum/user/16953-ronon "View Ronon's Profile") Replied by *[Ronon](/forum/user/16953-ronon "View Ronon's Profile")* on topic *[Price with VAT and without VAT](/forum/2-general-talk-about-hikashop/85373-price-with-vat-and-without-vat#115703 "Hi, when I import the products in HikaShop, I have a field called "price_value_with_tax" which includes the total price including VAT and another called "price_value" which includes the price without...")* Hello, do not know why it did not calculate well the price without VAT goods. When I put the products, importing a CSV file, I have two fields: "price_value_with_tax", which is the price with VAT included, and "price_value", which is the price excluding VAT. The issue is, as I told you, that devices mess with the price displayed on "price_value_with_tax", ie VAT, because when you enter the page of a particular product, the "price_value_with_tax" and the field "price_value" carries the same value. I put in my shop the ability to purchase and send to destinations in other countries. In this case, the products would have to invoice without VAT, since I can not charge VAT in Spain to a customer in France, for example. In the case of orders I get from Spain, I have no problem because prices are VAT correctly applied, but when a customer is in another country, the system should be able to remove the VAT and leave the standard VAT rate. I guess this would be solved if the "price_value" good will store the value of the price without VAT, as it is in my CSV file. I do not understand why, if this file lists all prices include VAT and without VAT, then HikaShop only stored with VAT. I created several tax rules and tax several areas to determine when to apply or not taxes, but really only works with shipping costs. Could you help me? Thank you. Last edit: 13 years 3 months ago by [Ronon](/forum/user/16953-ronon "View Ronon's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1MzczLXByaWNlLXdpdGgtdmF0LWFuZC13aXRob3V0LXZhdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 3 months ago [\#115800](#115800) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Price with VAT and without VAT](/forum/2-general-talk-about-hikashop/85373-price-with-vat-and-without-vat#115800 "Hi, when I import the products in HikaShop, I have a field called "price_value_with_tax" which includes the total price including VAT and another called "price_value" which includes the price without...")* Hi Ronon, Actually there is no price with VAT stored in your database, this price is calculated on the base of your price with the tax rate added. So my question is: have you configured a tax category and a tax rate in Hikashop? Because it's this point which will define the price with VAT. What you should do then is to import the price without the vat and let the tax rate calculate the other price. Then just make sure this tax rate is applied only in Spain ![;)](/media/kunena/emoticons/24.png ";)") The following user(s) said Thank You: [Ronon](/forum/user/16953-ronon "View Ronon's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1MzczLXByaWNlLXdpdGgtdmF0LWFuZC13aXRob3V0LXZhdD90bXBsPW1hcmtkb3du) or [Create an account](/register) 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.069 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)