ProductOptionGroupItems
Returns data related to option groups and their items.
Select
The 本製品 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 本製品.
- BrandCode column supports the = operator.
SELECT * FROM ProductOptionGroupItems WHERE BrandCode = 'CD12345'
Columns
Name | Type | Description |
BrandCode [KEY] | String | System product code. |
GroupCode | String | Group code. |
GroupName | String | Group name. |
OptionId [KEY] | Integer | Option ID. |
OptionName | String | Option name. |
IsRequired | String | Indicates if the option is required - Y: Required input N: Optional input. |
ItemId [KEY] | Integer | Item ID. |
ItemName | String | Item name. |
PriceType | Integer | Item price type - 0: Designate by amount 1: Specify at rate according to selling price. |
ItemPrice | Integer | Item price. |
Default | String | Indicator if item is initial selection - Y: Selected in initial display N: Not selected in initial display. |