ADO.NET Provider for Lohaco

Build 21.0.7930


Retrieve and update information related to item groups.


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, Display and Status support the following operators: =, IN, and NOT IN.
For example, the following query is processed server side:

SELECT * FROM Groups WHERE GroupCd = 'group code'

SELECT * FROM Groups WHERE Display =1

SELECT * FROM Groups WHERE Status = 3
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 Group

INSERT INTO ItemImages#TEMP (FileName) VALUES ('dog.jpg')")

INSERT INTO ItemAttributes#TEMP (AttributeCd,AttributeValueCd) VALUES ('8021',40000)")

INSERT INTO ItemAttributes#TEMP (AttributeCd,AttributeValueCd) VALUES ('242P',40100)")

INSERT INTO GroupAttributes#TEMP (AttributeCd,AttributeValueCd) VALUES ('237P',40100)")

INSERT INTO GroupCategories#TEMP (SCategoryCd,RepresentsFlag) VALUES ('74020010001',1)")

INSERT INTO items#TEMP (ItemCd,ItemName,ItemNameKana,Price,ValidityEndDate,ValidityStartDate,SaleEndDate,SaleStartDate, OutletFlag,StockOverFlag,RepresentativeFlag,DeleteFlag,SalesUnitNum,LinkedItemImages,LinkedItemAttributes) VALUES ('1231231123','test api ardit','test api ardit kana ',123,'2018-11-30','2018-11-09','2018-11-30','2018-11-09', 0, 1,1,0,2,'ItemImages#TEMP','ItemAttributes#TEMP')")

INSERT INTO GROUPS (GroupCd,GroupName,GroupDescription,BrandCd,DayDeliveryFlag,DeleteFlag,Display,WayReflect,SizeTableInfo,LinkedItems,LinkedGroupAttributes,LinkedGroupSizeAttributes,LinkedGroupCategories) VALUES ('t-hunglead-newom-arditgropupfromapi1','samplegroup2-ardit','samplegroup-ardit','31010010152','0','0','1','1','S=s1|M=m1|L=l2','Items#TEMP','GroupAttributes#TEMP','GroupCategories#TEMP')")


Lohaco allows updates. Groupcd should be spefied

Update Groups set GroupDescription='New Name' GroupCd='group Code'


Items can be deleted by providing the ItemCd and GroupCd .

DELETE FROM Groups WHERE GroupCd='group Code'


Name Type ReadOnly References Description
SellerId String False

The Id of the seller.

GroupCd [KEY] String False

Product group code.

GroupName String False

Product group name.

GroupDescription String False

Product group description.

BrandCd String False

Brand code. In case of fashion category, it is mandatory.

BrandName String False

Brand name. In case of fashion category, it is mandatory.

Display Integer False

Page release. Private: 0, Public: 1. Search defaults to 1.

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

DayDeliveryFlag Integer False

Next day delivery flag.Not supported: 0, Same day delivery: 1, Next day Delivery: 2, Stock Now: 3.

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

ShipLeadTimeInfo String False

Estimated shipping based on Asutsuku flag and store settings.

ShipLeadTimeInfoOrigin String True

Estimated shipping (as set by the store).

SoldoutOutput String False

Display wording at the time of selling out. 1: Store settings enabled (the default), 2: Out of stock, 3: Undecided stock , 4: End of handling, 5: Free input.

使用できる値は次のとおりです。1, 2, 3, 4, 5

SoldoutOutputCode Integer True

Code value representing display wording at the time of selling out.

SoldoutOutputFree String False

Code value representing display wording at the time of selling out.

AgeLimit Integer False

Age limit. Required for categories requiring age restriction setting.

DeliverySize Integer False

Delivery size.

TemplateType String True

Template classification. Return 'fashion'.

LpmSpecificGroupCd String True

Special group code. Returned only when seller id is not specified.

MakerCd String False

Manufacturer code.

Status Integer True

Registration status.Operation: 1,Waiting for reflection: 2, Temporary storage: 3.

FreeSpace String False

URL encoded HTML free content.

RecommendItemTitle String True

Recommended product title.

AboutShippingFeeShort String True

Shipping comment.

ReflectDate Datetime False

Date and time information on the reflection.

SizeTableInfo String False

Serial number to identify Lohako size.

LinkedItems String False

LinkedGroupAttributes String False

LinkedGroupSizeAttributes String False

LinkedGroupSizeTables String False

LinkedGroupAxisAttributes String False

LinkedGroupCategories String False

LinkedGroupImages String False

LinkedGroupRecommends String False

DeleteFlag Integer False

Delete flag. Outlet object: 1, not subject: 0. When the discount rate is less than 30% (setting file), it can not be set as outlet target (1).

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

WayReflect Integer True

Registration status.Operation: 1,Waiting for reflection: 2, Temporary storage: 3.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ItemCd String

Filter by product codes.

CatalogItemCd String

Filter by product catalog codes.

SaleTargetDate Datetime

Sales period searched for date and time.

SearchType Integer

Sales period search type. 1 : Not started to sell, 2: Including sales period, 3: Sale has been completed. Defaults to 1.

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

PromotionalCd String

The promotional code.

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