3.1.1. Mass Product Changer

fmDialogBulkChangeProdfmExpressionEditorMassChanger

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.

Mass product changer option

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.

Description field

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.

Use expression field

Specify expression you need (to facilitate the procedure, you can use the guide integrated in Store Manager help center - press the [Help] button).

SQL 'Help' button

To configure increase of product price by 15 %, you should enter the following formula:

Insert Database Field Value

Use the [Insert...] option to use the necessary field value from your database.

Press the [Next] button if formula is correct.

'Next' button in the Editor form

Then click the button on the top of the "Expression Editor" form to check its correctness:

Execute Expression field

The result of formula displays in the field "Last Execution Result" at the bottom of the window.

Last execution results

Press [OK] to proceed and don't forget to check the appropriate field to update.

Press 'OK' to exit

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.

Preview results option

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:

Add custom field to product list

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.

Correct data by using hidden listis
  • [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.

Copy/Paste options
  • 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.

Delete existing custom fields checkbox

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