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

#   CSV product export, price including VAT

##

- **[48media](/forum/user/32301-48media "View 48media's Profile")**
- [![48media's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32301-48media "View 48media's Profile") Topic Author
- [ Offline](/forum/user/32301-48media)

Less More

- Posts: 15
- Thank you received: 1
-
-

5 years 5 months ago [\#332350](#332350) by [48media](/forum/user/32301-48media "View 48media's Profile")  *[CSV product export, price including VAT](/forum/37-import-export-csv-xls/902526-csv-product-export-price-including-vat#332350 "-- HikaShop version -- : 4.4.1 -- Joomla version -- : 3.9.22 -- PHP version -- : 7,2 -- Browser(s) name and version -- : ff  Hello, Is it possible to export products with the price including VAT? Or how to import products based on prices including VAT?  We want to change the prices of the products, but the net prices in the CSV file look like this: 430.89431. And for the customer, the price with VAT is shown: 530.00. And calculations from net prices generate prices for example 530.01. And it doesn't look nice :)")* was created by *[48media](/forum/user/32301-48media "View 48media's Profile")*

-- HikaShop version -- : 4.4.1
-- Joomla version -- : 3.9.22
-- PHP version -- : 7,2
-- Browser(s) name and version -- : ff

Hello,
Is it possible to export products with the price including VAT?
Or how to import products based on prices including VAT?

We want to change the prices of the products, but the net prices in the CSV file look like this: 430.89431. And for the customer, the price with VAT is shown: 530.00. And calculations from net prices generate prices for example 530.01. And it doesn't look nice ![:)](/media/kunena/emoticons/8.png ":)")

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

Less More

- Posts: 86292
- Thank you received: 14269
-
-

5 years 5 months ago [\#332351](#332351) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[CSV product export, price including VAT](/forum/37-import-export-csv-xls/902526-csv-product-export-price-including-vat#332351 "-- HikaShop version -- : 4.4.1 -- Joomla version -- : 3.9.22 -- PHP version -- : 7,2 -- Browser(s) name and version -- : ff  Hello, Is it possible to export products with the price including VAT? Or how to import products based on prices including VAT?  We want to change the prices of the products, but the net prices in the CSV file look like this: 430.89431. And for the customer, the price with VAT is shown: 530.00. And calculations from net prices generate prices for example 530.01. And it doesn't look nice :)")*

Hi,

It's not possible to export products with the price including VAT.

However, it is possible to import products with prices including VAT. In your CSV file, instead of using the column name "price_value", you can use the column name "price_value_with_tax". Make sure you also include the product_tax_id column to specify the id of the tax category.
That way, during the import, HikaShop will calculate back the price without taxes based on your main tax zone (HikaShop configuration) and these two columns and the tax rules you've configured in System&gt;Taxes.

The following user(s) said Thank You: [48media](/forum/user/32301-48media "View 48media's Profile")

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

- **[48media](/forum/user/32301-48media "View 48media's Profile")**
- [![48media's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32301-48media "View 48media's Profile") Topic Author
- [ Offline](/forum/user/32301-48media)

Less More

- Posts: 15
- Thank you received: 1
-
-

5 years 5 months ago [\#332396](#332396) by [48media](/forum/user/32301-48media "View 48media's Profile")  Replied by *[48media](/forum/user/32301-48media "View 48media's Profile")* on topic *[CSV product export, price including VAT](/forum/37-import-export-csv-xls/902526-csv-product-export-price-including-vat#332396 "-- HikaShop version -- : 4.4.1 -- Joomla version -- : 3.9.22 -- PHP version -- : 7,2 -- Browser(s) name and version -- : ff  Hello, Is it possible to export products with the price including VAT? Or how to import products based on prices including VAT?  We want to change the prices of the products, but the net prices in the CSV file look like this: 430.89431. And for the customer, the price with VAT is shown: 530.00. And calculations from net prices generate prices for example 530.01. And it doesn't look nice :)")*

Thanks. We will check if it helps us ![:)](/media/kunena/emoticons/8.png ":)")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDI1MjYtY3N2LXByb2R1Y3QtZXhwb3J0LXByaWNlLWluY2x1ZGluZy12YXQ/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.154 seconds

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

[](#top)
