Sales Creatio, team edition
PDF
This documentation is valid for Creatio version 7.12.0. We recommend using the newest version of Creatio documentation.

How to update product prices

To update multiple product prices, import data on the [Prices] detail of the [Prices and availability] tab on the product page. To do this, prepare the import file that contains the following columns:

Unique codes of products whose prices must be updated.

Currency.

New product prices.

Price list from which the prices originate.

If the same product is part of several price lists, each price list mush have a separate row in the imported file (Fig. 1).

Fig. 1 An example of Excel file ready for importing product prices

chapter_universal_import_prepare_file_prices.png 

To import data on the [Prices] detail:

1.Open the record of a random product in the [Products] section.

2.Click the btn_detail_menu00001.png button of the [Prices] detail and select the [Data import] action.

3.Click the [Select file] button and specify the prepared import file or drag the file directly to the Import Wizard page and click [Next].

4.On the next step, map all file columns to corresponding bpm’online columns. If the column names in the Excel file are identical to those in bpm’online, they will be mapped automatically. Click the [Next] button.

5.Select the duplicate search parameters: the “Product” (by a unique code) and “Price list” columns. Click the [Start data import] button.

Bpm’online will notify you when the import process is complete. You can view the results in the [Products] section and the detailed information about the import can be found in the [Excel import log] lookup.

See also

How to prepare a file

Video tutorials

Universal import from Excel to bpm’online

Did you find this information useful?

How can we improve it?