15. Update Price Values for Multiple Items at Once

Multi Editor

Open Store Manager and select the items you need to update. Use the column headings filter tool to get the required data one-after-one.

Select all and press the [Multi Editor] button. This will open the form where you can find fields related to the price position.

Change the price value in the relevant field on the "Product details" and "Advanced Pricing" tabs.

To change the price to the fixed value, specify it in the corresponding fields. Do not forget to select the "Update" checkbox before launching the modification.

To update pricing on different values, use the Expression Editor tool .

For example, let's reduce the price value for items by 8% compared with the base price (100% - 8% = 92% or 0.92). Firstly, set the following formula for the Price value field:

[FIELD_VALUE]*0.92

In addition, you can set a special price for selected product positions. Let's assume, a special price should be 20% less than the basic price (t100%-20%=80% or 0.8). The following formula will help to archive the necessary result:

[ATTRIBUTE(price)]*0.8

The Multi Editor tool allows to set different price values with a formula. You can also test it in the Editor form, as it is shown on the illustration below:

Import Wizard

The Import Wizard helps to update an existing price values based on data from the import file. Link the price columns from a file with the corresponding fields of the store database.

Note: only the linked fields will be changed (modified) after importing!

For example, we have the file with the price values that need to be updated in the store.

After launching the import wizard, pass through all import steps. On the linking page, assign the columns related to the price parameter to the relevant fields from your store database:

Make sure you chosen the identifier for Store Manager to recognize the importing data.

Go through the rest of the import wizard steps and press the [Finish] button to complete import.

The new price parameters will be transferred from the file to the store database or the existing price values will be updated to the new ones as well.

In addition, check the following tutorials concerning the current theme:

Magento Price

Bulk Update Magento Products Applying Expressions in Multi Editors

What is Expression? How to Use It Performing Magento Import

Magento Multi Editor Tool