File details - product_abstract.csv

Last updated:
Edit on GitHub
You are browsing a previous version of the document. The latest version is 202212.0.

This document describes the product_abstract.csv file to configure Abstract Product information in your Spryker Demo Shop.

To import the file, run

data:import:product-abstract

Import file parameters

The file should have the following parameters:

PARAMETER REQUIRED TYPE REQUIREMENTS OR COMMENTS DESCRIPTION
category_key ✓ String Identifier of category key name.
category_product_order Integer Order of the product presentation inside a category.
abstract_sku ✓ String SKU identifier of the abstract product.
name.{ANY_LOCALE_NAME}
Example value: name.en_US		 ✓ String Locale data is dynamic in data importers. It means that ANY_LOCALE_NAME postifx can be changed, removed, and any number of columns with different locales can be added to the .csv files. Name of the product in the specified location (US for our example).
url.{ANY_LOCALE_NAME}
Example value: value_1.en_US		 ✓ String URL page of the product image in the specified location (US for our example).
is_featured String If it is empty, will be “False”.
False = 0
True = 1		 Indicates if it is a featured product.
attribute_key_{NUMBER}
Example value: attribute_key_1
 ✓ (if this attribute is defined) String Product attribute key for the attribute.
value_{NUMBER}
Example value: value_1
 ✓ (if this attribute is defined) String Product value for the attribute.
attribute_key_{NUMBER}.{ANY_LOCALE_NAME}
Example value: attribute_key_1.en_US
 String Product attribute key, for the first attribute, translated in the specified locale (US for our example).
value_{NUMBER}.{ANY_LOCALE_NAME}
Example value: value_1.en_US
 String Product value for the attribute, translated in the specified locale (US for our example).
color_code String Product color code.
description.{ANY_LOCALE_NAME}
Example value: description.en_US		 String Product description, translated in the specified locale (US for our example).
icecat_pdp_url String Icecat product catalogue URL service.
tax_set_name String Name of the tax set.
meta_title.{ANY_LOCALE_NAME}
Example value: meta_title.en_US		 String Meta title of the product in the specified locale (US for our example).
meta_keywords.{ANY_LOCALE_NAME}
Example value: meta_keywords.en_US		 String Meta keywords of the product in the specified locale (US for our example).
meta_description.{ANY_LOCALE_NAME}
Example value: meta_description.en_US		 String Meta description of the product in the specified locale (US for our example).
icecat_license String Icecat product catalogue license code.
new_from Date To be considered a new product from this presented date.
new_to String To be considered a new product until this presented date.
avalara_tax_code String Avalara tax code for automated tax calculation.

Import file dependencies

This file has the following dependencies:

Additional information

For each attribute, where N is a number starting in 1, it is mandatory to have both fields:

  • attribute_key_N
  • value_N

The amount of attributes is not limited.

Import template file and content example

Find the template and an example of the file below:

FILE DESCRIPTION
template_product_abstract.csv Import file template with headers only.
product_abstract.csv Exemplary import file with the Demo Shop data.