8. Magento Multi Editors








Multi Editor tool

The Multi Editor is one of the great time saving Store Manager for Magento features, available for use. It allows you to perform mass changes with:

    • Magento products (product prices, meta information, descriptions, etc.)
    • Magento inventory (product quantities, availability (in stock, out of stock), etc.)

Note: You can only make batch updates to products within one attribute set (e.i. Computers, Furniture etc.) at a time.

Multi Editor with sample attribute set

Product Multi Editor

1. Select the products that you wish to update. Choose the Magento Products Multi Editor, either on a toolbar, or within the pop-up context menu, which can be made available by clicking on the right mouse button:

Multi Editor button

2. In the opened Products Multi Editor window, select the Store View which which data should be updated.

Store View field

* For faster updates, use the Expressions feature.

Expression Editor in Multi Editor form

Example: Let’s assume we want to raise the price for the selected products by 10%.

3. Use the browse button to bring up the Expressions window.

4. Check the fields that are to be updated.

Check fields for updating

5. If more extensive changes to your data are needed, you may use an expression field, which can be summoned by clicking the ellipsis [...] button.

Expression button

In the opened window, click the right mouse button on a blank area, to summon a pop-up context menu.

6. Choose the 'Auto Complete Window', and select the Field value macro.

Auto Complete Window

As we wanted to rise the price for the selected products by 10% type *1.1 and click 'OK'.

Expression formula

*for example, to decrease the price for the three selected products by 10% please type: [FIELD_VALUE]*0.9

7. As you see Store Manager performed the operation in a second.

Product modified

The price has changed by 10%.

Note: Expressions are mathematical equations so they can be used only for numeric fields such as price, quantity etc. You should not use them for description, design etc.

Inventory Multi Editor

You can use Store Manager for Magento Inventory Multi Editor to change quantity, stock availability, minimum and maximum quantity allowed in shopping cart, minimum quantity for items’ status

to be out of stock and others:

Inventory Multi Editor

Magento inventory multi editor is similar to Product multi editor. Just select the products for mass update, choose Inventory editor (using toolbar or context menu).

Check the fields you want to update, do the updates and click OK.

Stock availability

The Store Manager Multi Editor facilitates making batch updates to multiple products and inventory in seconds.

Tier Price Multi Editor

From now you can modify/edit the tier price data massively by using the Multi Editor feature.


The Tier Price Multi Editor is available in Store Manager for Magento Professional and Enterprise Editions only!

If you use Store Manager for Magento Standard Edition and want to be able to operate with the tier price massively - recommend to upgrade your current Edition to Professional. Visit the page to get more information how to perform this.

To open the Multi Editor form use the top-toolbar or context menu:

1) in the Products page select the items for updating and choose from the upper Multi Editors’ actions list the appropriate command:

Tier Price Multi Editor in the top toolbar

2) highlight the items in the Products page and, by using the right-mouse clicking, call the context menu with the required option below:

Tier Price Multi Editor context menu

3) in the context menu you can see also a separate Tier Price position which contains necessary command as well:

Tier Price position in Context Menu

Use one of the following methods to launch the Tier Price Multi Editor.

The form which appears has two modes: advanced (only for Enterprise Edition) and simple (Enterprise and Professional Editions).

Please note, if you use Standard Edition of Store Manager for Magento you need to upgrade to Professional or Enterprise Edition to make this feature available.

Simple Mode of Tier Price MultiEditor

Has the following view:

Tier Price Simple Mode

Check the Quantity and Price Modifier checkboxes to specify the value to update.

    • ‘Modify quantity/price by’ checkbox - activate it to be able to indicate the required number of products / the price value.
Modify by...checkboxes
    • ‘Modify type’ - the value can be in numerical or percentage (only for price value!) parameter, depending on which checkbox is chosen:
Modify type checkbox
  • an option below helps to specify a fixed numeric value for all positions of price / quantity:
Set fixed value

Some of the data can be changed by using the hidden drop-down lists, i.e.:

    • Website column - use an arrow option to expand the possible variants. Choose a website, which the current changes will be reflected in:
Website column list

Take into account the column marked with an asterisk, which means it is mandatory.

Website is mandatory
    • All groups - select or deselect the checkbox and make the changes enabled/disabled for all customer groups of your store.
All Groups column

This column is closely related to the next column of the table - ‘Customer Group’.

Customer Group column
    • ‘Customer Group’- choose a specific group of the users to make the updates available within the selected position.

Some notes: if you leave it with ‘Not logged in’ status but the ‘All groups’ checkbox from the previous column is checked that is means the changes provided for such products will be available for all customer groups by default.

All Groups-Customer Group - Not Logged in status

If the status is ‘Not logged in’ and the checkbox ‘All groups’ ’is unchecked the tier price updates of the selected products will not be displayed in any of the groups.

Uncheck All Groups column
    • ‘Quantity/Price’ column - specify the rule at which the price offer will be available. A certain position in the column corresponds to the price and quantity values:
Quantity and Price column
    • ‘Action’ - choose an action you want to perform for the certain columns details’ :
Actions column list
    1. Skip command allows ignoring update on the current column’s data;
    2. Modify variant helps to update the tier price details indicated at this column;
    3. Delete removes tier price from the product, specified in the appropriate column.

Advanced Mode of Tier Price MultiEditor


Note, the Tier Price Multi Editor’s Advanced mode is available only in Enterprise Edition of Store Manager for Magento.

Launch the Editor to be able to see the required option.

1) use the top Products toolbar:

Tier Price Multi Editor in top toolbar

2) use the context menu:

Tier Price from Context menu

Such mode enables to use the expression formula(s) to customize the price data while updating.

In the upper side of the Multi Editor form you can see a special checkbox for switching between the modes.

Advanced mode checkbox

The Expression column will appear in the table of the data below.

Advanced mode Expression for Price

Navigate cursor to the column which need to insert the expression in:

Expression column for Price

The browse button - - opens the Expression Editor form where you can create and verify the extended formula before applying.

Please, make sure that the required positions of the products with the tier price offers have filled in the lower table fields:

Lower table

Specify the appropriate action for each column by using the drop-down list:

Actions column list
    • Skip action - the updates/changes in the data of the chosen position will be skipped;
    • Modify - the data, specified in a such column, will be applied to the appropriate product (the product’s tier price details will be updated);
    • Delete - the tier price of the product will be deleted.

Be sure you have done all modifications before the updating will be run.

'OK' button

The updates will be launched and you can see such progress bar:

Progress bar

The modification is completed now and can be previewed in the Products list of Store Manager.

Also, check the articles below, for additional useful information pertaining to the Multi-Editor Tool, and its available options:

Have an Easy Time Performing Bulk Updates with Multi-Editor Tool of Store Manager for Magento

Magento Multi Editor

In additional, consider the following video tutorials how to change (modify) different details in products in a bulk by using the Multi Editor tool of Store Manager:

If you need any additional assistance or help contact with our Support Department to get all necessary information. We will gladly assist you!

By eMagicOne Inc.