Import and Export data

#Product data structure

Products are exported in a file with the following fields.

Attributes fields can be one of these:

  • sku (required): Identifier attribute (SKU is the common code)
  • clothing_size: size option code for a simple select option
  • description-en_US-mobile: localizable and scopable attribute en_US for channel mobile
  • description-fr_FR-mobile: localizable and scopable attribute fr_FR for channel mobile
  • name-fr_FR: localizable attribute fr_FR
  • name-en_US: localizable attribute en_US
  • price-EUR: numeric price value for Euro
  • price-USD: numeric price value for US Dollar
  • tshirt_style: list of option codes for a multi select option list

Associations fields:

  • <association-type-code>-groups: groups list for the <association-type-code> association type
  • <association-type-code>-product_models: list of product models codes in this association type
  • <association-type-code>-products: list of products identifiers in this association type

Product properties fields:

  • categories: list of category codes
  • enabled: boolean
  • family: family code
  • groups: list of product group codes
  • parent: product model code

File example:

sku;PACK-groups;PACK-product_models;PACK-products;SUBSTITUTION-groups;SUBSTITUTION-product_models;SUBSTITUTION-products;UPSELL-groups;UPSELL-product_models;UPSELL-products;X_SELL-groups;X_SELL-product_models;X_SELL-products;categories;clothing_size;container_material;description-de_DE-mobile;description-en_US-mobile;description-fr_FR-mobile;parent;enabled;family;groups;main_color;name;picture;price-EUR;price-USD;secondary_color;tshirt_materials;tshirt_style
AKNTS_BPXS;;;;;;AKNTS_WPXS,AKNTS_PBXS,AKNTS_PWXS;;;;;;;goodies,tshirts;xs;;;Akeneo T-Shirt;T-Shirt Akeneo;;1;tshirts;akeneo_tshirt;black;Akeneo T-Shirt black and purple with short sleeve;;10;14;purple;cotton;crewneck,short_sleeve
AKNTS_BPS;;;;;;AKNTS_WPS,AKNTS_PBS,AKNTS_PWS;;;;;;;goodies,tshirts;s;;;Akeneo T-Shirt;T-Shirt Akeneo;;1;tshirts;akeneo_tshirt;black;Akeneo T-Shirt black and purple with short sleeve;;10;14;purple;cotton;crewneck,short_sleeve
AKNTS_BPM;;;;;;AKNTS_WPM,AKNTS_PBM,AKNTS_PWM;;;;;;;goodies,tshirts;m;;;Akeneo T-Shirt;T-Shirt Akeneo;;1;tshirts;akeneo_tshirt;black;Akeneo T-Shirt black and purple with short sleeve;;10;14;purple;cotton;crewneck,short_sleeve
AKNTS_WPS;;;;;;;;;;;;;goodies,tshirts;s;;;Akeneo T-Shirt;T-Shirt Akeneo;;1;tshirts;akeneo_tshirt;white;Akeneo T-Shirt white and purple with short sleeve;;10;14;purple;cotton;crewneck,short_sleeve
AKNTS_WPM;akeneo_mug;;OROMUG_DBO,AKNSTK;;;;;;;;;;goodies,tshirts;m;;;Akeneo T-Shirt;T-Shirt Akeneo;;1;tshirts;akeneo_tshirt;white;Akeneo T-Shirt white and purple with short sleeve;;10;14;purple;cotton;crewneck,short_sleeve
AKNTS_BPXS_LS;;;;;;AKNTS_WPXS_LS,AKNTS_PBXS_LS,AKNTS_PWXS_LS;;;;;;;goodies,tshirts;xs;;;Akeneo T-Shirt;T-Shirt Akeneo;;1;tshirts;akeneo_long_sleeve_tshirt;black;Akeneo T-Shirt black and purple with long sleeve;;10;14;purple;cotton;crewneck,long_sleeve
AKNTS_BPS_LS;;;;;;AKNTS_WPS_LS,AKNTS_PBS_LS,AKNTS_PWS_LS;;;;;;;goodies,tshirts;s;;;Akeneo T-Shirt;T-Shirt Akeneo;;1;tshirts;akeneo_long_sleeve_tshirt;black;Akeneo T-Shirt black and purple with long sleeve;;10;14;purple;cotton;crewneck,long_sleeve
AKNTS_BPM_LS;;;;;;AKNTS_WPM_LS,AKNTS_PBM_LS,AKNTS_PWM_LS;;;;;;;goodies,tshirts;m;;;Akeneo T-Shirt;T-Shirt Akeneo;;1;tshirts;akeneo_long_sleeve_tshirt;black;Akeneo T-Shirt black and purple with long sleeve;;10;14;purple;cotton;crewneck,long_sleeve
OROMUG_BO;;;;;;;;;;;;;goodies;;ceramic;Oro Mug;Oro Mug;Mug Oro;;1;mugs;oro_mug;black;Oro Mug;;5;5;orange;;
OROMUG_WO;;;;;;;;;;;;;goodies;;ceramic;Oro Mug;Oro Mug;Mug Oro;;1;mugs;oro_mug;white;Oro Mug;;5;5;orange;;
OROMUG_DBO;;;;;;OROMUG_BO,OROMUG_WO,OROMUG_OW,OROMUG_OB,OROMUG_ODB;;;;;;;goodies;;ceramic;Oro Mug;Oro Mug;Mug Oro;;1;mugs;oro_mug;blue;Oro Mug;;5;5;orange;;
OROMUG_BO_P;;;;;;;;;;;;;goodies;;porcelain;Oro Mug;Oro Mug;Mug Oro;;1;mugs;oro_mug;black;Oro Mug;;5;5;orange;;
OROMUG_WO_P;;;;;;;;;;;;;goodies;;porcelain;Oro Mug;Oro Mug;Mug Oro;;1;mugs;oro_mug;white;Oro Mug;;5;5;orange;;
AKNMUG_BP;;;;;;AKNMUG_WP,AKNMUG_PB,AKNMUG_PW;;;;;;;goodies;;;Akeneo Mug;Akeneo Mug;Mug Akeneo;;1;mugs;akeneo_mug;black;Akeneo Mug;;5;5;purple;;
AKNMUG_WP;akeneo_tshirt;;;;;;;;;;;;goodies;;;Akeneo Mug;Akeneo Mug;Mug Akeneo;;1;mugs;akeneo_mug;white;Akeneo Mug;;5;5;purple;;

Found a typo or a hole in the documentation and feel like contributing?
Join us on Github!