Attribute data structure

Data structure

The import/export file follows this data structure:

  • code (required): the attribute code.
  • type (required): the Akeneo PIM attribute type.
  • localizable (required): boolean field (0 or 1) defining if the attribute is localizable or not.
  • scopable (required): boolean field (0 or 1) defining if the attribute is scopable or not.
  • group (required): the attribute group of the attribute. Default value is “other”.
  • label-<locale_code>: each label in a dedicated column (See Localized labels).
  • unique: boolean field (0 or 1) defining if the value of this attribute is unique. Its value should be 1 for the pim_catalog_identifier.
  • useable_as_grid_filter: defines if the attribute can be used as a filter in Akeneo PIM
  • allowed_extensions: file extensions allowed for the attribute. Only available for pim_catalog_image and pim_catalog_file.
  • metric_family (required for pim_catalog_metric): The metric family from the Akeneo MeasureBundle (see MeasureBundle measures).
  • default_metric_unit (required for pim_catalog_metric): The default metric unit from the Akeneo MeasureBundle (see MeasureBundle measures).
  • reference_data_name (required for pim_reference_data_simpleselect and pim_reference_data_multiselect): the data name you used in the config.yml to configure your reference data.

Note

File example:

type;code;label-en_US;label-fr_FR;group;unique;useable_as_grid_filter;allowed_extensions;metric_family;default_metric_unit;reference_data_name;localizable;scopable
pim_catalog_identifier;sku;SKU;SKU;marketing;1;1;;;;;0;0
pim_catalog_text;name;Name;Nom;marketing;0;1;;;;;0;0
pim_catalog_textarea;description;Description;Description;marketing;0;1;;;;;1;1
pim_catalog_number;optical_zoom;Optical zoom;Zoom optique;technical;0;1;;;;;0;0
pim_catalog_boolean;image_stabilizer;Image stabilizer;Stabilisateur d'image;technical;0;1;;;;;0;0
pim_catalog_simpleselect;sensor_type;Sensor type;Type de capteur;technical;0;1;;;;;0;0
pim_catalog_multiselect;multifunctional_functions;All-in-one functions;Fonctions tout-en-un;technical;0;1;;;;;0;0
pim_catalog_date;release_date;Release date;Date de sortie;marketing;0;1;;;;;0;1
pim_catalog_metric;weight;Weight;Poids;technical;0;1;;Weight;KILOGRAM;;0;0
pim_catalog_price_collection;price;Price;Prix;marketing;0;1;;;;;0;0
pim_catalog_image;picture;Picture;Photographie;media;0;1;jpg,jpeg,gif;;;;0;0
pim_catalog_file;pdf_description;PDF description;Description PDF;media;0;1;pdf;;;;0;0

Attribute types

Attribute type Description
pim_catalog_identifier It is the unique product’s identifier. The catalog can contain only one.
pim_catalog_text Text
pim_catalog_textarea Long text
pim_catalog_boolean Yes/No
pim_catalog_number Number (integer and float)
pim_catalog_simpleselect Simple choice list
pim_catalog_multiselect Multiple choice list
pim_catalog_date Date
pim_catalog_metric Metric. It links a value and a unit like a weight.
pim_catalog_price_collection Collection of prices. Each price contains a value and a currency
pim_catalog_image Image
pim_catalog_file File