Import/Export cookbook: How to import products to Magento 2 with VAT price included and deduct the VAT automatically to display regular price
When you import products to your Magento 2 store, often the ‘Price’ column from the file already includes VAT. However, if you want to sell products for their real price, how do you import such products?
Do you edit the imported table manually before the import? Ask your supplier to send you prices without VAT?
However, you sometimes cannot get prices without VAT. Your supplier sends you the file from their warehouse, and cannot control how the prices are printed. Or the ERP system sends a json file, which is hard to edit.
You can do it, specify VAT and have it deducted automatically with the Improved Import & Export extension for Magento 2. Below, I will tell you how to do it, in a few steps.