< Back
Print

Convert value ranges into each other

Introduction

This plugin converts one valuerange into another. For example: Converting created and maintained currencies into the according currency of a shopsystem. To do so, simply choose both valueranges and map them to one another.
The created mapping takes the source external key from the source value range and lets you append target values from the target value range.
 

Configuration

You need to select a source and a target value range. After both value ranges are selected the options for mapping appears. All the settings will be explained in the following.

Screenshot of Convert Value Range Format Configuration
FieldExplanation
Source valuerange /
Alternatively: Use valuerange from a selection field
The source value range, whose values can then be selected as source values in the mapping.
Target valuerange /
Alternatively: Use valuerange from a selection field
The source value range, whose values will then be exported based of the external key of the source value range mapping
Value mappingA mapping where the source values can be selected from the source valuerange and the target value can be selected from the target valuerange
Send unmapped values emptyCheckbox, if true unmapped values will export an empty string, if false the input value will be returned

 

Example

For the demo we have the following value lists: One which contains custom states for product maintenance in the PIM and a value list that contains the states from a target shop system (e.g. Shopify)
We want to send the correct shopify status based on our PIM product status without creating a new value list.

Screenshot PIM states for example Screenshot shopify states for example

On our product, the PIM status is maintained, the export needs the shop status. Only “Online” and “Deleted” have a different state (target “ACTIVE” and “UNLISTED”), the other values are represented by the status “DRAFT”.

The configuration for the format plugin looks like this:

Screenshot of the example configuration of the format plugin

A product with the state “New Product” (unformatted value would be the external key: 0 ) will now be sent as “DRAFT”.

Was this article helpful?
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents