Skip to main content

Standardizing values and terminology

Make attribute values, units and terms consistent across your catalog, whatever source the data came from.

Product data comes from many sources: suppliers, imports, GS1, AI output and manual edits. Each source writes values in its own way. Standardization brings those values into one format, so your catalog stays consistent.


What standardization does

Standardization checks attribute values and rewrites them to the format and terminology you choose. It does not invent new information; it makes existing information consistent.

Examples:

  • Units: "500ML", "0,5 l" and "500 ml" → 500 ml

  • Colors: "Navy", "dark blue" and "donkerblauw" → Dark blue

  • Sizes: "XL", "Extra Large" and "x-large" → XL

  • Brands: "PHILIPS", "Philips." and "philips" → Philips

  • Terms: "RVS" and "stainless steel" → your preferred term

  • Number format: decimal separator, thousand separator and spacing


Why standardization matters

Inconsistent values cause problems for:

  • storefront filters, where one color appears three times

  • search, where customers miss products

  • Google Shopping and marketplaces, which reject or misclassify products

  • translations, where the same term is translated in different ways

  • reporting and catalog quality


Common use cases

  • cleaning up supplier data after an import

  • bringing GS1 data into your own format

  • merging attribute options that mean the same thing

  • preparing filters for a new category

  • keeping AI-generated values in line with your terminology


How standardization works

You choose:

  1. which attributes to standardize

  2. which products are in scope

  3. the format and terms the values should follow

Elovate then checks each value and proposes the standardized version. You can test on a few products first, review the results and then run it on the full scope.

Results go through moderation when that is enabled. Values only sync to Magento after they are approved.


Standardization in a workflow

Standardization works best as a step after data comes in and before content is written or translated:

  1. Import or GS1 lookup brings in the data

  2. Attribute Extraction fills missing attributes

  3. Standardization makes the values consistent

  4. Content Enrichment writes titles and descriptions

  5. Translation creates the other storeviews

With a continuous workflow, new and changed products are standardized automatically.


Related tools

  • Master rules – fixed IF–THEN rules that change values during import.

  • Glossaries – fixed terms and brand names for AI output and translations.

  • Search & Replace – one-off corrections across many products.

Use standardization when the same kind of inconsistency keeps coming back, and these tools for fixed rules or one-off fixes.


Best practices

  • Agree on your format first: units, capitals, spelling and preferred terms.

  • Start with attributes used in filters, such as color, size and material.

  • Test on products from different suppliers to catch edge cases.

  • Add your preferred terms to a glossary so AI output and translations follow them too.

Did this answer your question?