ADO.NET Provider for Lohaco

Build 21.0.7930


Retrieve information related to group categories.


The 本製品 will use the Lohaco API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • GroupCd support the following operators: =.
For example, the following query is processed server side:
SELECT * FROM GroupCategories

SELECT * FROM GroupCategories WHERE GroupCd='group code'
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.


To add a new GroupCategories

Insert into GroupCategories (GroupCd,SCategoryCd,RepresentsFlag) values ('group code','74020010001',1)


GroupCategories can be deleted by providing the AttributeCd and GroupCd .

DELETE FROM GroupCategories WHERE GroupCd='t-hunglead-newom-sample0groupardit' AND AttributeCd='attributecd'


Name Type ReadOnly References Description
SellerId String False

The Id of the seller.

GroupCd [KEY] String False


Product group code.

SCategoryCd [KEY] String False

Small category code.

SCategoryName String False

Small category name.

MCategoryCd String True

Medium category code.

MCategoryName String True

Medium category name.

LCategoryCd String True

Large category code.

LCategoryName String True

Large category name.

LlCategoryCd String True

Double large category code.

LlCategoryName String True

Double large category name.

RepresentsFlag Integer False

Representative category flag.Other: 0, Representative: 1.

使用できる値は次のとおりです。0, 1

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930