3.1.1. Mass Product Changer
Mass product changer allows to provide data changes of selected multiple products in a bulk. Just choose necessary items in Store Manager and press the appropriate button from the top menu.
In the form that will appear you can choose fields you want to change or update. Let’s assume, you want to change description for all these products, so in the description field enter necessary text about products (you can use for editing the HTML editor) and do not forget to check this field to update.
If you want to apply special formula to modify the data in some fields, you must click on the button which launches the Expression Editor.
Specify expression you need (to facilitate the procedure, you can use the guide integrated in Store Manager help center - press the [Help] button).
To configure increase of product price by 15 %, you should enter the following formula:
Use the [Insert...] option to use the necessary field value from your database.
Press the [Next] button if formula is correct.
Then click the button on the top of the "Expression Editor" form to check its correctness:
The result of formula displays in the field "Last Execution Result" at the bottom of the window.
Press [OK] to proceed and don't forget to check the appropriate field to update.
Before exiting from this option and moving to the "Product" page of Store Manager, you can view bulk changes of product properties that you have already done by pressing the [Preview Result] button.
The "Custom Fields" tab is represented with the following options:
[Add Custom Field to Product] - contains the drop-down list with the fields which can be displayed as a customized (additional) information on the product's page:
Each selected variant has its own type and value. Select the ones you need to add by using the option for expanding. Adjust the data by using the drop-down lists of possible variants in the relevant columns of the table.
[Delete Selected] positions - unassign custom fields that were selected in the current form.
Copy/Paste options allows making the duplicates of the existing customization in the clicks.
The "Delete Existing Custom Fields" checkbox helps to overwrite the existing custom fields to the new ones, chosen in the current form. Once the updating is completed (the Mass Product Changer have finished the operation), the previous customization will be deleted.
If you click the [OK] button, all massive changes will be reflected on the Product Page.
Check the following article for more information:
Accomplish VirtueMart Products Update in Bulk with Product Changer