Product scopes
The import functionality provides a possibility to import values on different scopes.
Therefore, all scope specific values have to be added on a separate row for each scope, which represents a store view, like
| sku | store_view_code | attribute_set_code | product_type | name | description | url_key | … |
|---|---|---|---|---|---|---|---|
MB-2401 |
Default |
simple |
Duffle Bag |
This the default description. |
duffle-bag |
||
MB-2401 |
de_DE |
Default |
Reisetasche |
Das ist die deutsche Beschreibung. |
reisetasche |
||
MB-2401 |
fr_FR |
Default |
Sac Marin |
C’est la description par défaut. |
sac-marin |
||
MB-2401 |
es_ES |
Default |
Bolsa de Lona |
Esta es la descripción por defecto. |
bolsa-de-lona |
|
The column |
Translateable Values
|
Not all attributes can have different values per scope. |
-
In general, all product attributes that have been created with scope
Store Viewcan be translated. -
To determine which attributes have the scope
Store Viewopen the Backend and go to the overview with the product attributes by clicking on the navigation path.
Select the filter Store View and press enter.
The result should look like
Most of the default attributes have a dedicated column in the CSV file and can be translated by adding the appropriate value to a row with the proper store view scope. But all attributes that have been user-defined, either in the backend or by a developer, do not.
To find out which columns are user-defined, use your preferred SQL editor and enter a SQL statement like
It should give you a list of all user-defined attributes.
All user-defined attributes can be imported by adding the appropriate key-value pair to the additional_attributes column to make the import as flexible as possible.
The example below shows a part of a CSV file with scope specific values for the columns name, description, and test
| sku | store_view_code | name | description | additional_attributes | … |
|---|---|---|---|---|---|
MB-2401 |
Duffle Bag |
This the default description. |
"test=english,activity=Gym|Hiking" |
||
MB-2401 |
de_DE |
Reisetasche |
Das ist die deutsche Beschreibung. |
"test=german" |
|
MB-2401 |
fr_FR |
Sac Marin |
C’est la description par défaut. |
"test=french" |
|
MB-2401 |
es_ES |
Bolsa de Lona |
Esta es la descripción por defecto. |
"test=spain" |
For more details about Additional Attributes read the dedicated section for additional attributes