You can prefer CSV file upload for bulk price changes, you can do that by going into Bulk Actions and select the file type 'Update Price' and upload a CSV file with the following columns. You can also download a sample file from below.
Importing Selling Prices excluding tax (e.g Ex VAT)
By default, selling prices upload via CSV file is inclusive of tax. If you would like to import selling prices exclusive of tax (e.g Ex VAT), please follow the below steps.
- Open any Product and go to 'Prices' tab.
- Click the 'Bulk Update' link next to 'Selling Price (Ex Tax) and following the steps