Skip to main content

Product options template

Create and update BigCommerce product options using Shift.

Product options are used to create customisable products, such as T-shirts with different sizes and colours.

tip

Check out our step-by-step guides for how to import & export.

Quick start

The best way to get started is to run an export and use the file as a guide to the format required.

You can also download the product options template.

Import & export columns

Basic columns

FieldsDescription
ModeThe import mode for this row. See import modes for more information.
Option IDThis is the unique identifier provided by BigCommerce for existing product options. It's unique per BigCommerce store.
This field is required to update existing product options.
Product IDThe unique identifier for the product that the option is attached to
Product SKUThe SKU of the product that the option is attached to.
Display NameThe label for the product option, e.g. Size, Color
Sort OrderProduct options are ordered ascending by this numeric field
TypeRefers to how the options will be displayed on the storefront.
Allowed values are: radio_buttons, rectangles, dropdown, product_list, product_list_with_images and swatch.
Image URLPublic URL for an image. Used for swatch product options.
NameThe unique option name, auto-generated from the display name, a timestamp. Internal only.

Option Values columns

Each option will have one or more values. E.g. for a Size option, the values could be Small, Medium, Large.

When there are multiple values, the fields for each will have a numeric suffix, e.g. 1, 2, 3, etc.

FieldsDescription
Option Value 1 IDThe unique identifier for the product option value
Option Value 1 Is DefaultThe default option value will be automatically selected on the storefront. ?
Allowed values: Yes, No, 1, 0, True, False
Option Value 1 LabelThe text label for the option value, e.g. Small, Medium, Large.
Option Value 1 Sort OrderProduct option values are ordered ascending by this numeric field
Option Value 1 DataExtra data describing the product option value.

Supported actions

Shift supports:

  • Updating the product option display name, value labels and sort orders.

Shift does not support:

  • Automatically creating variants for the product options & values.
  • Deleting option values

Export filters

You can filter options that are exported, by choosing to export options for products that match one of the following filters:

  • Product ID Range
  • Brands
  • Categories
  • Purchasability
  • Condition
  • Date updated
  • Visibility
  • Keyword
  • Name

Available filters when exporting product options

tip

As you reduce the number of items in your export, or change what data should be included, the estimate of the number of records and duration of the export will be updated.

info

An accurate estimate for product options cannot be provided so only an indication is given.