- Posts: 15
- Thank you received: 1
CSV product export, price including VAT
5 years 4 months ago #332350
by 48media
CSV product export, price including VAT was created by 48media
-- 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
-- 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.
5 years 4 months ago #332351
by nicolas
Replied by nicolas on topic CSV product export, price including VAT
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.
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.
5 years 4 months ago #332396
by 48media
Replied by 48media on topic CSV product export, price including VAT
Thanks. We will check if it helps us
Please Log in or Create an account to join the conversation.
Time to create page: 0.174 seconds