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 | 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. |