JDBC Driver for GMO MakeShop

Build 24.0.9062

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

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