JDBC Driver for GMO MakeShop

Build 24.0.9062

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.
For example, the following queries are processed server side:
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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062