ProductOptionItems
Returns data related to item selection options for product.
Select
The connector will use the GMO MakeShop API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- BrandCode column supports the = operator.
SELECT * FROM ProductOptionItems WHERE BrandCode = 'CD12345'
Columns
Name | Type | Description |
BrandCode [KEY] | String | System product code. |
OptionNumber | String | Option item number (Option item 1 or 2). |
ItemId [KEY] | Integer | Selection item ID. |
ItemName | String | Selection item name. |
Default | String | Indicator if option item is initial selection - Y: Selected in initial display N: Not selected in initial display. |