ProductSelectOptions
Returns data related to option selections.
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 ProductSelectOptions WHERE BrandCode = 'CD12345'
Columns
Name | Type | Description |
BrandCode [KEY] | String | System product code. |
OptionId [KEY] | String | Option id. [Option 1 node option ID]_[Option 2 node option ID]. |
OptionUbrandCode | String | Option-specific code. |
OptionPrice | Integer | Option-specific price. |
OptionStock | Integer | Option stock quantity. |
OptionJanCode | String | Option JAN code. |