Normalize values

Bring different source values together into one fixed value.

Suppliers can supply the same product feature in different ways. This way you can link blue, light blue and navy blue to one fixed color group. Nifelo saves the original source value and uses the set group value or translation during export.

The imported source value is retained.
Same meaning, different spellings

Create a usable, fixed classification from various source values

With normalization you link different values ​​with the same meaning to one fixed group. This allows you to reuse the same format while retaining the original vendor value.

Color variants

Bring values ​​such as blue, light blue, and navy blue together into the same color group.

Sizes and materials

Associate different spellings and vendor values ​​with the same size or material group so that similar values ​​appear the same in your output.

Condition and availability

Link supplied values ​​to the fixed groups that Nifelo supports for condition and availability.

From import to export value

This is how normalization works in Nifelo

You link a source value once to the desired normalization group. Nifelo can then reuse that link for subsequent imports and exports.

View the different source values

Nifelo collects the different values ​​that occur with active products for the selected SmartField.

Connect to a permanent group

Choose the appropriate group for each source value. Existing links will be reused for subsequent imports.

Manage the matrix

View which group is linked per source value and adjust the link if a different layout fits better.

Use the value in the export

Nifelo uses the fixed group value or available translation. Without linking, the original source value remains.

Normalization matrix and groups

Manage and reuse one link

In the normalization matrix you can see which fixed group belongs to each source value. You can also manage the names that are available for your active languages ​​per group.

Normalization field: Colors
Normalization matrixManage groups
Source value → normalization group
Blueblue
Light blueblue
Navy blueblue
Dark blueblue
Ecrubeige
Translations from group blue
NLblue
DEblau
ENblue
FRbleu

Multiple source values ​​can use the same normalization group, while you set a different output value per language.

Supported SmartFields

Normalize color, size, material, condition and availability

You can use your own groups for color, size and material. Condition and availability work with fixed groups.

Colour

Bring color variants together.

Own groups possible

Mate

Group measure values ​​and spellings.

Own groups possible

Material

Bundle of material names.

Own groups possible

Condition

Use new, used or refurbished.

Fixed groups

Availability

Use in_stock, out_of_stock, preorder or backorder.

Fixed groups
Source value is retained

Normalizing does not change what the supplier has supplied

The original value is retained. Nifelo also stores the associated normalization group separately and only uses it when normalization is enabled for the field in question.

Imported SmartFieldNavy blueThe original color value
Standardization groupblueSeparately stored result
Dutch file exportblueTranslation for the chosen export language

If normalization is turned off or a link is missing, the export uses the original source value.

Frequently asked questions

Good to know about data normalization

What does normalizing product data mean?

Normalizing product data means that different values ​​that mean the same or something similar are linked to one fixed group. For example, blue, light blue and navy blue can all fall under the same color group.

Which SmartFields can Nifelo normalize?

Nifelo supports standardization for color, size, material, condition and availability. You can use your own groups for color, size and material. Condition and availability work with fixed groups.

Will the original SmartField value be overwritten?

No. The imported source value is retained. Nifelo stores the normalization result separately and uses it during export when normalization is active for the field in question.

What happens if a source value is not linked?

If no link exists, Nifelo uses the original source value. This also happens when normalization for the field is disabled.

Can a group be given a different name per language?

Yes. Translations can be recorded per group for the active project languages. For a file or feed export, Nifelo can use the translation that corresponds to the selected export language.

What happens to new source values?

New, yet unknown source values ​​become visible in the normalization matrix. There you link them to the appropriate group; then that saved link is reused on subsequent imports.

From source variant to usable output

Use one fixed classification for diverse product values

Link different source values ​​to fixed groups, manage translations per language and use the normalized values ​​in your exports without overwriting the original product data.