Change prices for multiple products

It is often the case that prices need to be changed for a large quantity of items. Depending on how these prices need to be changed, there are two different procedures: rule-based or customised.

Customised procedure

This procedure is recommended if, for example, you need to change prices due to changes in delivery prices from the supplier. In this case, it is often not possible to define a rule with which the articles are to be changed. Instead, you need to set prices at item level.

Rather than tackling each item individually, it is advisable to create an Excel file that contains the new prices for each item. In the simplest case, the file consists of two columns, the article ID / article number / EAN and the new sales price. However, it is also possible to change the prices on the basis of the article number or other unique fields or field combinations. you can then easily import the Excel file using the "Manage articles" function and the prices will be updated accordingly.

Please use the standard product format as the import file format. You can use the standard importer of the supplier-item link for your supplier's purchase prices.

Rule-based procedure

It is easier to change prices based on rules.

1. Go to Product management > Manage products in the customer area
2. Filter on the products you want to change
3. Click on Price change in the menu. A dialogue window appears in which you can change the prices flexibly.
   

The dialogue offers you the following field groups:

• Sales prices: this includes the standard price, alternative price groups and variant prices for configurable items. Of course, graduated prices are also automatically adjusted.
• List prices
• Offer prices. Standard price and alternative price groups are also included here.
• You can also have all supplier purchase prices adjusted by rule. Please note that this does not apply to warehouse purchase prices, as their value is calculated dynamically on the basis of goods receipts.

To adjust a price, you must enter the price change in per cent in the corresponding field. So enter 10 for a price change of +10%, -10 for a price change of -10%. Note that TYRIOS explicitly allows more than -100%, which could lead to negative prices (this may be desired depending on the use case).

The prices are updated in the background and may take a few minutes depending on the quantity of items concerned. You will receive an email to the email address stored in your profile once the update has been completed.