15. Update Price Values for Multiple Items at Once

fmProductsfmEditProductMultiEditor

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.

Product Filter in Product Grid

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

Multi Editors & Changers Menu

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.

Update Product(s) Price

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

Expression to Reduce the Product(s) Price

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:

Execute Expression Button (F9)

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.

Import/Export Products Buttons

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.

Import .csv File

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:

Import Wizard

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

"Identify Product By" Section

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.