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.

Column headings filter tool

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

Product MultiEditor

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.

Set fixed price value

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
Reduce price formula

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
Special price formula

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 formula button

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 options

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.

File with price value

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:

Link price fields

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

Product identifiers list

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 a file to the store database or the existing price values will be updated to the new ones as well.