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.
| Column | Value |
|---|---|
| _custom_option_store | Identifies the store view where the custom option is available. |
| _custom_option_type | Identifies 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_title | The text that is used as a label to identify the custom option. |
| _custom_option_is-required | Determines if the custom option is a required entry. Options include: Yes / No. |
| _custom_option_price | A 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_sku | A 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_characters | Determines the maximum number of characters that can be entered in a text field. |
| _custom_option_sort_order | Determines the order in which options are listed. |
| _custom_option_row_title | The title that is associated with an individual row of a “select” option type. |
| _custom_option_row_price | A 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_sku | A 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_sort | Determines the sequence in which options are listed for “select” option types. |
