How to edit product VAT in Bulk using Ad-Lister

How to edit product VAT in Bulk using Ad-Lister

How to update your VAT in bulk using Ad-Lister

There are several ways to change the VAT of your products using Ad-Lister, and it all depends on the use case.

1. Change the VAT % for all of your products from the Store Default VAT field

If the VAT rate of all of the products that you are selling has changed in general, then you can quickly update the VAT% using the Default Store VAT in Ad-Lister.
The field can be found in Settings--> Ad-Lister settings 



2. Changing the VAT for a selection of products using the Ad-Lister interface


You can update the VAT% of your products in Bulk using the Bulk VAT editor. This is useful if the VAT% has changed only for a certain range of products.
In order to use the Bulk VAT editor follow these steps:
1. Go to the Products Page
2. Select the products for which you would like to change the VAT% for
3. Click on the Product Actions drop-down
4. Select Bulk Update VAT
5. Add the VAT value
6. Click on Apply




3. Update the VAT using a CSV file

You can download the products from Ad-lister into a CSV file:
1. Select the products that you would like to download
2. Select VAT on the CSV export page
3. Click on the Product Actions drop-down
4. Click on Download
5. Select VAT on the product download page
6. Click on export




Once you have opened the CSV file, you can then add the VAT values into the VAT column and upload the file back into Ad-Lister.

To upload the file, you will have to:
1. Go to Products--> Product upload
2. Select the file from your computer
3. Click on Continue 
4. Make sure that the Update existing inventory option is selected
5. Click on Update


Please note that after updating the VAT options in Ad-Lister you will have to revise your products on all of your platforms.



    • Related Articles

    • Bulk Update Shipping Options

      This feature is useful if you have decided to change the courier service that you have been using so far, or if you would like to add a new alternative shipping provider. To update/change shipping options in bulk you need to follow these steps: Go to ...

    • How to Bulk Update product quantity

      When is this feature useful? The Bulk updating Quantity function comes in useful when you have new stock that you need to add to your products.  How can you make the changes using the Ad-Lister interface? To change all of your product quantities, ...

    • How to manage the VAT % of your products in Ad-Lister

      Where VAT is displayed in Ad-Lister There are multiple places where you can change the VAT of your products in Ad-Lister, these different VAT fields work in a different hierarchy. 1. The VAT field in the Product Details - Top Level field The VAT ...

    • Bulk update prices

      When is this feature useful? Bulk updating prices is useful when you would like to have a promotional sale on your platforms or when you have to bulk increase the pricing due to a general price increase. How can you make the changes using the ...

    • Ad-Lister patch 1.8.4

      New Features deployed in patch 1.8.4 The Process Manager The Process Manager is located under Tools & Reports in the top menu, and was added to help you see all the various Jobs/Processes that are running on your Ad-Lister account. You can see what ...