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:
<IMPORT-DIRECTORY>/<PREFIX>_<FILENAME>_<COUNTER>.<SUFFIX>
<IMPORT-DIRECTORY>:

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

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:
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

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

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,,,,,,,,,,,,