Knowledge Base

Search

  • Video block
  • Video Tutorials

  • Watch our easy-to-follow video tutorials for quick tips on designing and managing your store.
  • View Video Tutorials

Exporting Custom Options

If a product has custom options, any data that is associated with the option is exported to a corresponding column in the output file. Before attempting to import records with custom options, you should export a set of product data, so you can see exactly how the custom options are represented in the resulting CSV or XML file.

The following columns in the exported data contain the values for any custom option that is associated with a product record.

ColumnValue
_custom_option_storeIdentifies the store view where the custom option is available.
_custom_option_typeIdentifies the type of input control used during data entry. Options include:
Text:  Field, Area
Select:  Drop-down, Radio Buttons, Checkbox, Multiple Select
Date:  Date, Date & Time, Time
_custom_option_titleThe text that is used as a label to identify the custom option.
_custom_option_is-requiredDetermines if the custom option is a required entry. Options include: Yes / No.
_custom_option_priceA price adjustment that is associated with the option. The value can be a fixed amount, or a calculated percentage of the product price.
_custom_option_skuA suffix that is added to the main product SKU to identify the option. The option SKU is included on invoices and other reports, but is not a true “stock keeping unit,” because inventory is not tracked for custom option values.
_custom_option_max_charactersDetermines the maximum number of characters that can be entered in a text field.
_custom_option_sort_orderDetermines the order in which options are listed.
_custom_option_row_titleThe title that is associated with an individual row of a “select” option type.
_custom_option_row_priceA price adjustment that is associated with an individual row of a “select” option type. The value can be a fixed amount, or a calculated percentage of the product price.
_custom_option_row_skuA suffix that is added to the main product SKU an associated with an individual row of a “select” option type. The SKU associated with a custom option appears on invoices and other reports, although inventory cannot be tracked based on the value.
_custom_option_row_sortDetermines the sequence in which options are listed for “select” option types.

See also:

Creating Custom Options

How Custom Options and Configurable Product Options Differ

Still have questions? Submit them below and they'll be answered by our expert support team.
Like what you read? Drop us a note with your feedback below.