In this article, we explain what language-, country- and currency-specific attributes are and how to add them to a product list
- Add attributes such as colour, weight, size and main keywords to identify gaps and inconsistencies in product content.
- Add the attribute 'RSP' (Recommended Retail Price) to measure price deviations.
Language-, country- and currency-specific attributes
You can additionally add language-, country- and currency-specific values as attributes to a product list. For instance, in the case of the RSP:
- Language: RSP [ISO language 2-letter code]. e.g. RSP [nl_NL]
- Country: RSP [ISO country code]. e.g. RSP [GB]
- Currency: RSP [ISO currency code]. e.g. RSP [SEK]
Our tool determines which value is applicable at which time, based on the retailer and associated country, currency and language. The order applies as above. 'Fallback' is the default (without addition -> RSP itself).
Image 1: example of Language-, country- and currency-specific RSP
In the example (image 1) above, this means that the tool will apply the following order of values:
- First, the value in column AD because it is the most specific (language-country combination). For instance, the case for rows 2,10 and 11.
- Then the value in column Z, because it is the 2nd most specific (country-specific). For instance, the case for rows 6 and 21.
- Then the value in column AC, because this one is not so specific since the euro currency is used in many countries. For instance, the case for row 4.
- And last, the value in column AB, which is the 'fallback'. For instance, the case for rows 1 and 2.
In Belgium, both the Dutch and French languages are spoken. In that case, you can add a language-country combination - a column with the title: RSP [nl_BE] and a column with the title: RSP [fr_BE] if the values differ per language.
More than 1 value applies
If more than one value may apply, the range is displayed; e.g. if multiple country-specific RSPs are specified for 1 product (and in combination with currency and languages), and the retailers are displayed NEXT to each other. that only applies in the 'Pricing overview' widget.