Product Custom Option

Pacemaker Import Pro provides the command import:products:custom-option command for the product Custom Option import.

The individual parts of the file name must match the pattern as followed:

Example: custom-options_20190608-114344_01.csv

<IMPORT-DIRECTORY>/<PREFIX>_<FILENAME>_<COUNTER>.<SUFFIX>

<IMPORT-DIRECTORY>:

is by default the location of your working directory <ROOT-DIRECTORY>/var/pacemaker/import/

The var/pacemaker/import directory is not created after the installation by default
- see described instruction how to create the import directory

PREFIX:

The <PREFIX> of the import filename represents the custom-options area.

DELIMITER ( _ ):

The mandatory Delimiter ( _ ) for the import filename between <PREFIX> and <FILENAME> is a underscore ( _ ).

FILENAME:

The filename is a autogenerated combination of date and time.

As a result, the filename look like custom-options_20190608-114344_01.csv.

DELIMITER ( _ ):

The mandatory Delimiter ( _ ) for the structured filename between <FILENAME> and <COUNTER> is underscore ( _ ).

COUNTER:

is a incremental number with two digits starting with 01.

SUFFIX (filename extension):

The Pacemaker Import Pro uses the <SUFFIX> .csv as default for the import files.

.OK file:

In addition, the appropriate .ok file is needed (see cli import commands).

Bunch import:

The Bunch import requires the same predefined filename structure as described.

Your CSV file var/pacemaker/import/custom-options_20190608-114344_01.csv is now ready for import.

Columns

The CSV file with the attributes for Magento 2 CE/EE consists of the following columns

Column Name Type Example Description

Column Name	Type	Example	Description
custom_option_parent_sku	`varchar`	`24-MB01`	Product custom_option_parent_sku to import the custom option
store_view_code	`varchar`	`default`	Store(s) view-specific attribute translations If blank, the row contains the data for the admin store view
custom_option_value_name	`varchar`	`Option Title 01`	Custom option value name field
custom_option_value_type	`varchar`	`drop_down`	Magento custom option value type field
custom_option_value_required	`int`	`1`	Custom option value required field
custom_option_value_max_characters	`int`	`0`	Custom option value max characters field
custom_option_value_file_extension	`varchar`		Custom option value file extension field
custom_option_value_image_size_x	`varchar`	`0`	Custom option value image size on width field
custom_option_value_image_size_y	`varchar`	`joust-duffle-bag`	Custom option value image size on height field
custom_option_value_sort_order	`int`		Custom option value sort order field
custom_option_value_sku	`varchar`	`12345`	Custom option value sku field. These SKU is mandatory fields; an empty SKU will overwrite the old data with the new data, which can lead to problems.
custom_option_value_option_title	`varchar`	`Option Title 01 Value 01,Option Title 01 Value 02`	Comma ( `,` ) separated list of custom option value option title
custom_option_value_option_sku	`varchar`	`2345,6789`	Comma ( `,` ) separated list of custom option value option sku. These SKUs are mandatory fields; an empty SKU will overwrite the old data with the new data, which can lead to problems.
custom_option_value_price_type	`varchar`	`percent,fixed`	Comma ( `,` ) separated list of custom option value price type
custom_option_value_price	`int`	`10.000000,10.000000`	Comma ( `,` ) separated list of custom option value price
custom_option_value_default	`varchar`		Custom option value default field

custom_option_parent_sku

varchar

24-MB01

Product custom_option_parent_sku to import the custom option

store_view_code

varchar

default

Store(s) view-specific attribute translations

If blank, the row contains the data for the admin store view

custom_option_value_name

varchar

Option Title 01

Custom option value name field

custom_option_value_type

varchar

drop_down

Magento custom option value type field

custom_option_value_required

int

1

Custom option value required field

custom_option_value_max_characters

int

0

Custom option value max characters field

custom_option_value_file_extension

varchar

Custom option value file extension field

custom_option_value_image_size_x

varchar

0

Custom option value image size on width field

custom_option_value_image_size_y

varchar

joust-duffle-bag

Custom option value image size on height field

custom_option_value_sort_order

int

Custom option value sort order field

custom_option_value_sku

varchar

12345

Custom option value sku field. These SKU is mandatory fields; an empty SKU will overwrite the old data with the new data, which can lead to problems.

custom_option_value_option_title

varchar

Option Title 01 Value 01,Option Title 01 Value 02

Comma ( , ) separated list of custom option value option title

custom_option_value_option_sku

varchar

2345,6789

Comma ( , ) separated list of custom option value option sku. These SKUs are mandatory fields; an empty SKU will overwrite the old data with the new data, which can lead to problems.

custom_option_value_price_type

varchar

percent,fixed

Comma ( , ) separated list of custom option value price type

custom_option_value_price

int

10.000000,10.000000

Comma ( , ) separated list of custom option value price

custom_option_value_default

varchar

Custom option value default field

Product Custom Option get imported with the entire product import as default.

In this case the skus should exist, if it does not please import the products first using the product import

Example: custom-options_20200321-150148_01.csv

custom_option_parent_sku,store_view_code,custom_option_value_name,custom_option_value_type,custom_option_value_required,custom_option_value_max_characters,custom_option_value_file_extension,custom_option_value_image_size_x,custom_option_value_image_size_y,custom_option_value_sort_order,custom_option_value_sku,custom_option_value_option_title,custom_option_value_option_sku,custom_option_value_price_type,custom_option_value_price,custom_option_value_default
24-MB01,,Option Title 01,drop_down,1,0,,0,0,,12345,"Option Title 01 Value 01,Option Title 01 Value 02","2345,6789","percent,fixed","10.000000,10.000000",
24-MB01,de_de,Option Titel 01,drop_down,,,,,,,,"Option Titel 01 Wert 01,Option Titel 01 Wert 02",,,,
24-MB01,en_us,Option Title 01,drop_down,,,,,,,,"Option Title 01 Value 01,Option Title 01 Value 02",,,,
24-MB01,,Option Title 02,field,1,10,,0,0,,5678,,,fixed,10,
24-MB01,de_de,Option Titel 02,field,,,,,,,,,,,,
24-MB01,en_us,Option Title 02,field,,,,,,,,,,,,

Product Custom Option

Columns

WIR HÄTTEN IHNEN DIESE MELDUNG AUCH GERNE ERSPART ...