CSV product export, price including VAT

  • Posts: 15
  • Thank you received: 1
3 years 6 months ago #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 :)

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
3 years 6 months ago #332351

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

The following user(s) said Thank You: 48media

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

  • Posts: 15
  • Thank you received: 1
3 years 6 months ago #332396

Thanks. We will check if it helps us :)

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

Time to create page: 0.054 seconds
Powered by Kunena Forum