OrderItemOptionValues
Returns data from OrderItems table.
Table Specific Information
Select
The ID of the corresponding Order-Item is required to perform a SELECT query on OrderItemOptionValues:
SELECT * FROM [OrderItemOptionValues] WHERE OrderItemId = 2522;
Columns
| Name | Type | References | 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 |
OrderItems.Id | 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 | String | 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. |