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 store_view_code must contains the appropriate Magento store view code and the column attribute_set_code must have a valid attribute set code.

Translateable Values

Not all attributes can have different values per scope.

  • In general, all product attributes that have been created with scope Store View can be translated.

  • To determine which attributes have the scope Store View open the Backend and go to the overview with the product attributes by clicking on the navigation path Stores  Attributes  Products.

Select the filter Store View and press enter.

The result should look like

ce products scopes scope

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

ce products scopes scope2

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