OrderItemOptionValues

Returns data from OrderItems table.

Columns

Name

Type

Description

Id [KEY]

Integer

The numerical ID of the option value within the group of ordered items.

OptionId

Integer

The ID of the option from Product Options table.

OrderItemId

Integer

The ID of the product.

OrderItemOptionId

Integer

The numerical ID of the option within the group of ordered items.

DisplayName

String

The name of the option shown on the storefront.

DisplayValue

String

The value of the option shown on the storefront.

Value

Integer

The actual value of the option.

Name

String

The unique option name, auto-generated from the display name, a timestamp, and the product ID.

Type

String

The type of option, which determines how it will display on the storefront. Acceptable values: radio_buttons, rectangles, dropdown, product_list, product_list_with_images, swatch.

DisplayStyle

String

The specific style which the order will be displayed as.

Last updated