Sign in
Bogert 1, 5612 LX, Eindhoven,
en
nl

External prices

The oneCORE platform is specifically developed for complex configurable products that typically require complicated setup and pricing structure. A powerful feature that simplifies this process is External prices. As the name suggests, this feature allows you to import pre-calculated prices from external files instead of defining them directly in product editions, enabling you to manage complex pricing and to seamlessly import prices from external ERP system.

With this feature, you can upload the prices based on Product Combinations which represent all possible combinations of product specifications. Each record of a product combination corresponds to one possible configuration of a product. For example, a complete configuration of a window blind may consist of four product combinations, meaning its final price is calculated as the sum of those four combinations.

bg-big

Permissions

To access/manage the Externla prices feature, users are required to have “ExternalPrices” role.


Import external prices

  1. Navigate to External prices feature under Products menu.
  2. Click “Add .CSV file(s)” to upload external prices. The maximum file size is 30MB. 
  3. After upload, you must “Push to cache” at the file to update the Product Combinations. The updated price can be seen on front-end 5 minutes after the action.

Note: multiple files can be uploaded at once. However, you can push to cache only one file at a time.


Replace file

If you wish to update every Product Combinations of the file, this can be done with "Replace file" function. The Product Combinations will be removed if the new file doesn't include the existing Product Combinations. Meanwhile, if the new file has new Product Combinations, they will also be uploaded. After the file is successfully replaced, you must “Push to cache” at the file to update the Product Combinations.

Replacing or editing specific Product Combinations right now is supported only via public API V2.


Conditions

If importing or replacing the Product Combinations which have the same combination key and combination value with the existing Product Combinations, system will replace the existing Product Combinations with new prices.


External price file

Each external price file (.csv file) contains Product Combinations which are sets of combination key, combination value and price. The recommended format is provided below. The combination key and combination value are case-sensitive.

Example:

- xxxxx-yyyyy-zzzzz is combination key.

- 11111-22222-33333 is combination value.

- 645 and 655 are price.

Single currency: xxxxx-yyyyy-zzzzz:11111-22222-33333,645

Multiple currencies: xxxxx-yyyyy-zzzzz:11111-22222-33333,EUR:645,USD:655

We support both single and multiple currencies in 1 file. For example,

- xxxxx-yyyyy-zzzzz:11111-22222-33333,645 (line 1)

- xxxxx-yyyyy-zzzzz:11111-22222-33333,EUR:645,USD:655 (line 2)

Note: once at least one currency is specified in Product Combination record, you should enter prices for all other currencies. Otherwise, system will consider that the Product Combination has price 0 in other unspecified currencies.