JDBC Driver for BigCommerce

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462